How to Mail Merge in Word, Excel & Outlook (Full Guide) @KevinStratvert
How to Mail Merge in Word, Excel & Outlook (Full Guide)  @KevinStratvert
Uploaded March 2026 | Updated November 2026, 5 days ago
Need to send hundreds of personalized emails in just a few minutes? In this step-by-step tutorial, I’ll show you exactly how to use Mail Merge in Microsoft 365 by connecting Excel to Word and sending emails through Classic Outlook.

You’ll learn how to:
- Set up your Excel spreadsheet correctly
- Fix common formatting issues (dates, currency, ZIP codes)
- Insert merge fields in Word
- Preview your results before sending
- Send personalized emails through Outlook
- Avoid common mail merge mistakes

Important: Mail Merge requires the classic desktop version of Outlook. It does NOT work with the new Outlook or web apps.

By the end of this video, you’ll be able to send professional, personalized bulk emails quickly and confidently.

Host: Kevin Stratvert

⌚ TIMESTAMPS
0:00 - Explain what Mail Merge does
0:22 - Set up Excel spreadsheet correctly
0:58 - Fix date, ZIP code & currency formatting
1:45 - Start Mail Merge in Word
2:33 - Insert merge fields
3:58 - Preview personalized results
4:38 - Filter or edit recipient list
5:01 - Send emails through Outlook
6:02 - Pro tips
6:43 - Wrap up

πŸ“Ί RELATED VIDEOS
- Playlist with all my videos on Microsoft 365: youtube.com/playlist?list=PLlKpQrBME6xJhiS5DCtmUeuathMcy9Tu0

πŸ“© NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: newsletter.kevinstratvert.com

πŸ”½ CONNECT WITH ME
- Official website: kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert

🎁 PARTNERS & DISCOUNTED OFFERS
πŸ’» Hostinger | hostinger.kevinstratvert.com
πŸ“‹ Notion | notion.kevinstratvert.com
πŸ’΅ Quickbooks Online | qbo.kevinstratvert.com
πŸŽ™οΈ Voicemod AI Voice Changer | voicemod.kevinstratvert.com
πŸ•΅οΈ VidIQ | vidiq.kevinstratvert.com

πŸŽ’ MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com

πŸ™ REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

πŸ”” SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1

πŸ™Œ SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz

βš– 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 #mailmerge
How to Mail Merge in Word, Excel & Outlook (Full Guide)QuickBooks Payroll for Construction: Job Costing and ProjectsI gave my messy desktop to AI… and this happened. 😳Change your Gmail AddressSuperhuman Go Tutorial: The Ultimate All-in-One AI WorkflowGoogle AI Studio Voice Generator – Text to Speech TutorialFree AI Voice Generator on Your PC (Clone Any Voice)How to Use Confluence (Beginner Tutorial)How to Merge Cells in Excel (Without Losing Data)How to Use Microsoft Copilot CoworkStripe Tutorial for Beginners | Accept Payments Online14 - Assembling The Whole Video
Kevin Stratvert |

How to Mail Merge in Word, Excel & Outlook (Full Guide)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER