Thank you Paul.

The documents probably could be put into a single document, and it may again show my lack of experience with Word, but the documents are all sorts of safety documents, each one of them has it's own expiry date, accreditation, etc. We keep them separate at the moment as not every document applies to every project, so we'd cherry pick which we use to create our hard copy project pack.

I did have a quick look at the sticky output macro and will have another look now as I didn't quite understand what I was looking at. I'll come back after looking at that.

Printing from File Explorer will be fine, especially if we're saving a copy of them with the macro above as that should then be printing the mail merged documents?



Thank you. Please bear with me.

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.