Mail Merge is a really useful feature built-in in Microsoft Word to create letters, labels, envelopes, or even drafting email in bulk. But not everything is perfect. One of the drawbacks with mail merge is that when you try to print each record as a single PDF file, unfortunately, Word combined all the records in one single PDF. Also, you cannot perform mail merge to save each record as their own individual Word document.

In this tutorial I am going to show with the help of VBA how we can 1) Automate Mail Merge task and 2) save each record as individual PDF or Word document.

Check out Kit (free AI Coding Assistant) Link

Buy Me a Coffee? Your support is much appreciated!
PayPal Me:
Venmo: @Jie-Jenn

For any question, please contact me at (since I don’t check on my post reply very often) with your Word template and data file attached.

VBA Script