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.
Download Macro Code: drive.google.com/file/d/1zEBN...
Please like, subscribe and comments for more updates!
Thank You.

[@naveendwivedi8414]

Thanks this is wonderful to quick wrok done

[@Aakashnai]

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

[@EXCELPATHSHALA]

Thank You 😊

[@shubhtiwari7391]

Thank you for the knowledge 🎇

[@shyamdhoble5792]

It's really worth watching

[@hemanshuuttambhaitailor7184]

Thank you so much for macro code to much useful

[@bhargavisunkara2204]

Thanks a lot for the knowledge

[@EXCELPATHSHALA]

Welcome!

[@rakesh2101989]

Thank you bhai. Its Working 🙏

[@EXCELPATHSHALA]

Welcome

[@rameshkale2101]

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

[@EXCELPATHSHALA]

Thank you for your feedback.
To send attachments you can view this video
th-cam.com/video/iUykllKfkJg/w-d-xo.htmlsi=1Zm3SwU_xEN9TE2e

[@wickrumparmar7788]

Code is giving error

[@MohammadBalfaqih]

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

[@EXCELPATHSHALA]

There is no such provision in Excel but I'm working on it to give u best output.

[@gauravparab3837]

Aur agar sirf Doc chahiye rahega Pdf nhi to ??

[@EXCELPATHSHALA]

Delete pdf folder so that you can see only docs.

[@onkarshinde4424]

I m getting error as run time error 5152.

[@MDTaylor09]

I copied all my data from word into a new word document and ran it again. it worked for my pdfs but not for my new word documents and I am not sure why but in the moment I need to use this, I need the PDFs more so it's not a complete loss for me. I do hope if you repaste into a new word document and try the process again that it works for you

[@onkarshinde4424]

@@MDTaylor09 ok will check it. Will u be able to help me via anydesk or TeamViewer?

[@ajitkhot9226]

Hi I am getting error. can u pls help me out