How to Mail Merge from Excel to Word: Step-by-Step Guide (2026)

The classic mail merge workflow — Excel as the data source, Word as the template, Outlook as the delivery engine — has been a staple of Microsoft 365 since Office 2007. If you’re looking to send personalized emails at scale, this is probably the first method you’ll encounter.

This guide walks through the full process, flags the common failure points (including what breaks in New Outlook), and shows a faster alternative that skips Word altogether.

What you need

• Microsoft Excel (any recent version)
• Microsoft Word (any recent version)
• Classic Outlook set as your default email client on Windows

Step 1 — Create your Excel spreadsheet

Your spreadsheet is the data source. Each row becomes one email; each column becomes a merge field you can insert into the email template.

At minimum you need:

Column	Purpose
To	Recipient email address (required)
FirstName	Personalisation field (optional but recommended)
Any other column	Any data you want to appear in the email

Practical tips:

• No spaces in column names. FirstName works; First Name causes problems when inserting fields in Word.
• One email per row. If a recipient needs two emails, add two rows.
• Save as .xlsx (not .csv) for the cleanest connection with Word.

Example spreadsheet layout:

To	FirstName	Company	InvoiceNumber	Amount
[email protected]	Alice	Acme Corp	INV-001	$1,200
[email protected]	Bob	Widget Ltd	INV-002	$850

Step 2 — Open Word and select E-mail Messages

1. Open a new blank document in Word.
2. Go to the Mailings tab in the ribbon.
3. Click Start Mail Merge.
4. Select E-mail Messages from the dropdown.

The document is now in mail merge mode. It looks like a regular document, but Word is treating it as an email template.

Step 3 — Connect your Excel file

1. Click Select Recipients in the Mailings ribbon.
2. Choose Use an Existing List.
3. Navigate to your Excel file and open it.
4. A dialog will ask which sheet to use. Select the sheet containing your data and click OK.

Word is now connected to your spreadsheet. The Edit Recipient List option becomes available — you can use it to filter or sort recipients before sending.

Step 4 — Write your email body

Write the full email in the Word document. Use plain text and formatting just as you would in a normal Outlook email.

When you reach a point where you want to insert personalised data:

1. Place your cursor at that point.
2. Click Insert Merge Field in the ribbon.
3. Choose the column name from the dropdown (e.g. FirstName, Company).

Word inserts a field code like «FirstName». At send time this is replaced with the real value from your spreadsheet.

Example email opening:

Dear «FirstName»,

Please find your invoice «InvoiceNumber» for «Amount» attached.

Step 5 — Preview your merge

Click Preview Results in the Mailings tab. The field codes are replaced with real data from your spreadsheet.

• Use the arrow buttons to scroll through recipients and check each one.
• If a field shows blank or incorrect data, go back to your spreadsheet and fix it, then re-connect using Select Recipients again.
• Check for awkward formatting — extra spaces, odd capitalisation.

Step 6 — Send via Outlook

1. Click Finish & Merge in the ribbon.
2. Select Send Email Messages.
3. In the To field dropdown, choose the column containing email addresses (e.g. To).
4. Enter a Subject Line. Note: the subject line is the same for all recipients — you cannot insert merge fields here.
5. Leave the format set to HTML.
6. Click OK.

Word passes each individual email to Classic Outlook, which sends them from your mailbox.

Common problems

“Send Email Messages” is greyed out Classic Outlook is not the default email app. Change the default and try again.

Merge fields showing «» instead of data The column name in Excel doesn’t match the field name you inserted. Check for spaces, capitalisation differences, or leading/trailing whitespace in the column header.

Emails going to Outbox but not sending Outlook is in Offline Mode. Click the Send/Receive tab → Work Offline to toggle it off.

All recipients getting the same email without personalisation You likely inserted the field text manually (typing FirstName) instead of using Insert Merge Field. Delete the manual text and use the Insert Merge Field dropdown.

Limitations of this method

The Word–Excel–Outlook mail merge is free and built in, but it has real constraints:

• No individual attachments. Every recipient gets the same attachment (if any).
• No tracking. You can’t see who opened or clicked.
• No subject line personalisation. The subject is the same for all recipients.
• Broken in New Outlook. Microsoft has not added this feature to New Outlook.
• Slow for large lists. Word can struggle with lists over 500 rows.

The faster method: skip Word entirely

The SecureMailMerge add-in does the same job directly inside Outlook — no Word, no wizard, no risk of the “wrong default email client” problem.

1. Install SecureMailMerge from the Microsoft AppSource (free tier available).
2. Open a new email in Outlook. Click the Campaign Manager icon in the Apps menu.
3. Upload your spreadsheet (same Excel file you’d use for Word).
4. Write your email using the {{FirstName}} token syntax, with a dropdown picker to insert fields.
5. Send a test email to yourself, then click Start Sending Campaign.

Works in Classic Outlook, New Outlook, Outlook for Mac, and Outlook on the Web.

FAQ

Can I mail merge from Excel to Outlook without Word? Yes. The SecureMailMerge add-in connects directly to your Excel spreadsheet from inside Outlook and handles the entire merge without opening Word.

Can I personalise the subject line in a Word mail merge? No — the subject line in Word’s “Send Email Messages” dialog is static. To personalise subject lines, use the SecureMailMerge add-in, which supports merge tokens in both the subject and body.

Does mail merge from Excel to Word work on Mac? It works on Mac in a limited way — Word on Mac can perform the merge but sending via the Classic Outlook for Mac desktop app has historically been unreliable. The SecureMailMerge add-in is the recommended approach for Mac users.

How many rows can my Excel spreadsheet have? Word can struggle above 500–1,000 rows. For large lists, use the SecureMailMerge add-in or split into batches.

---

Related guides:

• Mail merge in Outlook — complete guide
• Mail merge in Word — full walkthrough
• Mail merge from Excel — spreadsheet setup tips
• How to do a mail merge — beginner overview