What Mail Merge Does and Why You'd Use It

Mail merge in Outlook lets you send the same email to many people with each one personalized — their name, company, or other details filled in automatically from a list you provide. Instead of typing "Dear John" fifty times, you write the message once with placeholders, and Outlook fills in each person's information as it sends.

The process works by connecting your email to a data source — usually an Excel spreadsheet or a Word document with a table. Outlook reads that list, creates a separate email for each row, and personalizes each one before sending. This saves time when you're reaching out to many contacts at once and want each message to feel individual rather than like a mass email.

Key Takeaways

  • Mail merge in Outlook requires a data source (usually an Excel file) with the names, email addresses, and other details you want to personalize.
  • You write one email template in Outlook, insert merge fields where personalized information should go, and Outlook generates individual emails from your data source.
  • The actual merge happens in Word, not Outlook — you start in Outlook but complete the process by opening your template in Word and running the merge there.
  • You can preview each merged email before sending to catch mistakes in your data or template.

Prepare Your Data Source Before You Start

Your data source needs to be organized in a specific way for Outlook to read it correctly. Open Excel and create a spreadsheet with column headers in the first row — these headers become your merge field names. Common headers are FirstName, LastName, Email, Company, or any other detail you want to personalize. Each row below the headers should contain one person's information, with their email address in its own column.

Save this file as an Excel workbook (.xlsx) in a location you'll remember — your Desktop or Documents folder works well. Do not leave blank rows in the middle of your data, and do not include extra formatting like bold text or colored cells. Outlook reads the raw data, not the formatting. Double-check that every email address is spelled correctly and that there are no extra spaces before or after names.

Write Your Email Template in Outlook

Open Outlook and start a new email. Write the subject line and the body of the message as you want it to appear. Wherever you need personalized information to appear — usually at the start of the greeting — leave a space or placeholder. For example, write "Dear [FirstName]," instead of "Dear John," or "Hello [FirstName] [LastName],". Do not send this email yet. Instead, save it as a draft or close it without sending.

The exact wording of your merge fields matters. If your Excel column is named "FirstName", your placeholder must be exactly "[FirstName]" with square brackets and matching capitalization. If you use "[firstname]" or "[first_name]" instead, Outlook will not recognize it and will leave the placeholder text in the final emails.

Open Your Template in Word and Insert Merge Fields

This is the step that confuses most people: you finish the mail merge in Word, not in Outlook. Open Microsoft Word and go to the Mailings tab at the top. Click "Start Mail Merge" and choose "Email Messages" from the dropdown. Then click "Select Recipients" and choose "Use an Existing List". Navigate to your Excel file and open it. Word will ask which sheet contains your data — select the correct one and click OK.

Now go back to your Outlook draft email, select all the text (Ctrl+A), and copy it. Return to Word and paste the email text into a blank document. Position your cursor where the first merge field should go — usually right after "Dear " in the greeting. Click the "Insert Merge Field" button in the Mailings tab and select the field name from the list (FirstName, LastName, Email, or whatever your columns are named). Word inserts the field as «FirstName» with angle brackets.

Continue inserting merge fields wherever personalized information should appear. If you want the email to say "Dear John Smith," insert «FirstName» then a space then «LastName». If you want "Dear John at Acme Corp," insert «FirstName» then " at " then «Company». Save this Word document — this is now your merge template.

Preview and Send Your Merged Emails

Before you send to everyone, preview what the merged emails will look like. In Word, click "Preview Results" in the Mailings tab. Use the arrow buttons to flip through a few examples and check that names, companies, and other details are filling in correctly. Look for common mistakes: missing spaces between fields, names that are spelled wrong in your Excel file, or email addresses with typos.

If you spot an error in the data, close the preview, go back to your Excel file, fix the mistake, save it, and then reopen your Word template. Word may ask if you want to update the data source — click Yes. If the error is in your template (like a missing space between fields), edit the template directly in Word and save it.

Once the preview looks correct, click "Finish & Merge" and choose "Send Email Messages". Word will ask which field contains the email addresses — select the column name (usually "Email") and click OK. Word then creates and sends one email for each row in your data source. The emails go out from your Outlook account, and you'll see them appear in your Sent folder as they're sent.

Troubleshooting Common Problems

If the merged emails contain the merge field text instead of actual names — like the email says "Dear «FirstName»" instead of "Dear John" — the field names in your Word template don't match your Excel column headers exactly. Check capitalization and spelling. Go back to your Excel file and confirm the exact spelling of each column header, then update your Word template to match.

If some emails don't send or you get an error message, check that every row in your Excel file has an email address in the Email column. Blank cells or invalid email addresses will cause that row to fail. Also confirm that your Outlook account has permission to send email — if you're on a corporate network, your IT department may have restrictions on bulk sending.

If the merge seems to send duplicate emails or skip some people, make sure there are no blank rows in your Excel data. Even one empty row in the middle will confuse Word. Delete any blank rows, save the file, and try the merge again.

Frequently Asked Questions

Can I use mail merge to send emails to people in my Outlook contacts instead of an Excel file?

Not directly from Outlook. You need to export your contacts to an Excel file first. In Outlook, go to File, then Open & Export, then Import/Export. Choose "Export to a file" and select "Comma Separated Values". Save the file, then use that file as your data source in Word. This gives you a chance to clean up the contact list and remove anyone you don't want to email.

What happens if I make a mistake after the emails have already been sent?

The emails are already in your recipients' inboxes and cannot be unsent. If the error is minor (like a typo in the body), you can send a follow-up email explaining the correction. If the error is serious, send a second email with the correct information and ask people to disregard the first one. Always preview several merged emails before clicking Send.

Can I personalize the subject line too, or just the body of the email?

Yes, you can personalize the subject line. In your Word template, click in the subject line field and insert merge fields the same way you do in the body. For example, "Special offer for [FirstName]" or "John, your account update". The subject line will be different for each recipient based on their data.

Is there a limit to how many emails I can send with mail merge?

Outlook has no hard limit, but sending hundreds of emails at once may trigger spam filters or rate limits on your email account. If you're sending to more than 500 people, consider splitting the list into smaller batches and running the merge multiple times. Also check with your IT department if you're on a corporate network — they may have policies about bulk email.

Can I schedule the merged emails to send later instead of right away?

Mail merge in Word sends emails immediately when you click Finish & Merge. Outlook does not have a built-in way to schedule merged emails for a later time. If you need to send them later, complete the merge, let the emails send, then manually reschedule them in your Sent folder — or run the merge at the time you want the emails to go out.