What I said you should do is to save the document with the macro to the same folder as the original Word documents; there is no need to move any of them to another folder. Only the Excel file (named 'ProjectDataFile.xlsx') needs to be in the output folder. Once the macro has been run, the output folder (i.e. the folder containing the Excel data file) will contain the merged versions of the original Word documents. Those files won't contain any merge links to any Excel file or other copies of your mailmerge main documents.

Please confirm that you're able to get the results as described when you implement the process as specified.



Yes, I can re-write the macro to work with sub-folders, but it would have been helpful had you mentioned their existence beforehand. Do you need the output files to be in sub-folders also?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Paul.

Yep, I edited the post as I hadn't read what you had typed well enough. The macro works fine and as intended.

The problem I'm having is that we've previously gone into each of the x100 mail merge MAIN files and clicked on Select Recipients > Use An Existing List, then selected the XLSX file that I used to store in My Documents. Then we saved each mail merge MAIN file with that link in place.

When I ran the script, those files did not work as I'm assuming the linked list is overwriting your macro or something similar? Is there a way to delete the link from the mail merge MAIN files so that they work the same as the ones that didn't have an existing saved link to the XLSX file?

============

In regards to the subfolders, sorry for not bringing this up at the start.

Basically the folder directory is like this:

-FOLDER ROOT
-#File-Index (now with macro)
---FOLDER S1
---#Files-x10 (estimate)
---FOLDER S2
---#Files-x10 (estimate)
---FOLDER S3
---#Files-x10 (estimate)
---FOLDER S4
---#Files-x10 (estimate)
---FOLDER S5
---#Files-x10 (estimate)
---FOLDER S6
---#Files-x10 (estimate)
---FOLDER S7
---#Files-x10 (estimate)
---FOLDER S8
---#Files-x10 (estimate)
---FOLDER S9
---#Files-x10 (estimate)
---FOLDER S10
---#Files-x10 (estimate)
---FOLDER S11
---#Files-x10 (estimate)
---FOLDER S12
---#Files-x10 (estimate)

That's how the template folder is and that's how the output needs to be. Basically it would need to be a like-for-like scenario. However it's laid out in the template folder that we copy for each project would be how we'd like the structure to end up.

In order to test the macro I'm currently moving x10 files from S1 and x10 files from S2 into the ROOT directory with the macro.

Thank you, and apologies if I'm a bit vague, I'm quite new to the mail merge side.

I've figured out how to remove the 'link' to the old XLSX file. They all work as intended now. The only other part would be the subfolder structure. Thank you.

EDIT: No I didn't. The macro doesn't work with the files once I turn them into a normal document unfortunately. Still need assistance here.