The code below opens a Word Mail Merge document, populates the Mail Merge fields with data from the active row of the worksheet, and prints that document to a PDF. Everything works fairly well except for the printing of PDF. The Word document gets populated with the correct row od data but, when the PDF gets created, all the Mail Merge fields are empty and the field codes get "printed".
I've tried moving the print-to-PDF code around to different places, but I get the same results.
Also, when the macro finishes the Word document stays open. Shouldn't the "wdocSource.Close SaveChanges:=False" statement close the file?
Any ideas on what I'm doing wrong?
Thank you very much.
Bookmarks