How to Mail Merge in Word, Excel & Outlook

Learn how to Mail Merge with Microsoft 365, Office 2021, Office 2019, Office 2016, Office 2013, or Office 2010. Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft Word, Excel, and Outlook.

📚 RESOURCES

📺 RELATED VIDEOS

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert

[beamurray]

I've watched several videos on how to do this and this is the first one that actually made sense and that I've been able to reference back to. Thank you so much!

[TengBermudez]

My boss asked me if I was familiar with mail merging, and thanks to watching your Excel tutorial video, my colleagues now have a newfound respect for me. They are impressed by my knowledge and think I possess various skills. About 30 minutes ago, my boss inquired if I could handle mail merging, and confidently, I responded affirmatively. I promptly referred back to your tutorials, where I learned how to perform the task. As a result, my colleagues have even more confidence in my abilities and regard me as someone knowledgeable.

Thank you very much Mr. Kevin

[jorgeoteo]

Just sent an invitation for a webinar for 100 clients; the time invested looking at this video is well worth it-- it defintely beats copying-and-pasting X 100!

[theresevanwyk]

Thanks a million Kevin! I was DREADING having to figure this out, and you made this so easy and OK! Goodness, I'm so grateful I didn't have to sit here for two days faffing around to make it work without a video tutorial! It means spending more effort on reaching my targets at work and less on figuring out my toolbox...

[andrichvitug]

This is great! Just the type of tutorial I need. Straight forward and easy to follow. Keep it up, Kevin!

[EuropeanWorldTraveler]

I discovered your channel a few weeks ago. You have taught me so much, and I've learned shortcuts and other interesting features I didn't know about before. Your teaching manner is easy to understand and follow, precise and informative. Keep up your good work.

[pmamsc]

Like most, I have watched hundreds of these type vids and without a doubt, this was the best!
Step by step without skipping any steps and without adding unnecessary comments.

[peggymunoz]

You did a great job but I think this should be added to the lesson. I found this in the comments below. "Heads up folks, if you’re doing emails, Outlook may send them automatically instead of leaving them sitting in your outbox. If you prefer to double-check your emails before sending, you need to turn off Automatic Send/Receive. To do this, go to File --> Options --> Advanced, and then scroll down to “Send and Receive”. Uncheck the box there, and also open the settings (by clicking the Send/Receive… button) to make sure there are no other settings that might make your messages send automatically. Don’t forget to turn it back on when you’re done with your mail merge!"

[josephwilk]

I am a public school teacher who is attempting to send critical information so that my families can have access to personalized materials during the COVID-19 shutdown. This tutorial was so helpful in allowing me to automate this process so that I can efficiently serve my families. Thank you so much for such a clear and direct tutorial!

[mackygreen]

*_OMG, Kevin! You're a lifesaver. I felt like a god when I was able to execute this successfully. As a Clerk (in a hospital laboratory) having many staff/colleagues to keep track of, this is the perfect way to get things done. Thank you so much._*

[suefranklin]

This was a really helpful tutorial, very clear and easy to follow. Going to attempt my first ever mail merge today and i think you have saved me hours of work. Thanks Kevin.

[donincognito]

Dude you are my hero! A Google search was useless, your guide actually worked. I had to email 119 people without anyone else email showing up on the receiving end. This saved so much time!

[variesxify]

Thanks, Kevin! You just made it so easy to know, understand and do. I watched the video at 1.5x for want of time thinking that I might have to watch more than one of them and it still made such perfect sense that I had to look no further. I could use the spare time to leave this note instead.

[jofwgic]

Hi Kevin,
I am an IT professional, but don't do a lot of mail merge tasks, I did a quick search. I found your video by far the easiest to follow and get straight away. You have a good pedagogic stile. concise and clear.

Thank you.

[channahbridgemantorres]

Thank you Kevin. You are an excellent trainer! Very professional, engaging tone, concise, clear instructions and examples.

[wongelinor]

Great thanks Kevin! I need this for an office task and your explanation is clean and clear. If larger fonts have been used on the WORD and EXCEL documents, that would even be better. But it's already gorgeous now. Thanks again.

[estelabalderas]

I did it! Though you may want to warn folks that once you click send email, it's actually sent and not put in a draft folder so you have to be sure about the email before the final click.

[suzycanton]

We just started using MS 365 this week and your video has been a lifesaver for this ancient worker. Thank you for creating these helpful content Kevin!

[maryvescio]

I never leave comments on videos, but your tutorial was so easy and without all the unnecessary bs that most tutorials do with the subsribe sell etc. I felt like such an expert after watching it. Thanks so much.

[leadscapeadvisors]

Excellent. So clearly explained. After grappling with this problem for so many days, I could do this in minutes. Thank you!