Mail Merge to Separate PDFs and Docs with Custom File Names. VBA Code. Easy!

I will tell you the best way of converting your Mail Merge into separate PDF documents and in the Separate Word Document so that each PDF and document has an individually defined file name in the defined folder location.

With the help of Word Macro to avoid horrible complex process, any need for a paid-for third-party plug-in, and if you've got that far, any need to re-name and sort out a folder full of PDF files.

In this video we will take you through the process of adding the Macro, setting up the data and running the Mail Merge to PDF and word document.

Please like, subscribe and comments for more updates!

Thank You.

[Aakashnai]

This is literally best and shortest and easiest way to get this work done.
Thank you so much for sharing this.

[michealnadar]

Thank you so much!!! you saved several hours with this for me.

[hemanshuuttambhaitailor]

Thank you so much for macro code to much useful

[Chinni]

Worked for one time
Next onwards getting runtime error 5941

[rameshkale]

Very nice short code and easy to use. Thank you for this video.
Can you please add email section with to, cc, bcc, from, subject, attachment option to similar automation.
So that once the pdf is generated it gets send to respective users as well. Currently I am performing this by running separate code in excel based macros

[hrushikeshmuddebihalkar]

Dear sir, Thank you so much for this solution. With your guidance I could complete this year my letters work in 10 min instead of one full day in last week.

Thank you once again

[naveendwivedi]

Thanks this is wonderful to quick wrok done

[MohammadBalfaqih]

can you get us a code for ( How to mail merge with PDF attachments ) ?

[gauravparab]

Aur agar sirf Doc chahiye rahega Pdf nhi to ??

[onkarshinde]

I m getting error as run time error 5152.