Mail merge in Outlook works through a three-step process: prepare a contact list in Excel, create a template email in Word, and use Word's mail merge feature to send personalized versions through Outlook
Outlook itself does not have a built-in mail merge button. Instead, you use Microsoft Word to do the actual merging, then send the results through Outlook. This means you need Word, Outlook, and a spreadsheet (usually Excel) all on the same computer. If you use only Outlook without Word, you will need to use a third-party tool or send emails one at a time.
The process takes about 15 to 30 minutes the first time, depending on how many names and fields you need to personalize. Once you have done it once, repeating it with a new contact list takes about 5 minutes.
Key Takeaways
- Mail merge requires three programs: Excel (or another spreadsheet) for your contact list, Word for your email template, and Outlook to send the finished emails.
- Your Excel file must have column headers in the first row — Name, Email, Company, or whatever fields you plan to personalize — and one contact per row below.
- In Word, you insert merge fields (like <<FirstName>>) where you want personalized information to appear, then use the Mailings tab to complete the merge.
- Word creates a new email for each contact, and you send them all at once through Outlook, not one at a time.
Set up your contact list in Excel
Open Excel and create a new spreadsheet. In the first row, type the column headers you will use: Email, FirstName, LastName, Company, or any other field you want to personalize in your message. Each header becomes a merge field you can insert into your Word template later.
Starting in row 2, enter one contact per row. Put email addresses in the Email column — this is required for mail merge to work. Fill in the other columns with the information you want to personalize. If a contact is missing information for a column, leave that cell blank; Word will straightforward skip that merge field for that person.
Save the file as an Excel workbook (.xlsx) in a folder you can find easily. Do not save it as .csv or .txt; Excel format works more reliably with Word's mail merge. Close the file before you move to Word — Word needs to open it fresh during the merge process.
Create your email template in Word
Open a new Word document. Type the body of your email exactly as you want it to appear, except where you need personalized information. For example: "Hi FirstName, thank you for your interest in our program at Company." Do not worry about the subject line yet; you will add that during the merge.
Wherever you want a name, company, or other personalized detail to appear, you will insert a merge field. Do not type the person's actual name — type a placeholder like FirstName or Company, and you will replace it with a merge field in the next step.
Save this document with a clear name like "Email Template" in the same folder as your Excel file. You will use this template each time you do a mail merge, so keep it somewhere you can find it again.
Insert merge fields into your Word template
In Word, click the Mailings tab at the top of the screen. Click Start Mail Merge, then select Email Messages from the dropdown menu. This tells Word you are creating emails, not letters or labels.
Next, 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. Click OK.
Now go back to your template and delete the placeholder text (like the word "FirstName"). Click exactly where that personalized information should go. Click Insert Merge Field and select the column header from your Excel file — for example, FirstName. Word inserts <<FirstName>> into your document. Repeat this for every field you want to personalize.
Your template might now read: "Hi <<FirstName>>, thank you for your interest in <<Company>>." This is correct. When you complete the merge, Word will replace <<FirstName>> with each person's actual first name and <<Company>> with their company.
Preview and complete the merge
Before you send anything, preview how the emails will look. In the Mailings tab, click Preview Results. Word shows you what the first email will look like with real data from your Excel file. Use the arrow buttons to scroll through a few examples and check that the personalization looks correct.
If something looks wrong — a name is misspelled in Excel, or a merge field is in the wrong place — go back and fix it in either Excel or your Word template, then preview again. Do not proceed until the preview looks right.
Once the preview looks correct, click Finish & Merge and select Send Email Messages. Word will ask which column contains the email addresses — select Email (or whatever you named that column in Excel). Word will also ask for a subject line. Type the subject you want all emails to have. You can include merge fields in the subject line too, like "Hi <<FirstName>>" if you want each email to have a personalized subject.
Send the merged emails through Outlook
After you click Send, Word creates a new email message for each contact and sends them all through Outlook at once. This happens in the background — you may see a progress bar, or it may finish without any visible notification. The emails go directly to your contacts' inboxes; they do not sit in your Outlook Drafts folder first.
Check your Outlook Sent folder a few minutes later to confirm the emails were sent. You should see one message per contact, each with a different recipient address. If you see only one message in Sent, something went wrong — go back to Word and check that you selected the Email column correctly when you clicked Finish & Merge.
Once the merge is complete, you can close your Word template and Excel file. Keep both files if you plan to send similar emails to a different group later — you can reuse the template and just update the Excel file with new contacts.
Troubleshooting common problems
Word says it cannot find your Excel file. Make sure the Excel file is saved and closed before you start the mail merge. If it is still open, Word cannot access it. Also check that the file is saved as .xlsx, not .csv or another format.
Merge fields show as <<FieldName>> in the final emails instead of actual names. This usually means the merge did not complete. Go back to Word, click Finish & Merge again, and make sure you selected the correct Email column. If it still does not work, close Word and Excel completely, reopen them, and try again.
Some emails are missing or some contacts did not receive anything. Check your Excel file for blank cells in the Email column. Mail merge skips any row that has no email address. Also check that there are no extra spaces before or after email addresses — "john@example.com " (with a space at the end) will cause delivery problems.
You want to personalize the subject line but it looks the same for everyone. Make sure you inserted a merge field in the subject line field when Word asked for it. If you just typed a plain subject, all emails will have the same subject. Go back and redo the merge with a merge field in the subject.
Frequently Asked Questions
Can I use mail merge if I only have Outlook, not Word?
No. Outlook does not have a mail merge feature built in. You need Word to create the template and do the merging. If you do not have Word, you can use a third-party mail merge tool like Mailchimp or a Gmail extension, but those are separate programs and work differently than the Outlook-Word process.
What if I want to attach the same file to every email?
In your Word template, before you start the mail merge, insert the attachment using Word's Insert menu (Insert > Attach File). The attachment will be included in every merged email. If you want different attachments for different people, mail merge cannot do that — you would need a third-party tool or a macro.
Can I schedule the emails to send later instead of right now?
No. Mail merge sends all emails when ready when you click Send. Outlook's delay delivery feature does not work with mail merge. If you need to schedule emails, you would need to use a third-party tool or send them manually.
Do I need to be connected to the internet for mail merge to work?
Yes. Mail merge sends emails through Outlook, which requires an internet connection and an active email account. Make sure Outlook is set up and working before you start the merge. If Outlook cannot send regular emails, it cannot send merged emails either.
What happens if someone's email address is wrong in my Excel file?
The email will bounce back to your Outlook inbox as undeliverable. Check your Excel file carefully for typos before you start the merge. If you catch an error after sending, you can update Excel and redo the merge with a new batch of contacts, but you cannot unsend the emails that already went out.