What a mail merge does and why you'd use it

A mail merge takes a list of names, addresses, or other details from a spreadsheet and automatically fills them into an email template you've written once. Instead of typing each recipient's name or address by hand, Outlook pulls the information from your data source and creates a separate email for each person. This saves time when you're sending similar emails to many people but want each one to feel personal.

The most common use is sending the same message to dozens of contacts with each person's name inserted in the greeting. You can also merge in addresses, company names, account numbers, or any other field your spreadsheet contains. Outlook doesn't call this feature "mail merge" the way Word does — it's built into Outlook's send process, but the steps are different depending on which version you're using.

Key Takeaways

  • Outlook itself doesn't have a built-in mail merge feature; you create the merge in Word and send through Outlook, or you use a third-party tool.
  • The Word method requires your data in an Excel spreadsheet with column headers (Name, Email, Company) that match the fields you want to insert.
  • You write your email template in Word, insert merge fields where you want names or details to appear, then preview and send through Outlook.
  • Third-party tools like Mail Merge for Outlook or Mailchimp offer a simpler interface if you find the Word process confusing.

Setting up your data in Excel before you start

Your data source must be an Excel spreadsheet with the first row containing column headers. Open a new Excel file and put "Email" in cell A1, "Name" in B1, "Company" in C1, or whatever fields you plan to use. Each row below the headers should contain one person's information. Make sure there are no blank rows in the middle of your data — Excel will stop reading when it hits an empty row.

Save the file with a straightforward name in a location you'll remember, like your Desktop. Don't use special characters or spaces in the filename. Close Excel completely before you move to the next step; if the file is open when you try to merge, Word may not read it correctly.

Creating your email template in Word

Open Microsoft Word and write the body of your email. Type out the message exactly as you want it to appear, including the greeting. For example: "Dear [NAME], Thank you for your interest in our program." Don't worry about the brackets yet — you'll replace them with actual merge fields in the next step.

Keep the template straightforward. Avoid complex formatting, images, or tables if you're new to mail merge; they can cause the merge to fail or look wrong. Once you're comfortable with the basic process, you can add those elements. Save this document with a clear name like "Email Template" in the same location as your Excel file.

Inserting merge fields into your Word template

In Word, go to the Mailings tab at the top of the screen. 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 — if you only have one sheet, it will select it automatically.

Now place your cursor in the template where you want the first piece of information to appear. Click Insert Merge Field and select the column header that matches what you want there — for example, "Name" or "Email". Word will insert it as <<Name>> or <<Email>>. Repeat this for every field you want to merge. Your template might look like: "Dear <<Name>>, Thank you for your interest in our program at <<Company>>."

Previewing the merge before you send

Before you commit to sending, preview what each email will look like. In the Mailings tab, click Preview Results. Word will show you the first merged email with actual names and details filled in. Use the arrow buttons to scroll through a few examples and check that everything looks right — names are spelled correctly, no extra spaces appear, and the formatting is clean.

If something looks wrong, click Preview Results again to turn it off, fix the template or your Excel data, and preview again. Common problems include extra spaces after merge fields (delete them) or mismatched column names (make sure your merge field name exactly matches the Excel header).

Sending merged emails through Outlook

Once the preview looks correct, go to the Mailings tab and click Finish & Merge. Choose Send Messages. A dialog box will appear asking which field contains the email addresses — select "Email" or whatever you named that column. Word will then create a separate email for each row in your spreadsheet and send them all through Outlook.

The emails will appear in your Outlook Sent folder. Word does the heavy lifting; Outlook straightforward sends what Word creates. This means you won't see a draft of each email before it goes out, which is why the preview step is so important. If you want to review each email individually before sending, choose Merge to New Document instead of Send Messages, and you'll get a Word document with all merged emails that you can edit before sending manually.

Using a third-party tool if the Word method feels complicated

If you find the Word process confusing or your version of Outlook doesn't cooperate, several tools offer a simpler interface. Mail Merge for Outlook (available in the Microsoft Store) lets you paste your data directly and write your template in a form rather than in Word. Mailchimp is free for up to 500 contacts and handles the merge and send in one place, though it's designed more for marketing emails than one-off messages.

These tools cost nothing or very little, and many people find them easier to use than the Word method. The trade-off is that you're trusting a third-party service with your contact list and email content. Read the privacy policy of any tool you choose to understand what happens to your data after the send is complete.

Frequently Asked Questions

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

The Word mail merge method sends when ready. If you need to schedule, use Merge to New Document to create all emails in one Word file, then copy and paste each into Outlook and set the send time individually. For larger batches, a third-party tool like Mailchimp lets you schedule the entire merge to send at a specific date and time.

What if my Excel file has more than one sheet?

Word will ask you to select which sheet contains your data when you choose your recipient list. Make sure the sheet with your contact information is the one you select. Only that sheet's data will be used in the merge.

Can I merge images or attachments into each email?

The Word mail merge method doesn't support merging different attachments per recipient. You can include one attachment that goes to everyone, but not a different file for each person. For that, you'd need a third-party tool or a script designed for bulk email with variable attachments.

What happens if someone's email address is missing from my Excel file?

Word will skip that row when you send. Make sure every row has an email address in the Email column, or that row won't receive anything. Check your Excel file before previewing to catch any blanks.

Can I use mail merge with Outlook templates or signatures?

Your Outlook signature will be added to each merged email automatically. Outlook templates don't work with the Word mail merge process — you write your template in Word instead. If you want to use an Outlook template, you'll need to copy its content into your Word template before merging.