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.