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