What Mail Merge in Outlook Actually Does

Mail merge in Outlook takes a list of names, email addresses, and other details from a spreadsheet or database, then automatically fills those details into an email template you write once. Instead of typing the same message fifty times with different names, you write it once with placeholders — like "Hello [FirstName]" — and Outlook sends a customized version to each person on your list.

The process has three parts: a template email you compose in Outlook, a data source (usually an Excel spreadsheet) containing the names and addresses, and the merge itself, which pairs them together and sends. Outlook does not have a built-in mail merge button the way Word does. Instead, you use Word as the middle step — Word handles the merge, and Outlook sends the result.

This matters because many people open Outlook expecting to find a merge feature and do not find one. The feature exists, but it lives in Word, and you have to start there.

Key Takeaways

  • Mail merge in Outlook requires Word as the merge engine — you create the template in Word, not Outlook, then send through Outlook.
  • Your data source must be a spreadsheet with column headers in the first row (names like "FirstName", "Email", "Company") and one person per row below.
  • You insert merge fields into your Word template using the Mailings tab, which tells Word where to pull each person's details from the spreadsheet.
  • After the merge completes in Word, the emails appear in your Outlook outbox ready to send, not sent automatically.

Prepare Your Spreadsheet Before You Start

Open Excel and create a new spreadsheet. The first row must contain headers — the names of the columns you will merge. Common headers are FirstName, LastName, Email, Company, City. Type each header in its own cell across the top row. Do not leave blank columns or use spaces in header names (use FirstName, not "First Name").

Below the headers, enter one person per row. Put their first name in the FirstName column, their email address in the Email column, and so on. Check that every row has an email address in the Email column — Outlook needs this to know where to send each message. Save the file as an Excel spreadsheet (.xlsx) in a location you will remember, like your Documents folder.

Before you move to Word, open the file again and verify the data. Look for typos in email addresses, missing entries, and duplicate rows. Mail merge will process exactly what you give it, so a mistake in the spreadsheet becomes a mistake in fifty emails.

Create Your Email Template in Word

Open Microsoft Word and create a new blank document. Write the body of the email you want to send. This is the message that will go to everyone, with placeholders where personal details should appear. For example: "Hello [FirstName], thank you for your interest in our program. We will contact you at [Email] within two business days."

Do not worry about the subject line yet — you will add that after you insert the merge fields. Just focus on the body text. Write naturally, as if you are writing to one person, but use square brackets around the field names where you want details to appear: [FirstName], [LastName], [Email], [Company], or whatever headers you created in your spreadsheet.

Save this document with a clear name like "MergeTemplate" in the same folder as your spreadsheet. You will return to this file to insert the actual merge fields.

Insert Merge Fields and Connect to Your Data

With your template document open in Word, click the Mailings tab at the top of the ribbon. On the left side, click Start Mail Merge, then select Email Messages from the dropdown. This tells Word you are preparing an email merge, not a letter or label merge.

Next, click Select Recipients and choose Use an Existing List. Browse to your Excel spreadsheet and open it. Word will ask which sheet contains your data — if you only have one sheet, it will select it automatically. Click OK. Word now knows where your names and addresses are.

Now replace the square brackets in your template with actual merge fields. Highlight the text [FirstName] in your document, then click Insert Merge Field on the Mailings tab. A dropdown list appears showing all your column headers from the spreadsheet. Click FirstName. Word replaces [FirstName] with a gray box labeled «FirstName» — this is the merge field. Repeat this for every placeholder in your template: [Email] becomes the Email merge field, [Company] becomes the Company merge field, and so on.

Add a Subject Line and Preview the Merge

Click at the very top of your document, above the body text, and type your subject line. You can include merge fields here too — for example, "Hello [FirstName], here is your custom report" works as a subject line. If you want the same subject for everyone, just type it without merge fields.

Before you merge, preview what the emails will look like. Click Preview Results on the Mailings tab. Word shows you the first person's version of the email with all merge fields filled in with real data from your spreadsheet. Use the arrow buttons to scroll through a few examples and check that names, emails, and other details appear correctly. If something looks wrong, click Preview Results again to turn off the preview, fix the template, and try again.

Complete the Merge and Send Through Outlook

Once the preview looks correct, click Finish & Merge on the Mailings tab, then select Send Email Messages. A dialog box appears asking which field contains the email addresses. Select Email (or whatever you named that column in your spreadsheet). Word creates one email for each row in your spreadsheet and places them all in your Outlook outbox.

Switch to Outlook. You will see all the merged emails in your Drafts folder or outbox, each addressed to a different person with their customized message. Open a few to verify they look correct. If they do, select all of them and click Send. If something is wrong, delete them without sending, go back to Word, fix the template, and run the merge again.

Do not panic if the emails sit in your outbox for a moment — Outlook may take a few seconds to process a large batch. If they do not send after a few minutes, check your internet connection and try again.

Troubleshooting Common Problems

If merge fields appear as «FirstName» instead of actual names, you did not complete the merge. Go back to Word, make sure you clicked Finish & Merge and selected Send Email Messages. If the emails landed in Drafts instead of sending, they are waiting for you to click Send — this is normal and gives you a chance to review them first.

If email addresses are missing or incorrect in the merged emails, the problem is in your Excel spreadsheet. Check that the Email column header is spelled exactly as you typed it in Word (Email, not email or EMAIL). Go back to your spreadsheet, fix any typos, save it, and run the merge again in Word.

If Word cannot find your spreadsheet when you click Select Recipients, make sure the file is saved as an Excel file (.xlsx), not as a CSV or text file. Also check that the spreadsheet is not open in another program — close it completely, then try the merge again.

Frequently Asked Questions

Can I use mail merge to send emails with attachments?

Word's mail merge does not attach files automatically. You can mention in the email body that an attachment is coming, but you will need to add attachments manually after the merge completes. Open each email in Outlook, click Attach, and add the file. For large batches, this is tedious — consider whether a different approach, like a shared link in the email body, might work better.

What if I only want to send to some people on my list, not everyone?

Before you merge, go back to your Excel spreadsheet and delete the rows for people you do not want to email. Save the file. Then run the merge again — Word will only create emails for the rows that remain. Alternatively, you can delete unwanted emails from your Outlook outbox after the merge completes, before you send.

Can I use mail merge with Gmail or another email service?

Word's mail merge is designed for Outlook. If you use Gmail or another service, you can still create the template and merge in Word, but you will need to copy the merged emails into your email service manually, or use a third-party tool designed for that service. Check whether your email provider has its own mail merge feature — many do.

Do I have to use Excel, or can I use a different spreadsheet program?

Word works best with Excel files (.xlsx). If you use Google Sheets or another program, save or export your data as an Excel file before you start the merge. Open the Excel file in Word's Select Recipients dialog, not the original file in its native program.

What happens if I accidentally close Word before I finish the merge?

Your template is saved, so you can open it again and start over. The merge does not happen until you click Finish & Merge, so closing Word early just means you have to redo the preview and merge steps. Your original spreadsheet is not affected.