Hi - I can't see much from just this file without the Excel file to merge from.



But, since your desired end result is a PDF format, have you tried running the mail merge without the macro, getting one file, with many pages, converting to PDF, and then using the Extract tool in Adobe, extract to individual documents? That would at least figure out whether the problem is with the merge and not the macro.

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)