Mail merge to word then save each page as individual pdf.

[LuluC]

Hi
Can anyone please help? I currently mail-merge a huge quantity of data from excel which then produces a long word document made up of 150 client data sheets. I currently print each page to pdf and save as client name to then email out individually but it is taking forever. Surely there is a quicker way? Can anyone help?

Thanks so much

Lulu

 

[Trevor G]

You can setup Word VBA to convert each document into PDF. Take a look at this video