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 recipient's name, company, or other details automatically filled in. Instead of writing fifty individual emails or copying and pasting names by hand, you create one template email and connect it to a list of names and information. Outlook then generates a separate email for each person on your list, with their specific details inserted where you marked them.

This is useful when you're sending a job rejection to twenty candidates, notifying clients of a policy change with their account number included, or inviting a group to an event with each person's registration link. The recipient sees a personalized message, not a mass email with their name pasted in obviously.

Mail merge in Outlook works differently than the mail merge in Word — you'll be using Word as the tool that creates the merged emails, then sending them through Outlook. This matters because you need both programs installed and need to understand which one you're working in at each step.

Key Takeaways

  • Mail merge requires Word and Outlook both installed on your computer — the process starts in Word, not in Outlook itself.
  • You need two things: a template email in Word with merge fields marked (like <<FirstName>>), and a data source with the actual names and information in rows and columns.
  • Your data source can be an Excel spreadsheet, an Access database, or a list you type into Word — Excel is the easiest for most people.
  • After you preview the merged emails to catch mistakes, Word creates individual emails in Outlook that you review and send one batch at a time.
  • Mail merge does not send emails automatically — you always review and manually send each batch, which protects you from sending errors to your whole list.

Setting Up Your Data Source

Before you open Word, prepare the list of people and information you want to merge. The easiest method is to use an Excel spreadsheet with one row of column headers at the top and one row for each person below it. Your first row might look like: FirstName, LastName, Company, Email, RegistrationLink. Each row below contains one person's information in the same order.

Make sure your column headers have no spaces or special characters — use FirstName instead of First Name, and CompanyName instead of Company Name. Save this file somewhere you can find it again; you'll point Word to it during the merge process. If you don't have Excel, you can create the same structure in a Word table or even type it into a Google Sheet and read it as an Excel file.

Check your data for typos and missing information before you start the merge. A mistake in your source list will appear in every email, and you'll have to redo the whole process to fix it. If someone's first name is blank, that person's email will have an empty space where their name should be.

Creating Your Email Template in Word

Open a new blank document in Word. Type the email you want to send, including the greeting, body, and closing. Write it as if you're sending it to one person — for example, "Dear John," instead of "Dear [Name],". This is where you'll add the merge fields that pull information from your data source.

Position your cursor where you want the first piece of information to appear. Go to the Mailings tab at the top of Word. Click Insert Merge Field and select the column header that matches what you want there — if you want the person's first name, select FirstName. Word inserts it as <<FirstName>> in your document. Repeat this for every piece of information you want personalized.

Your template might look like this: "Dear <<FirstName>>, Thank you for explore to our company. We have decided to move forward with other candidates. Best regards, Hiring Team." When the merge runs, <<FirstName>> becomes "John" in John's email, "Sarah" in Sarah's email, and so on.

Connecting Your Data Source to Your Template

With your template open in Word, stay on the Mailings tab. Click Select Recipients and choose Use an Existing List. Navigate to your Excel file (or whatever file holds your data) and open it. Word asks which sheet you want to use if your Excel file has multiple sheets — select the one with your data.

After you select your file, Word shows you a preview of what the merged emails will look like. Click Edit Recipient List to review the data Word found. Make sure all the names and information are there and spelled correctly. You can uncheck any rows you don't want to include in this merge — for example, if you want to send to everyone except one person, uncheck that person's row instead of redoing the whole file.

Close the recipient list dialog when you're satisfied. Your template is now connected to your data, and you're ready to preview the actual merged emails.

Previewing Merged Emails Before Sending

Before you create the emails in Outlook, preview them to catch any mistakes. On the Mailings tab, click Preview Results. Word shows you what the first email will look like with the actual data filled in. Use the arrow buttons to scroll through several emails and check that names, companies, links, and other details are correct and in the right places.

If you spot a mistake in the data (like a misspelled name), close the preview, go back to your Excel file, fix it, and save. Then in Word, click Select Recipients again and reopen your file — Word will reload the corrected data. If the template itself is wrong (like a merge field in the wrong place), fix the template text and re-insert the merge field correctly.

Once the preview looks right, turn off Preview Results so you see the merge fields again (<<FirstName>>, etc.) instead of the actual data. This confirms you're about to create the emails, not send them.

Creating and Sending Emails Through Outlook

On the Mailings tab, click Finish & Merge and select Send Email Messages. Word opens a dialog asking which field contains the email addresses. Select the column header that has the email addresses — usually Email or EmailAddress. Leave the other fields blank unless you want to change the subject line or add a message in the dialog itself (most people don't).

Click OK. Word creates individual emails in Outlook for each person on your list. These emails appear in Outlook's Drafts folder, not sent yet. Open Outlook and go to your Drafts folder. You'll see one email for each person, each with their personalized information filled in. Review a few of them to make sure everything looks correct.

Select all the emails in Drafts (Ctrl+A), then click Send. Outlook sends them all at once. If you want to send them in smaller batches instead, select just a few emails, send those, wait, then send the rest. This is safer if something goes wrong — you catch the problem before sending to everyone.

Troubleshooting Common Problems

If the merge fields show as <<FirstName>> instead of actual names when you preview, make sure your data source file is saved and closed. Word sometimes can't read an open Excel file. Close Excel, then in Word click Select Recipients and reopen your file.

If emails appear in Outlook with blank spaces where names should be, someone in your data source list has a missing value in that column. Go back to your Excel file, find the blank cell, fill it in, save, and redo the merge. If you want to skip that person instead, uncheck their row in the recipient list before you finish the merge.

If you don't see the Mailings tab in Word, you're using Word Online instead of the desktop version. Mail merge only works in the desktop version of Word installed on your computer. If you only have Word Online, you'll need to read the desktop version or use a different method to personalize emails.

Frequently Asked Questions

Can I use mail merge to send emails with attachments?

No — mail merge in Outlook does not attach files to the merged emails. You can include a link to a file in the email body (like a merge field with a read link), but not a file attachment. If you need to send different attachments to different people, you'll need to send those separately or use a third-party tool designed for that purpose.

What if I want to send the same email to a group but not personalize it?

Mail merge is overkill for that. Instead, create one email in Outlook, add all recipients to the To or Bcc field, and send it once. Use Bcc if you don't want recipients to see each other's email addresses. Mail merge is only worth the setup time when you're personalizing content for each recipient.

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

No — merged emails land in Outlook's Drafts folder and you send them manually. Outlook does have a "Delay Delivery" feature for individual emails, but it doesn't work well with large batches. If you need to schedule sends, you'll need a third-party email tool or service designed for that.

What happens if I accidentally close Word before finishing the merge?

Your template and data connection are saved in the Word document. Open the document again, go to the Mailings tab, and pick up where you left off. You don't have to start over. Word remembers which data source you connected to, though it may ask you to confirm the connection when you reopen the file.

Can I edit a merged email after it's created but before I send it?

Yes — merged emails sit in Outlook's Drafts folder as regular emails. Open any one, make changes, and save. Those changes explore only to that email. If you want to change something in all the emails, you'll need to redo the merge from Word with the corrected template or data.