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.