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

Mail merge is one of those features that sounds more complicated than it is. At its core, it lets you send a personalized email to dozens — or hundreds — of people without typing each message individually. If you've ever received an email that addressed you by name but was clearly sent to a large list, there's a good chance mail merge was behind it.

Here's how it actually works with Outlook, and what to know before you start.

What Is Mail Merge and Why Use It?

Mail merge combines a message template with a data source — usually a spreadsheet or contact list — to automatically insert personalized details into each outgoing email. That might mean first names, company names, order numbers, or any other field you define.

Common use cases include:

• Sending event invitations to a large contact list
• Distributing invoices or account updates
• Internal announcements where names and departments vary
• Outreach campaigns where personalization improves response rates

The key benefit is efficiency with consistency. Every recipient gets a message that feels tailored, but you only write it once.

What You Need Before You Start

Outlook doesn't run mail merge entirely on its own. The standard approach uses Microsoft Word as the template editor, Excel (or another data source) for the recipient list, and Outlook as the sending engine.

You'll need:

• Microsoft Word (the same Microsoft 365 account is simplest)
• Outlook configured as your default email client
• A data source — typically an Excel spreadsheet with columns for each personalized field (First Name, Email Address, Company, etc.)
• The email composed and ready in Word

If you're using a Microsoft 365 subscription, all three apps are already connected. Standalone or older Office versions follow the same process but may look slightly different.

How the Mail Merge Process Works 📧

Step 1: Prepare Your Data Source

Open Excel and structure your contact list as a table. The first row should be column headers — these become the merge fields you'll insert into your message. At minimum you need an Email Address column. Additional columns like First Name or Order Number let you personalize further.

Save the file and close it before opening Word.

Step 2: Set Up the Mail Merge in Word

Open a new document in Word and go to Mailings → Start Mail Merge → E-mail Messages. This switches Word into mail merge mode.

Next, click Select Recipients → Use an Existing List, then browse to your Excel file. If your spreadsheet has multiple sheets, Word will ask you to select the correct one.

Step 3: Write Your Email and Insert Merge Fields

Type your message as you normally would. Where you want personalized data to appear, click Insert Merge Field and choose the relevant column from your spreadsheet — for example, «First_Name» at the start of a greeting.

Your draft will look something like:

Dear «First_Name», Your order «Order_Number» has been confirmed…

Word displays the field placeholders in double angle brackets. These get replaced with real data during sending.

Step 4: Preview and Filter

Click Preview Results to cycle through how each recipient's message will look. This catches formatting issues or missing data before anything is sent.

Use Edit Recipient List to filter out duplicates, exclude certain rows, or sort your list.

Step 5: Send Through Outlook

When you're satisfied, click Finish & Merge → Send E-mail Messages. A dialog box appears where you:

• Select the column that contains email addresses (usually "Email Address")
• Write the subject line
• Choose the mail format: HTML, Plain Text, or Attachment

Click OK and Word hands off the individual emails to Outlook's outbox. Outlook processes and sends each one as a separate message — recipients don't see each other's addresses.

Mail Format: HTML vs. Plain Text vs. Attachment

HTML is the most commonly used option for standard email communication. Plain text often performs better for deliverability in certain environments, particularly in corporate or filtered inboxes.

Variables That Affect How This Goes in Practice 🔍

The steps above describe the standard process, but several factors shape how smoothly it runs for any given user:

Outlook account type — Microsoft 365 accounts, Exchange, and IMAP/POP setups all work, but behavior around send limits and outbox queuing can vary.

Send limits — Microsoft 365 and most email providers cap how many emails you can send per day or per hour. Large lists may trigger throttling or temporary blocks.

Data quality — Blank cells in your spreadsheet, inconsistent formatting, or missing email addresses produce errors or skipped rows during merge.

Office version — The Mailings ribbon is consistent across recent versions of Word, but exact menu labels or available options differ slightly between Office 2016, 2019, and Microsoft 365.

HTML rendering — Emails composed in Word and sent as HTML don't always render identically across email clients. Complex formatting, custom fonts, or heavy styling can break in some inboxes.

Default email client setting — If Outlook isn't set as your default mail client in Windows settings, Word may fail silently or throw an error at the final step.

Alternatives and Variations Worth Knowing

Word and Outlook remain the most accessible option for users already in the Microsoft ecosystem, but they aren't the only path. Some users work directly from Outlook's contact groups, while others use third-party mail merge add-ins that operate inside Gmail or Outlook without needing Word at all.

For very large lists, dedicated email marketing platforms handle sending infrastructure, tracking, and compliance — features the Word/Outlook approach doesn't include.

Whether the built-in method or a third-party tool makes more sense depends on your list size, how often you run merges, what kind of tracking you need, and how your organization's email environment is configured.