Hey,

Thanks for the reply. A sanitised excel doc is attached.

Just to be clear, I can run the merge as normal without the VBA, output a word doc, export as PDF and split the files individually, so I would assume that the issue is with how the script is being applied rather than an issue with the documents, but I can't see any specific issues on my side.

Attached Files

Example Spreadsheet Merge.xlsx (18.1 KB, 2 views)