Excel Magic Trick 1225: Excel/Word Mail Merge for Customer Accounts Receivable Letter or E-mail

[@MRaedAlLulu]

This is beyond professional, Mike. Million thanks, and see you next trick.

[@gie6696]

Thanks a lot… there’s so many videos out there but I found yours more clearer and easy to follow!

[@simoiyahector-morales9521]

Sir now watching this video for the first time and I can't thank you enough. Great job may God bless you.

[@vikramraghuwanshi9455]

In such a way of beautifuil presentative information done by you , explained a such concepts in just a way.

[@excelisfun]

You are welcome!

[@pmsocho]

Mail merge is awesome! Thanks for formatting trick!

[@excelisfun]

pmsocho You are welcome!

[@WoodsZacharyWoods]

You are the Godfather of Spreadsheets, bro.

[@excelisfun]

+Zachary Woods , Glad you like the videos!

[@krn14242]

Thanks Mike. Great video on the power of mail merge. Love it.

[@excelisfun]

krn14242 , Cool! Thanks, WRH!!!

[@sandeepsarkar2919]

Mr. Mike, thanks for sharing such wonderful lesson. How to add 'CC' or 'BCC' in mail merge? Please advice.

[@ricardobrizuela7589]

excelent video! thumbs up! I have a question; what if i want to add a "CC" and/or "BCC" e-mail address??

[@abdullahalanazi1595]

I have the same question 👍🏻

[@abdullahalanazi1595]

Thanks a lot but I have in issue which is, How can I send the same nonfiction to the employee and manager at the same time. Can you help me plz

[@Birdlady786]

Thank you sure made this very simple for me. Great work!

[@planiolro]

excellent video on Mail Merge. I hope is not going to be last one on this topic. Mail Merge is a powerful tool as long as you master it. When you use Mail Merge with Outlook is there a way to make the subject line dynamic? For instance I would like to indicate in the subject line the name of the recipient of the email and currently this is not possible.

[@excelisfun]

With Regular Mail Merge, I do not know how to do it. Maybe it is possible with VBA code.

[@Tat-cx1lr]

Bonjour Tout d’abord merci pour ce partage. J’ai essayé votre méthode pour envoyer les états de facturation par mail. Malheureusement cela ne marche. L’ objectif est d’avoir toutes les lignes facturées sur le même mail pour chaque client. Merci d’avance pour votre aide. Amicalement

[@hojeda1990]

Any ideas on how to have a dynamic subject?

[@LuisLopez-ey5zz]

Do you know how to this if you want to include several invoice numbers for the same customer?

[@techshoyeb6388]

Thanks for sharing this information with us.

[@excelisfun]

You bet!

[@donnakirkwood4472]

Totally Awesome Video!! Thank you so very much for sharing.

[@levyacosta5804]

I am having difficulty downloading the file. Can you help?

[@rajkiran557]

This is awesome, I have a question, this email will go to an individual email address, how can I send this along with a cc? In a different situation is that possible?

[@excelisfun]

Raj kiran , I do not know how to do it with cc. Maybe VBA code, but I am not sure how to do that.

[@armandobarajas6539]

well, thanks for sharing your knowledge. God bless you. Regards.

[@excelisfun]

armando barajas You are welcome!

[@sanjayagarwal7243]

Dear sir i have embedded a pdf file in excel cell and I want to mail merge. Please help.

[@86csumpi]

OMG! I love this presentation!!! You are so great!! Subscribed!

[@MrSarky1992]

Mike, serious question: do you think it's possible to pick up girls with excel? For example I recently made a workbook, where no matter what they write in, they get a

[@nrbrtmuller]

Can I somehow do this for a single customer instead of all of them?

[@felicec.4854]

I need to review that 'what if empty' filed. How to go about this?

[@pponcho8245]

What if you want to itemize the amount due?

[@rv7779]

Well done...great video

[@huupquang]

Great video, thanks for sharing. But do you know how to add in cc and bcc

[@adel7234]

is it possible to send an email directly from Excel ??

[@tonutammiste]

Just brilliant!

[@excelisfun]

Tõnu Tammiste Glad you like it!

[@skriya7]

Hi mike, I want to learn Excel as like you, give me some tips...

[@kmzi101]

Iti is good to know you wish to have excel command , you need practice and work hard

[@bunmeng007]

This is very useful

[@excelisfun]

Bun Meng Leng Glad the video is helpful!

[@ankurshukla2516]

Oh Thanks Awesome Mr.Mike ...... :)

[@excelisfun]

Ankur shukla You are welcome!