Mail Merge in Outlook: Step-by-Step Guide for Personalized Email Campaigns

Mail merge in Outlook lets you send personalized emails to a list of recipients — each one addressed individually, with their own name, company, or any other custom detail — all without typing each email by hand. It is one of the most useful features in the Microsoft Office suite, but the setup process trips up many people.

This guide walks you through exactly how to do mail merge in Outlook, covers the differences in Outlook 365 and Outlook Web App, explains how to add attachments, and then compares the native Outlook approach with the simpler Gmail alternative. Whether you are a first-timer or just need a refresher, you will be sending personalized emails in minutes.

What Is Mail Merge in Outlook?

Mail merge in Outlook works as part of a three-app workflow: Microsoft Word creates the email template, Excel (or another data source) stores your contact list, and Outlook delivers the finished emails. Word does the heavy lifting of merging the data with your template; Outlook is simply the sending engine.

This is different from Gmail-based mail merge tools, which typically handle everything in one place. With Outlook, you always need Word open alongside it — which is both the strength and the limitation of the approach.

How to Do Mail Merge in Outlook Step by Step

Here is the complete process to set up and run a mail merge in Outlook. You will need Microsoft Word, Excel, and Outlook installed on the same machine.

Step 1: Prepare Your Excel Contact List

Before you open Word, build your data source in Excel. Each column represents a field you can personalize, and each row represents one recipient.

A few things to get right from the start:

• Put column headers in Row 1. Word uses these headers as field names (e.g., «First Name»).
• Use a dedicated Email Address column with the exact email for each recipient.
• Remove blank rows — they can cause Word to create blank emails.
• Save as .xlsx before starting. Word does not work well with unsaved Excel files.

Step 2: Open Word and Start the Mail Merge

1. Open Microsoft Word and create a new blank document.
2. Go to the Mailings tab in the ribbon.
3. Click Start Mail Merge → E-mail Messages.

Word is now in mail merge mode. The document will become your email body.

Step 3: Connect Your Excel File as the Data Source

1. In the Mailings tab, click Select Recipients → Use an Existing List.
2. Browse to your Excel file and click Open.
3. If Excel asks which sheet to use, select the sheet containing your contacts.

Word is now linked to your spreadsheet. You will see the recipient controls activate in the Mailings ribbon.

Step 4: Write Your Email Template

Write your email body in the Word document. To insert a personalized field:

1. Place your cursor where the field should appear (e.g., after “Hi”).
2. Click Insert Merge Field in the Mailings ribbon.
3. Select the column name from your Excel file (e.g., First Name).

The result looks like this: Hi «First Name», thank you for your interest in...

Tips for a good template:

• Keep the subject line clear — you will set it in the next step.
• Avoid over-personalizing. Using the first name once or twice is enough.
• Test with a small batch before sending to your full list.

Step 5: Preview Your Merged Emails

Click Preview Results in the Mailings tab to see how the first merged email looks. Use the arrow buttons to scroll through recipients and check that the fields populated correctly.

If something looks wrong — a blank field, a name appearing in the wrong place — go back to your Excel file and fix the data, then reload the source in Word.

Step 6: Complete the Merge and Send via Outlook

When you are satisfied with the preview:

1. Click Finish & Merge → Send E-mail Messages.
2. In the dialog that appears:
   • To: Select the column containing email addresses (e.g., Email Address).
   • Subject line: Type the subject for all emails.
   • Mail format: Choose HTML for formatted emails, or Plain Text for simple ones.
3. Click OK.

Outlook will open in the background and queue all the emails. Depending on the size of your list, this may take a few minutes. Sent emails will appear in your Sent Items folder in Outlook.

Mail Merge in Outlook 365: What’s Different?

If you are using Microsoft 365 (formerly Office 365), the mail merge process is identical to the steps above — the same Word → Excel → Outlook workflow applies. The ribbon interface may look slightly different depending on your version, but all the relevant options are in the Mailings tab.

One important note: Microsoft 365 accounts managed by an organization may have sending limits enforced by the IT department or Exchange Online policies. If you plan to send to hundreds of recipients, check with your admin first or test with a small batch.

