What a mail merge does and why you'd use it
A mail merge takes a list of names, email addresses, and other details from a spreadsheet and plugs them into an email template you write once. Outlook then sends a separate, personalized copy to each person on the list. Instead of writing "Hi Sarah" in one email and "Hi Marcus" in another, you write the template once with a placeholder like "Hi [FirstName]", and Outlook fills in the actual name for each recipient.
This is useful when you need to send the same message to dozens or hundreds of people but want each one to feel personal. Common uses include sending newsletters with each person's name, notifying a group that their registration is confirmed with their specific confirmation number, or inviting people to an event with their individual registration link.
Outlook does not have a built-in mail merge feature the way Word does. Instead, you'll use Word to create the merge, then send the emails through Outlook. This takes a few extra steps, but the process is straightforward once you know the order.
Key Takeaways
- Mail merge in Outlook requires you to create the template in Word, not in Outlook itself, then send the merged emails through Outlook.
- Your data source must be a spreadsheet with column headers in the first row — typically an Excel file, CSV file, or Access database.
- You insert merge fields (like [FirstName] or [Email]) into your Word template, and Word replaces them with actual data when you run the merge.
- The final step is opening the merged document in Outlook and sending all the emails at once, rather than one at a time.
Prepare your data in a spreadsheet
Before you touch Word or Outlook, you need a clean data file. Open Excel or Google Sheets and create a spreadsheet with one column for each piece of information you want to personalize. The first row must contain column headers — these are the names Word will recognize when you insert merge fields.
For example, if you're sending a confirmation email, your spreadsheet might have columns labeled: FirstName, LastName, Email, ConfirmationNumber, EventDate. Each row below the headers contains one person's data. Make sure there are no blank rows in the middle of your list, and double-check that email addresses are spelled correctly — a typo here means the email bounces.
Save this file as an Excel workbook (.xlsx) or as a CSV file. If you're using Google Sheets, download it as an Excel file before moving to the next step. Note the exact location where you saved it — you'll need to find this file when you open Word.
Create your email template in Word
Open a new blank document in Microsoft Word. Write the body of the email exactly as you want it to appear, except where you need personalization. For example: "Hi [FirstName], thank you for registering for our event on [EventDate]. Your confirmation number is [ConfirmationNumber]."
Do not include "To:", "From:", or "Subject:" lines yet — you'll add those through Word's mail merge dialog, not by typing them. Just write the message body as if you were pasting it into an email.
Once your template text is written, go to the Mailings tab at the top of Word. Click Start Mail Merge, then select Email Messages from the dropdown. This tells Word you're preparing a mail merge for email, not letters or labels.
Connect Word to your data file
Still in the Mailings tab, click Select Recipients. Choose Use an Existing List. A file browser will open — navigate to the spreadsheet you created and saved earlier, then click Open.
Word will show you a preview of your data. Make sure the correct worksheet is selected (if your Excel file has multiple sheets) and that all your rows appear. Click OK to confirm. Word now knows where your data is and what columns it contains.
Insert merge fields into your template
Go back to your email template text in Word. Click at the spot where you want the first personalized detail to appear. In the Mailings tab, click Insert Merge Field and select the column name from the dropdown — for example, FirstName. Word inserts a placeholder like <<FirstName>> into your document.
Repeat this for every piece of information you want to personalize. If your template says "Your confirmation number is [ConfirmationNumber]", click where you want the number, then insert the ConfirmationNumber merge field. The placeholders will look like gray boxes with the field name inside — this is normal and expected.
Once all your merge fields are in place, save this Word document with a clear name like "EmailTemplate_Merge.docx". You'll use this file to generate the actual emails.
Set the subject line and preview the merge
Before you generate all the emails, you need to tell Word what the subject line should be. In the Mailings tab, click Email Merge (or Merge to Email, depending on your Word version). A dialog box will open asking for the subject line. Type the subject you want — for example, "Your Event Confirmation" — and click OK.
Word will now show you a preview of what the first merged email will look like. Check that the merge fields have been replaced with actual data from your spreadsheet. If the first email looks wrong, click the back arrow to return to your template and fix the problem before proceeding.
If the preview looks correct, click Next or OK to proceed. Word will create a new document containing all the merged emails, one per page, ready to send.
Send the merged emails through Outlook
The merged document Word created is not yet sent — it's just a Word file with all your personalized emails. To send them, you need to open this document in Outlook. Go to File in Word, then Share, and look for an option like Send Using Email or Send to Email Recipients. This varies by Word version.
Alternatively, open Outlook directly. Go to File > New > Mail Message, then in the message window, click Mailings (if visible) or use File > Open to open your merged document. The exact path depends on your Outlook and Word version.
Once the merged emails are open in Outlook, review the list of recipients one more time. Then click Send All or the equivalent button to send all the emails at once. Outlook will send one personalized copy to each person on your list.
Troubleshooting common problems
If merge fields show as <<FieldName>> instead of actual data, the data file may not have loaded correctly. Go back to Select Recipients and re-choose your spreadsheet file. If some emails are missing recipients or showing blank fields, check your spreadsheet for empty cells or misspelled column headers.
If Outlook won't open the merged document, make sure you're using a recent version of both Word and Outlook. Older versions sometimes have compatibility issues. As a workaround, you can copy the merged emails from Word and paste them into individual Outlook messages, though this is slower.
If you're unsure whether the emails actually sent, check your Outlook Sent folder a few minutes after clicking Send. The emails should appear there with the recipient's actual email address, not a merge field placeholder.
Frequently Asked Questions
Can I use a Google Sheet or CSV file instead of Excel?
Yes. If you're using Google Sheets, download it as an .xlsx file first. CSV files work too — just save your spreadsheet as CSV and point Word to that file when you select recipients. The process is identical from that point on.
What if I want to send the emails at different times, not all at once?
After Word creates the merged document, you can save it and send batches of emails later. Open the merged document in Outlook, select only the emails you want to send (by holding Ctrl and clicking each one), then send just those. This lets you spread sends across multiple days if you prefer.
Can I include attachments in a mail merge email?
Word's mail merge does not automatically attach different files to different emails. However, you can attach the same file to all merged emails by adding an attachment to the template before you run the merge. If you need different attachments per person, you'll need to send those emails individually or use a third-party tool.
What happens if someone's email address is wrong in my spreadsheet?
Outlook will attempt to send to that address and the email will bounce back to your Sent folder with a delivery failure notice. Check your spreadsheet carefully before running the merge. If you catch an error after sending, you can resend to the corrected address, but the original bounced email will still appear in your Sent folder.
Do I need to keep the Word template and spreadsheet after sending?
You can delete them if you don't plan to send similar emails again. However, keeping them makes it easy to send the same message to a new list of people later — just update the spreadsheet with new names and email addresses, then run the merge again using the same template.