Mail merge in Outlook works through Word, not Outlook itself

Outlook does not have a built-in mail merge feature. Instead, you use Microsoft Word to create the merged emails and Outlook to send them. Word pulls names, addresses, or other details from a data source — usually an Excel spreadsheet or a contact list — and inserts them into a template email. Word then hands the finished messages to Outlook, which sends them one at a time to each recipient.

This two-step process means you need both Word and Outlook installed on your computer, and your data organized in a format Word can read. The most common setup is an Excel file with one column per field (Name, Email, Company, and so on) and one row per person.

Key Takeaways

  • Mail merge requires Word to create the template and Excel (or another data source) to hold the recipient list, then Outlook sends the finished messages.
  • Your data must be organized in columns and rows, with headers in the first row and one person per row below.
  • Word's mail merge wizard walks you through selecting your data source, inserting merge fields, and previewing results before Outlook sends anything.
  • Test the merge with one or two recipients first to catch errors in your template or data before sending to your full list.

Prepare your data in Excel before opening Word

Open Excel and create a spreadsheet with your recipient information. Put field names in the first row: Name, Email, Company, Title, or whatever fields you plan to use in your email. Put one person per row below that, with their information in the matching columns.

Save the file with a clear name — something like "Mail Merge Recipients" — in a location you will remember. Do not leave blank rows in the middle of your data, and do not put extra text or notes above the header row. Word's mail merge tool reads from the first row down, so any clutter will confuse it.

Check that all email addresses are spelled correctly and that names are spelled the way you want them to appear in the email. This is the time to fix those details, not after Word has already built the template.

Open Word and start the mail merge wizard

Open Microsoft Word and create a new blank document. Type the body of your email as you want it to appear, but leave blank spaces where you want names or other details to go. For example: "Hi [Name], thank you for your interest in [Company]."

Go to the Mailings tab at the top of the Word window. Click Start Mail Merge, then select Step-by-Step Mail Merge Wizard from the dropdown. A panel will open on the right side of your screen.

In the wizard panel, select E-mail messages as your document type. This tells Word that you are building emails, not letters or labels. Click Next: Starting document at the bottom of the panel.

Connect Word to your Excel file

The wizard will ask you to choose a starting document. Select Use the current document (the one you just typed), then click Next: Select recipients.

On the next screen, click Browse and navigate to your Excel file. Select it and click Open. Word will ask which sheet you want to use — if your data is on Sheet1 (the default), leave that selected. Click OK.

Word will show you a preview of the recipients it found. Check that all the names and email addresses are there and spelled correctly. If you see duplicates or people you do not want to include, you can uncheck their names in this list. Click Next: Write your message when you are ready.

Insert merge fields into your email template

Now you are back in your document. Place your cursor where you want the first piece of merged data to appear — for example, right after "Hi " at the start of your greeting. Click More items in the wizard panel on the right.

A dialog box will open showing all the field names from your Excel file (Name, Email, Company, and so on). Click the field you want to insert — for example, "Name" — and click Insert. Word will put a placeholder like <<Name>> into your document at that spot.

Repeat this for each field you want to include. If you want to insert the same field twice, you can do that. When you are done inserting all the fields, click Next: Preview your messages.

Preview the merged emails before sending

The wizard will show you what the first email will look like with real data filled in. Read it carefully. Check that the spacing looks right, that names are capitalized the way you want them, and that the message makes sense. Use the arrow buttons to flip through a few more examples.

If you spot a mistake in the template — a typo, wrong spacing, or a field in the wrong place — click Previous: Write your message to go back and fix it. If the mistake is in your Excel data (a misspelled name, wrong email address), close Word without saving, fix the Excel file, and start over.

When the preview looks correct, click Next: Complete the merge.

Send the merged emails through Outlook

On the final screen, you have two options: Print (which is for letters, not emails) and Electronic mail. Click Electronic mail.

A dialog box will open asking which field contains the email addresses. Select the field that holds your recipients' email addresses — usually labeled "Email" — and click OK. Word will ask you to name the subject line. Type the subject you want all the emails to have, then click OK.

Word will open Outlook and create one email for each person in your list, with all the merge fields filled in with their data. The emails will appear in Outlook's Drafts folder. You can review them, make changes if needed, and then send them all at once or one at a time.

Test with a small group first

Before you send to your full recipient list, send a test merge to yourself or a colleague. Go back to the mail merge wizard, uncheck everyone except one or two people, and run through the merge again. This catches errors in your template or data without sending mistakes to hundreds of people.

Common problems include merge fields that did not insert correctly, data that is formatted wrong (like a phone number showing as a number instead of text), or spacing issues where fields run into each other. Once you fix these in Word or Excel, you can run the full merge with confidence.

Frequently Asked Questions

Can I personalize the email body, not just the greeting?

Yes. You can insert merge fields anywhere in the email — in the subject line, the body, or the signature. For example, you could write "We noticed you work at <<Company>>" or "Your account number is <<AccountNumber>>". The merge field will be replaced with the actual data from your Excel file for each recipient.

What if my data is in a CSV file instead of Excel?

Word can read CSV files the same way it reads Excel files. When you click Browse in the mail merge wizard, change the file type filter to "All Files" or "Text Files" and select your CSV file. Word will open it and let you choose which sheet or section to use.

Can I send the emails immediately, or do they stay in Drafts?

The merged emails land in Outlook's Drafts folder. You can review them, make last-minute changes, and then send them all at once by selecting all the messages and clicking Send. This gives you a chance to catch any problems before anything goes out.

What happens if someone's name is missing from the Excel file?

If a row in Excel is missing data in a field, Word will leave that merge field blank in the email. For example, if someone has no Company listed, the sentence "You work at <<Company>>" will read "You work at ." Go back to Excel, fill in the missing data, and run the merge again.

Can I use Outlook contacts instead of an Excel file?

Yes. In the mail merge wizard, when you click Browse to select your data source, you can choose your Outlook contacts file instead of an Excel spreadsheet. Outlook will export your contacts in a format Word can read. This works best if your contacts are already organized with all the fields you need filled in.