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

About this video

Kevin walks through mail merge in Microsoft 365 to send hundreds of personalized emails, using Excel as the data source, Word to compose, and classic desktop Outlook to send. He stresses it requires classic Outlook and will not work with new Outlook or web apps. In Excel, he advises a single header row with no blanks above it, clear column names including an email address column, no blank rows in the middle, no merged cells or multiple tables, and correct formatting in Excel first — dates via Format Cells, ZIP codes or IDs starting with zero formatted as text, and currency formatted properly — because Word pulls values directly. In Word, under Mailings he selects Start Mail Merge > Email Messages, Select Recipients > Use an Existing List, picks the spreadsheet and table, and confirms the first row contains headers. He replaces placeholders in his message with Insert Merge Field fields for first name, company, webinar date, and amount due, formats them if needed, and uses Preview Results with navigation arrows to check each record. He notes adding a missing dollar sign in Word and fixing other issues in Excel. Via Edit Recipient List he can sort/filter or send a test to one record. Finish & Merge > Send Email Messages lets him choose the email column, enter a subject line (which cannot be personalized per recipient), choose HTML format, and send to all, current, or a range. Pro tips: mail merge sends from the primary Outlook profile account, Offline Mode in Send/Receive allows reviewing messages before sending, and traditional mail merge does not support personalized attachments.

Key takeaways

• Mail merge requires classic desktop Outlook; new Outlook and web apps will not work for sending
• Prepare Excel with one header row, no blank rows, no merged cells, and fix date, ZIP code (as text), and currency formatting in Excel before merging
• In Word use Mailings > Email Messages, connect the Excel list, and insert Merge Fields for personalized values like name, company, and amount due
• Always use Preview Results to check records, use Edit Recipient List to filter or test with one record, then Finish & Merge > Send Email Messages with HTML format
• Limitations: subject line is the same for everyone, sends come from the primary Outlook profile account, and personalized attachments are not supported

Episode details: published March 5, 2026 · 6:55 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: Meetings in Microsoft Teams: 20 Tips and Tricks · Next: Genspark AI Tutorial (Full Guide for Beginners) →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube