What a mail merge does and where to start

A mail merge in Outlook takes a list of names, addresses, or other contact information and automatically fills them into a template letter or email. Instead of typing the same message fifty times with different names, you create one template, connect it to your contact list, and Outlook generates a personalized version for each person. The result is a stack of individual emails or documents ready to send.

Outlook itself does not run the merge — it receives the finished emails from Word, which is where the actual merge happens. You will need both Outlook and Word open, plus a list of contacts in either an Excel spreadsheet, an Access database, or your Outlook contacts folder. The process takes about ten minutes once you have those pieces in place.

Key Takeaways

  • Mail merge happens in Word, not Outlook, but Word pulls addresses from Outlook or from an Excel file you provide.
  • You need three things: a template document in Word, a list of contacts with names and email addresses, and both programs open at the same time.
  • Word creates individual emails and sends them through Outlook automatically once you complete the merge.
  • The most common mistake is forgetting to include an email address column in your contact list, which stops the merge from sending anything.

Preparing your contact list before you start

Your contact list must be in one of three places: an Excel spreadsheet, an Access database, or your Outlook contacts folder. Excel is the easiest if you are starting from scratch. Open a new spreadsheet and create column headers in the first row — at minimum you need Email Address, but you will probably also want First Name, Last Name, Company, or any other detail you want to personalize in your message.

Each row below the headers is one person. Make sure the email address column has actual email addresses with no typos, because Word will use these to send the finished emails. If you are pulling from Outlook contacts instead, open Outlook, go to your contacts folder, and make sure the people you want to reach have email addresses filled in. Word can read directly from Outlook, so you do not need to export anything first.

Save your Excel file before moving to Word. Use a straightforward name like "Merge List" and remember where you saved it — you will need to browse to it in a moment.

Creating your template in Word

Open Word and create the message you want to send. Write it as if you are sending it to one person, but leave blanks where the personalized information goes. For example, instead of "Dear John," write "Dear [First Name]," and instead of a fixed company name, write "[Company]." These bracketed placeholders are called merge fields, and Word will replace them with real data from your contact list.

Type your message in plain language first, then go back and add the merge fields. Do not worry about the exact format yet — you are just writing the content. If your message is short, write it in the body of the email. If it is longer, you can write it in a Word document and then copy it into the email template later.

Inserting merge fields into your template

With your template open in Word, click the Mailings tab at the top of the screen. If you do not see it, you may be in a different view — make sure you are in the main Word window, not a web version. In the Mailings tab, click Select Recipients on the left side. A dropdown menu appears with three options: Use an Existing List, Select from Outlook Contacts, or Type a New List.

Choose Use an Existing List if your contacts are in Excel. A file browser opens — navigate to your spreadsheet and click Open. Word asks you to confirm which sheet contains your data and which row has your headers. Click OK. If your contacts are in Outlook instead, choose Select from Outlook Contacts and Word will show you your contact folders.

Now place your cursor in the template where you want the first merge field to appear. Click Insert Merge Field in the Mailings tab. A dropdown list shows every column header from your contact list. Click the one you want — for example, First Name. Word inserts it as <<First Name>> in your template. Repeat this for every piece of personalized information in your message.

Previewing the merge before you send

Before Word generates all the emails, preview a few to make sure the merge fields are working correctly. In the Mailings tab, click Preview Results. Your template now shows real data from your contact list instead of the merge field names. Use the arrow buttons next to Preview Results to flip through a few examples and check that names, addresses, and other details are appearing in the right places.

Look for common problems: names appearing in the wrong field, email addresses missing, or text running into the merge fields awkwardly. If something is wrong, click Preview Results again to turn off the preview, fix the template, and then turn the preview back on. Once the preview looks correct, you are ready to finish the merge.

Completing the merge and sending emails

In the Mailings tab, click Finish & Merge on the right side. A dropdown menu offers three options: Send Email Messages, Edit Individual Documents, or Merge to New Document. Choose Send Email Messages if you want Word to send all the emails when ready through Outlook.

A dialog box appears asking for the field that contains the email addresses. Click the dropdown and select Email Address (or whatever you named that column). You can also set the subject line here — type it in the Subject line field. Click OK, and Word generates all the emails and sends them through Outlook. This usually takes a few seconds. You will see a progress bar, and when it finishes, the emails are in your Outlook Sent folder.

If you want to review each email before sending, choose Edit Individual Documents instead. Word creates a new document with all the merged emails stacked together, separated by page breaks. You can read through them, make changes to individual copies if needed, and then send them manually from Outlook.

Troubleshooting common problems

If Word says "No data source selected" or "No recipients," you skipped the Select Recipients step. Go back to the Mailings tab, click Select Recipients, and choose your contact list. If the merge fields are not being replaced with real data, make sure you clicked Preview Results — sometimes they stay as field names until you turn on the preview.

If emails are not sending, check that your contact list has an Email Address column with actual email addresses in every row. Blank cells or typos will cause those rows to skip. If Outlook is not opening or the emails are not appearing in your Sent folder, make sure Outlook is running in the background before you start the merge — Word needs it open to send through.

If only some of the emails sent, check your Outlook Sent folder to see which ones went through. The merge does not stop if one email fails — it keeps going. Look at the contact list to see if there is a pattern (for example, all emails from one company failed because of a typo in the address).

Frequently Asked Questions

Can I send a mail merge to both email and print letters at the same time?

No, you have to do them separately. Create one merge for email using Send Email Messages, then create a second merge for printed letters using Merge to New Document. Save the printed version and send it to your printer. This takes a few extra minutes but lets you use the same contact list for both.

What if I want to skip certain people in my contact list?

In the Mailings tab, click Edit Recipient List. A window opens showing all your contacts with checkboxes next to each name. Uncheck the people you want to skip, then click OK. The merge will only run for the checked names.

Can I use a mail merge with an Outlook distribution list?

Not directly — Word does not read distribution lists. Instead, export the distribution list to Excel or copy the members into a new contact folder, then use that folder as your recipient list. In Outlook, right-click the distribution list, choose Export, and save it as a CSV file, which you can then open in Excel.

What happens if I edit the contact list after I start the merge?

Changes you make to the contact list after you click Select Recipients will not show up in the merge. Word takes a snapshot of your contacts at that moment. If you need to add or change someone, close the merge, update your contact list, and start over.

Can I schedule a mail merge to send at a specific time?

Word and Outlook do not have a built-in delay feature for merged emails. The emails send when ready when you click OK. If you need to send them later, use Edit Individual Documents instead, save the merged document, and send the emails manually from Outlook at the time you want.