How to Do a Mail Merge in Outlook (Step-by-Step Guide)

Mail merge in Outlook lets you send personalized emails to dozens — or thousands — of recipients without writing each one individually. Every message looks like it was written just for that person, with their name, company, or any other custom detail dropped in automatically. Here's how it works, what you need, and where your own setup starts to matter.

What Is a Mail Merge in Outlook?

A mail merge combines a template message with a data source — typically a spreadsheet or contact list — to generate individualized emails at scale. Instead of sending one identical message to everyone, each recipient gets a version with their specific information filled in.

In the Microsoft ecosystem, Outlook doesn't run the mail merge on its own. It works as the sending engine, while Microsoft Word handles the template and Excel (or Outlook's contact list) supplies the data. The three tools work together, and understanding that relationship is key before you start.

What You Need Before You Start

• Microsoft Word (same Microsoft 365 or Office installation as Outlook)
• A data source — an Excel spreadsheet with columns like First Name, Last Name, Email Address, or any personalized field you want to insert
• Outlook set as your default email client
• A working outgoing mail profile configured in Outlook

If any of these pieces are missing or misconfigured, the merge won't send correctly. This is one of the most common points where users hit unexpected errors.

Step-by-Step: Running a Mail Merge Through Word and Outlook

Step 1 — Prepare Your Data Source

Open Excel and structure your data with column headers in the first row. Each column becomes a merge field you can insert into your message. Common columns include:

• FirstName
• LastName
• EmailAddress
• Company
• Any custom field relevant to your message

Save the file and close it before connecting it to Word.

Step 2 — Set Up Your Email Template in Word

1. Open a new document in Microsoft Word
2. Go to the Mailings tab in the ribbon
3. Click Start Mail Merge → select E-mail Messages
4. Click Select Recipients → Use an Existing List
5. Browse to and select your Excel file
6. Choose the correct worksheet if prompted

Your document is now linked to your data source.

Step 3 — Write Your Message and Insert Merge Fields

Write your email body as normal. Where you want personalized content to appear, use the Insert Merge Field button (also in the Mailings tab) to drop in fields from your spreadsheet.

Example:

Dear «FirstName», thank you for your interest in «Company»...

Each «FieldName» placeholder will be replaced with real data when the merge runs.

Step 4 — Preview and Check

Click Preview Results in the Mailings tab to cycle through how each email will look for individual recipients. Check that:

• Fields are pulling correctly
• Spacing around merge fields looks natural (a common formatting issue)
• No fields show as blank or mismatched

Step 5 — Finish and Send

1. Click Finish & Merge in the Mailings ribbon
2. Select Send E-mail Messages
3. In the dialog box:
   • To: select your EmailAddress column
   • Subject line: type your email subject
   • Mail format: choose HTML, Plain Text, or Attachment
4. Click OK

Word passes each personalized message to Outlook's outbox, and Outlook sends them using your configured mail account. 📧

Mail Format: HTML vs. Plain Text

HTML is the most commonly used format for mail merges because it preserves visual formatting. However, some email servers or security filters treat HTML bulk mail differently — worth knowing if deliverability matters to your use case.

Variables That Affect How This Works for You

Mail merge sounds straightforward, but several factors shape the experience significantly:

Microsoft 365 vs. older Office versions — The Mailings tab and workflow described above apply to current versions of Word. Older Office versions (2016, 2019) work similarly but may have minor UI differences.

Exchange vs. personal email accounts — If Outlook is connected to a corporate Exchange or Microsoft 365 account, IT policies may throttle outgoing email volume or flag bulk sends. Personal accounts (Outlook.com, Gmail via IMAP) have their own sending limits.

Sending limits — Outlook and mail servers impose limits on how many emails can be sent per hour or per day. Sending 500 emails in one mail merge on a personal account can trigger spam filters or temporary blocks. 🚫

Outlook as default client — If Outlook isn't set as the default email application in Windows settings, Word won't be able to hand off messages correctly.

Mac users — Mail merge via Word's Mailings tab behaves differently on macOS, with some features unavailable or requiring a different workflow entirely.

What the Built-In Tool Doesn't Do

The native Word/Outlook mail merge has real limitations:

• No open or click tracking
• No scheduling or send-time optimization
• No unsubscribe management
• Limited error reporting if individual sends fail
• No built-in handling of bounced addresses

For one-off internal communications or small batches, these gaps rarely matter. For ongoing campaigns, regular customer outreach, or larger lists, they start to define whether the built-in tool is actually fit for the job.

Whether the native mail merge workflow suits your situation depends on the scale of what you're sending, how your Outlook account is configured, what level of formatting and tracking you need, and whether you're working in a managed corporate environment or on a personal machine. The mechanics above are consistent — but how they perform in practice shifts considerably depending on those specifics.