Possible to create multiple separate files from completed mail merge?

agwalsh
agwalsh used Ask the Experts™
on
If I create a mail merge in Word and generate 10 letters, is it possible to save those letters as 10 separate PDF documents? Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Professional | Freelance Journalist | Looking for Opportunities
Distinguished Expert 2018
Commented:
Hi,

Yes, once you complete the Merge in Word, you will get copies of the merged letters in separate sheets. Simply print each one to your favourite PDF writing program and save as a PDF.

Or are you looking to do this automatically via Script or Macro?

Author

Commented:
I should have thought of that! Have suggested it but not sure how many are in question...what would you suggest if there were hundreds?
Andrew LeniartIT Professional | Freelance Journalist | Looking for Opportunities
Distinguished Expert 2018

Commented:
Hi,

I should have thought of that!

Always helps to get a fresh point of view :)

what would you suggest if there were hundreds?

If dealing with hundreds of merge copies, then I would likely ask for help from visual basic scripting experts to write a custom script to try and automate the process. I'm sure it could be done, but such a process falls outside of my personal expertise.

Regards, Andrew

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial