How to Mail Merge Letters - Office 365

Learn how to Mail Merge to create customized letters using Microsoft Word and Excel. Quickly take a spreadsheet with contacts and create bulk letters with ease. No need to paste individual names, addresses, and other information into a letter.

Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft Word and Excel.

As full disclosure, I work at Microsoft.

[mikekerr]

I remember having to type the individual letters to several people. This feature is great. Your tutorial was excellent, voice tone, display menu selections and instructions were the clearest of several videos that I found. I only do this once a year, just saw this and you made my life much easier. Thank you.

[veshexercise]

Thank you Kelvin for sharing your ideas with us, I have just made my first mail merge successfully, am so happy right now💕💕💕💕💕

[aimeeamos]

THANK YOU VERY MUCH KEVIN, THE training on mail Merge is wonderful. Thank you

[smashlee]

This was so helpful to me today! So easy to understand. Thank you!

[mmitchellhouston]

Thanks. I don't do this often, so a uick refresher course was VERY helpful.

[richardterrell]

Thank you Kevin, I expect to learn more watching your other videos, so I have subscribed

[sweetest_of_all_honeys]

Thank you so much. This was very helpful and straightforward.

[harmonybetancourt]

Thank you very much to this man, he made me understand mailmerge better than my school teacher does

[billrichmond]

thank you. This was really well explained!

[amyfitzgerald]

This was super helpful! I haven't done this in a year so it was a great refresher.

[charlestoneoyoo]

Lifesaver, up to the point. Thank you

[JocelynCleolette]

Thanks a lot for this helpful video! I have just done my letters 😊

[ITSKILLSACADEMY]

I like this guy intro, great tutorial

[Mandolin]

Great video well explained. How about a video on how to create a new mail merge template document -- preferable one with you company's letterhead to top?

[paromitaganguly]

Hi Kevin, your video tutorials are extremely helpful. Please post tutorial on Quick Parts & Building Blocks in MS Word. Thank you.

[dizzaflores]

Thank you, this video help me so much in my activity in Teaching and learning 2. We need to make a merge letter to the parents of the students in their progress in academics.

[kathalterado]

I like this tutorial, I really need this for our school activity. Thank you

[daquanwilliams]

Thank you a lot this really helped me out for my SBA👍

[JesseSabo]

It's like Madlibs of Christmas letters: Hello I hope you are about as we celebrate the season with Joy. *gasps of disbelief at your thoughtfulness

[charlotteengerer]

Hey Kevin, I've used a number of your videos to help me with challenges in Excel, and find them super helpful, and while I have used mail merge for many years, I have run into a challenge that I'm hoping you can help me with. I am working in MS 365 (recently converted), and attempting to distribute a document by mail merge to about 1, 000 employees; while the merge functions no problem, the mail step does not seem to work. It appears that my email account is set up in Word, but I cannot figure out why it's not working. Any chance you can assist me with this?