MACRO/VBA - Need Help Creating a Macro That Will Run Mail Merge and Save Pages as PDFs

[schneiderc97]

Hello,

I have an excel file that has 50-100 rows of contact information. I use Microsoft Word's mail merge function that uses this excel file as the data source to fill in different blanks on the template with contact information. I currently save all 50-100 results from the mail merge as PDFs and this can take up to two hours to complete every month.

I need help writing a VBA/macro that will:

1) Open the word doc and set the data source for mail merge
2) Run the mail merge
3) Save all the files as individual PDFs. (I would also like to have the titles of each PDF to match a name in the rows of the excel file.)

Any help would be greatly appreciated. I have minimal experience; so far I only have a macro that will open up the word template.

 

[schneiderc97]

(Cross posted to: https://stackoverflow.com/questions...cro-that-will-run-mail-merge-and-save-pages-a )