Automate Mail Merge with Excel Database using VBA (Macro)

In this video I Mail Merge a Word file using Excel file as a data source automatically by the help of visual basic programming language bundled with excel.
If you have any queries or you would like to get something like this done, you can mail me : [e-mail]

[@Furthy2]

Hey man, your video is gold! Your way of explaining how code works is amazing. Really looking forward to seeing more shares from you

[@papubhoi]

Very helpfull.. I was searching for it... Thanks a lot buddy..

[@MissMostViewed]

Glad to help

[@sonexaysounantha1097]

Thanks for the tutorial. This is superb!
Can you please share with me the codes please?

[@johnvodopija1743]

This is a very helpful tutorial. Is there an easy way to have the vba prompt the user for the input excel file? I have a use case where the excel file name will be different (but data structured the same) each time the word template is used. Thank you 👍😎🇦🇺

[@MissMostViewed]

Yes code can be created for that also email me with the details

[@keving4409]

Here are some instructions how you would create a file picker using getOpenFilename to capture the string location.
www.xelplus.com/excel-vba-getopenfilename/
Then you would simply pass that string as the datFile variable, instead of hard coding it.

[@MrIbraomer]

Hi Faris,
Thank you for your Mail Merge post on TH-cam,
I have something like your mail merge video,
I have a word file (letter) and also an Excel file that has a long list of recipients, I would like a macro to send emails with outlook to a filtered list from my Excel file everyday automatically but to only the recipients that I filter while the process of the mail merge, is that possible?

[@MissMostViewed]

yes that is possible.

[@mariavenusunabia9855]

@@MissMostViewed please help me sir

[@chanothebest]

What if I want to paste the data onto the excel sheet and then use the macro, but I want it to mail merge all the data pasted into it not just 8 letters. So this could be 10, 15,100, list of rows of data. Can the excel vba adapt.

[@MissMostViewed]

Yes that can be done with VBA coding

[@MaybelleMagallon]

good day! may i ask for a copy of your macro?? thank you.

[@mariavenusunabia9855]

thank you for this vid. this is what I am looking for. no need to preview and click finish in mail merge tab instead it needs to use vba code. unfortunately I am not so familiar with the code.. can you help me with this vba think? please... thank you in advance sir.

[@pyramidtraders7984]

kindly mail on [e-mail]

[@ajayganesh7770]

Hello.. Thanks for your support.. I have modified the code now it can save as individual pdf as well

[@MissMostViewed]

Great 👍

[@CBCSolutions]

@@MissMostViewed thank you for the video. How can the code be modified to save as individual PDFs?

[@MissMostViewed]

@@CBCSolutions email me on [e-mail]

[@TalkRK]

PLEASE SEND ME THE CODE FILE

[@bagusaditya1234]

Hi, may I have a copy of the code please? Thanks

[@TalkRK]

Why you can't share file over drive link

[@VIJAY-bq8dx]

Sir, can you please share the file??

[@MrPumaralant]

Hi, could anyone help me solving this error I'm getting.
I get the "compile error: User-defined type not defined" message when launching the code.
it then points to the Dim wdApp As Word.Applicaton line.

[@MissMostViewed]

kindly mail me on [e-mail]

[@venkatramanms3891]

I am getting error as string is longer than 255 character, and my input contains more number of columns . How to fix this issue

[@MissMostViewed]

send me a mail with all the details.

[@sayaligawade7782]

Can you please share the file with macros

[@MissMostViewed]

kindly mail me on [e-mail]

[@talantiarun]

This is very helpful. Can we able to automate for MS project with Excel Database using VBA(macro)?

[@MissMostViewed]

Thats exactly what i have done

[@kashafkhan3487]

Can you please send me this code.

[@MissMostViewed]

kindly mail me on [e-mail]

[@Phron2525]

Hi, may I have a copy of the code please? Thanks

[@Phron2525]

I sent you a email