Mail merge in Outlook requires Word, not Outlook alone

Outlook does not have a built-in mail merge feature. To send personalized emails to a list of people — with each person's name, company, or other details filled in automatically — you need to use Microsoft Word as the engine and Outlook as the delivery method. Word handles the merge logic, and Outlook sends the finished emails.

The process works like this: you create a template email in Word, connect it to a data source (usually an Excel spreadsheet or a contact list), and Word generates individual emails with personalized details. Outlook then sends them all at once. If you do not have Word installed, this workflow will not work; Google Gmail and some other email services have native mail merge tools, but Outlook itself does not.

Key Takeaways

  • Mail merge requires Word and Outlook together — Outlook alone cannot do it, and you must have both programs installed on your computer.
  • Your data source should be an Excel spreadsheet with column headers (Name, Email, Company) that match the fields you want to insert into your email.
  • You create the email template in Word, insert merge fields where personalized details should appear, and then execute the merge to generate individual emails.
  • Outlook sends the finished emails, but you can review and edit them before sending if you choose the "Edit individual emails" option during the merge.
  • The entire process takes 10 to 20 minutes once your data is organized, but setup mistakes — mismatched column names or missing email addresses — are the most common cause of failures.

Prepare your contact data in Excel first

Before you open Word, organize your recipient list in Excel. Create a new spreadsheet with column headers in the first row: Email, FirstName, LastName, Company, or whatever fields you plan to personalize. Each row below should contain one person's data, with their email address in the Email column. Save this file — you will point Word to it during the merge.

Check your data for common problems: blank cells in the Email column will cause those rows to fail, inconsistent spacing or extra characters in names can look wrong in the final email, and duplicate email addresses will send the same person multiple copies. Spend five minutes cleaning this up now rather than troubleshooting failed sends later. If your contacts are in Outlook already, you can export them to Excel by opening Contacts, selecting all, and using File > Export.

Create your email template in Word

Open a new blank document in Word. Write the email as you want it to appear, including the subject line at the top. Where you want personalized information to appear — such as "Dear John" or "Your company, Acme Corp" — type a placeholder that you will replace with a merge field.

For example, write "Dear [FirstName]," and "I wanted to reach out to [Company]." Do not send this document to anyone; it is only a template. Save it with a clear name like "Newsletter_Template" or "Sales_Outreach_Template" so you can find it again. You will convert these placeholders to actual merge fields in the next step.

Insert merge fields into your Word template

With your template open in Word, go to the Mailings tab at the top. Click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will read the column headers from your spreadsheet.

Now click where you want the first personalized field to appear — for example, after "Dear ". Go to Mailings > Insert Merge Field and select the column name that matches what you want there, such as FirstName. Word will insert a field code that looks like «FirstName». Repeat this for every place you want personalized information: «LastName», «Company», «Email», or any other column you created. When you are done, your template will show the merge field codes instead of the placeholder text you typed.

Preview the merge and choose how to send

Before you commit to sending, click Mailings > Preview Results to see what the emails will actually look like. Word will show you the first record with all merge fields filled in with real data from your Excel file. Use the arrow buttons to flip through a few examples and confirm that names, companies, and other details are correct and in the right places.

If something looks wrong — a field is blank, a name is misspelled, or a merge field did not insert correctly — go back and fix it. Return to your Excel file to correct data, or go back to your Word template to fix the field placement. Once you are satisfied, you are ready to send.

Execute the merge and send through Outlook

In Word, go to Mailings > Finish & Merge and choose Send Email Messages. A dialog box will appear asking which field contains the email addresses — select Email (or whatever you named that column). You can also choose whether to send all records or only a range, such as rows 1 through 10 if you want to test with a small batch first.

Word will create individual emails and hand them to Outlook to send. Depending on your Outlook settings and the number of emails, this may happen when ready or Outlook may ask you to confirm. The emails will appear in your Sent folder once they go out. If you want to review and edit each email before it sends — to catch any last-minute issues or personalize a message further — choose "Edit individual emails" instead of "Send Email Messages". Word will create a new document with all the merged emails listed, and you can edit each one before manually sending them through Outlook.

Troubleshoot common merge problems

If the merge fails or produces unexpected results, check these first: Make sure your Excel file is closed before you start the merge in Word — an open file can cause connection errors. Confirm that the Email column has no blank cells and that every email address is formatted correctly (no extra spaces, no typos). Verify that your merge field names exactly match your Excel column headers — FirstName is not the same as firstname or First Name.

If emails are not sending through Outlook, check your Outlook security settings. Some versions of Outlook block automated sends as a safety measure. You may need to lower your macro security level temporarily or use the "Edit individual emails" option to send manually instead. If you see merge field codes like «FirstName» in the final email instead of actual names, the merge did not execute properly — go back to Word, delete the template, and start over with a fresh document.

Frequently Asked Questions

Can I use a Google Sheet or other file type instead of Excel?

Word works most reliably with Excel files (.xlsx) or Access databases. Google Sheets can work if you read it as an Excel file first, but direct connections to Google Sheets are not always stable. CSV files also work, though formatting can be unpredictable. Stick with Excel for the smoothest experience.

What if I want to review every email before it sends?

Choose "Edit individual emails" instead of "Send Email Messages" in the Finish & Merge menu. Word will create a new document with all merged emails listed one after another. You can read and edit each one, then send them manually through Outlook. This takes longer but gives you full control.

Can I schedule the emails to send at a specific time?

Not directly through the mail merge process. Word sends emails when ready through Outlook. If you need scheduled sending, use the "Edit individual emails" option to create the merged emails, then manually move them to your Drafts folder and set a delay using Outlook's Delay Delivery feature on each one — though this is impractical for large lists.

What happens if someone's email address is wrong or missing?

If an email address is blank, Word will skip that row and not create an email for it. If an address is malformed or incorrect, Outlook will attempt to send but the email will bounce back. Always clean your data in Excel before merging — check for blank cells, extra spaces, and obvious typos.

Do I need to do this every time I want to send a bulk email?

No. Once you have created and saved your Word template with merge fields in place, you can reuse it. Just update your Excel data with new recipients, open the template in Word, reconnect to the updated Excel file, and run the merge again. The template itself does not change unless you want to edit the message content.