For Microsoft 365 subscribers, the column header “Email Address” must match exactly what you put in the To field of the Send E-mail Messages dialog. Mismatches cause the merge to fail silently.

Can You Do Mail Merge in Outlook Web App?

This is one of the most common questions about Outlook mail merge: Outlook Web App (OWA) does not support mail merge. The mail merge feature requires the desktop version of Word and Outlook running on the same Windows or Mac machine.

If you are working entirely in a browser — through outlook.com or your organization’s web portal — you cannot run a native Outlook mail merge. You would need to:

1. Use the desktop apps (download and install Microsoft Office).
2. Use a third-party tool that works directly in the browser, such as a Gmail-based mail merge extension.

Many users who discover this limitation switch to Gmail-based tools that work fully in the browser without needing any desktop software.

How to Add Attachments to Mail Merge in Outlook

The native Outlook mail merge workflow does not support attachments per recipient. You can only attach the same file to every email in the merge — and even this is not straightforward.

Workaround for a single attachment to all recipients:

After you run the merge (Finish & Merge → Send E-mail Messages), Outlook sends the emails immediately. There is no built-in way to add an attachment through the Word dialog before sending.

The common workaround:

1. Instead of sending immediately, choose Finish & Merge → Edit Individual Documents first.
2. This creates a new Word document with one section per recipient.
3. You can then manually add attachments — but this defeats the purpose of automation for large lists.

For personalized attachments per recipient (e.g., a different PDF for each person), the native Outlook mail merge tool simply cannot do this. You need a dedicated tool.

Try Mail Merge for Gmail

Send personalized bulk emails directly from Gmail — with open tracking, scheduling, and per-recipient attachments. No Word or Excel required.

Get Started →

Limitations of Outlook Mail Merge (And Why Many Users Switch)

Outlook mail merge is functional but shows its age. Here are the most common limitations teams run into:

1. No open tracking. You cannot see whether recipients opened your email. For sales outreach or any situation where knowing who engaged matters, this is a significant gap. Compare this to email tracking tools for Gmail that show opens, clicks, and read time.

2. Requires three separate apps. Every mail merge needs Word, Excel, and Outlook running together on the same machine. If any one of them fails, the whole workflow breaks. There is no browser-based option.

3. No scheduling. You cannot schedule a mail merge to send at a specific time. It sends immediately when you click OK.

4. Limited personalization options. You can only personalize based on columns in your Excel file. Conditional content (“if Company = X, say Y”) requires complex Word field codes that are error-prone.

5. Microsoft 365 license required. You need a paid Microsoft 365 subscription for the desktop apps. The web versions do not support mail merge.

6. No analytics. After sending, you get no data on delivery rates, bounce rates, or engagement. Your emails go into a black hole.

7. Sending limits. Exchange Online and many ISPs throttle bulk sends. Microsoft 365 limits users to 10,000 recipients per day, but many organizational policies set this much lower.

A Simpler Alternative: Mail Merge Directly in Gmail

If your team already uses Google Workspace — or even just a personal Gmail account — there is a much simpler path. Mail Merge for Gmail handles the entire process inside Gmail, using Google Sheets as your data source instead of Excel.

Here is how the experience differs:

If you are already doing most of your work in a browser and your contacts are in Google Sheets, switching to a Gmail-based mail merge tool eliminates the Word/Outlook dependency entirely. You can also check our guide on how to do mail merge in Gmail for a step-by-step comparison.

For teams that send large volumes or need to track engagement, a dedicated tool also pairs well with email open tracking to know exactly when recipients read your message.

FAQ

Conclusion

Mail merge in Outlook gets the job done — especially if your team already lives in the Microsoft ecosystem and you need a no-cost-add-on solution for occasional personalized sends. The Word + Excel + Outlook workflow is well-documented and reliable for straightforward use cases.

But for teams that need open tracking, scheduling, per-recipient attachments, or a browser-based workflow, the native Outlook mail merge falls short. If that is your situation, Mail Merge for Gmail solves all of these limitations while keeping the same simple “contact list + template = personalized emails” concept that makes mail merge so useful in the first place.