Problem merging to separate docs

macropod · #4 04-28-2022, 07:11 AM

Quote:

Originally Posted by speckledegg

Yes; I tried running it with and without the renaming. If I run it from Word with the renaming, then nothing happens after you select "Edit Individual Documents" - it just appears to do nothing.

That is to be expected.

Quote:

Originally Posted by speckledegg

If I keep the original name (as per your original code) and run the macro on the mailmerged document, I get the runtime error.

One apparent error in your code concerns:

Code:

        'StrFolder = .DataFields("Folder") & "\"
        StrName = .DataFields("Folder_Name") & "_" & .DataFields("Last_Name")

which should be:

Code:

        StrFolder = .DataFields(Folder_Name") & "\"
        StrName = .DataFields("Last_Name")

To see why, look at the .SaveAs line...

Apart from that, there is no obvious reason why the runtime error would have anything to do with:

Code:

.Destination = wdSendToNewDocument

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge into Separate Docs	chrnon	Mail Merge	1	04-27-2022 03:08 PM
Merging of colums from two different docs & create a new doc	ranjan	Word VBA	9	08-31-2021 08:25 AM
Extra blank page at end of each document when merging to separate documents.	Blondyvl	Mail Merge	1	12-03-2020 04:33 PM
Merging Various .docs Via Q&A	Wants_It_Simple	Word	1	06-30-2014 10:26 PM
Adding identical footers to 187 separate docs	sqzdog	Word	11	10-31-2011 01:46 AM