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.

[Furthy]

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..

[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.

[johnvodopija]

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 👍😎🇦🇺

[sonexaysounantha]

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

[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.

[MaybelleMagallon]

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

[MrIbraomer]

Hi Faris,
Thank you for your Mail Merge post on YouTube,
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?

[TalkRK]

Why you can't share file over drive link

[venkatramanms]

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

[mariavenusunabia]

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.

[ajayganesh]

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

[Phron]

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

[talantiarun]

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

[sayaligawade]

Can you please share the file with macros

[bagusaditya]

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