I guess to expand on why we have 100 documents again, it's because we're using the mail merge feature to insert information into the documents, such as the Project ID, Project Manager, Project Company, Project Location, etc. It's really only ONE row in an XLS document, not 500 names & addresses like I believe mail merge was created for.

So the XLS document would have maybe 30 fields and the 100 documents would use those same 30 fields to insert that information into each document.

I'm not sure if there's an easier way to achieve what we're doing but it works a treat at the moment but I know that there are easier ways to automate what we're doing.

The main thing with the saving of the files is that they need to be named the same as the document is originally called. So if Document #1 is called 'Fire Sealant.docx' then I need that document to remain called 'Fire Sealant.docx' and save into that project folder, and even a sub folder, for that specific job.