Mail merge in Outlook works by connecting your email to a data source like an Excel spreadsheet, then automatically filling in names, addresses, or other details into each message you send

Outlook does not have a built-in mail merge feature the way Word does. Instead, you use Word as the middleman: Word handles the merge logic, and Outlook sends the finished emails. You start by creating a template in Word with placeholder fields (like <<FirstName>>), connecting it to your data file, and then telling Word to send the results through Outlook instead of printing or saving them.

The process takes about 15 to 20 minutes to set up the first time, and most of that time goes to organizing your data file correctly. Once you understand the steps, you can reuse the same template for future campaigns by just swapping in a new data file.

Key Takeaways

  • Mail merge in Outlook requires Word as the template editor and a data file (usually an Excel spreadsheet) with one column per field you want to insert.
  • Your data file must have headers in the first row that match exactly what you type in your Word template placeholders.
  • You create the merge in Word, not Outlook, by going to Mailings > Start Mail Merge > Letters, then selecting your data source.
  • The final step is Mailings > Finish & Merge > Send Email Messages, which opens Outlook and sends one email per row in your data file.
  • Outlook will not send the emails automatically; you must review and click Send in the Outlook compose window for each message.

Prepare your data file before opening Word

Your data source is usually an Excel spreadsheet, though it can also be a CSV file, an Access database, or even a Contacts folder. The most common choice is Excel because it is easy to edit and most people already have it.

Open Excel and create a new spreadsheet. The first row must contain headers — these are the field names you will reference in Word. For example, if you want to insert someone's first name, put "FirstName" in cell A1. Put "LastName" in B1, "Email" in C1, and so on. Every row below the headers is one person who will receive an email. Make sure there are no blank rows in the middle of your data, and do not leave extra blank columns at the end. Save the file as an Excel workbook (.xlsx) in a folder you can easily find later.

Common headers to include are FirstName, LastName, Email, Company, and Title. Use exactly these names (with no spaces or special characters except underscores) because you will type them into Word later, and they must match character-for-character.

Create your email template in Word

Open a new blank document in Word. This is where you write the email body that everyone will receive, with placeholders for the fields that change from person to person.

Type your email as you normally would. Where you want to insert a field from your data file, type it in double angle brackets. For example, if you want to say "Hello John" to each person, type "Hello <<FirstName>>". If you want to include their company name, type "We look forward to working with <<Company>>". The text inside the brackets must match your Excel headers exactly — if your header is "FirstName" but you type "<<First Name>>" with a space, the merge will fail and you will see the placeholder text instead of the actual name.

Do not add a subject line in the Word document. You will set that in Outlook after the merge is complete. Save this template with a clear name like "Email_Template_Merge.docx" so you can find it again.

Connect Word to your data file and preview the merge

With your template open in Word, go to the Mailings tab at the top. Click Start Mail Merge and select Letters (even though you are sending email, not letters — this is just the merge type Word uses). Next, click Select Recipients and choose Use an Existing List. Navigate to your Excel file and open it. Word will ask which sheet to use; if you only have one sheet, it will select it automatically.

Word will now show you a preview of what each email will look like. Click the forward and back arrows in the Mailings tab to scroll through a few examples and make sure the names and other fields are filling in correctly. If you see <<FirstName>> instead of an actual name, go back to your Excel file and check that the header matches exactly what you typed in the template.

Send the merged emails through Outlook

Once the preview looks correct, go to Mailings and click Finish & Merge. Select Send Email Messages. A dialog box will appear asking for three things: the field that contains the email addresses (select "Email" from the dropdown), the subject line for all the emails, and whether to send to all recipients or just a range.

Type your subject line in the dialog. This subject will be the same for every email. Click OK. Word will now open Outlook and create one compose window for each person in your data file. Each email will have the recipient's address filled in, the subject line you entered, and the body with all the placeholders replaced with actual names and details.

Here is the important part: Outlook will not send these emails automatically. You will see each compose window one at a time. Review the first email to make sure it looks right, then click Send. Outlook will move to the next one. If you have 50 people on your list, you will click Send 50 times. There is no way to send them all at once from this dialog, so if you have a very large list, this method becomes tedious — in that case, you might want to look into third-party tools or Outlook's built-in campaign features.

Troubleshoot common merge problems

If the merge does not work, the most common cause is a mismatch between your Excel headers and your Word placeholders. Open both files side by side and check that every header name is spelled the same way, with the same capitalization and spacing. "FirstName" and "firstname" are different to Word.

If Outlook does not open after you click Send Email Messages, make sure Outlook is installed and set as your default email client. Go to Settings > Apps > Default Apps on Windows and scroll down to Email to check. If Outlook is not listed, you may need to install it or use a different mail merge method.

If you see the placeholder text (like <<FirstName>>) in the actual email instead of the person's name, the merge did not complete. Go back to Word, click Mailings > Edit Recipient List, and verify that your data file is still connected and the fields are recognized. Sometimes closing and reopening the template file fixes this.

When to use mail merge versus other methods

Mail merge is useful when you have a list of 10 or more people and you want to personalize each email with their name or company. For fewer than 10 people, it is usually faster to just type the emails individually or use Outlook's Find & Replace feature to swap in a few names.

If you need to track opens, clicks, or replies, mail merge is not the right tool — it sends individual emails but does not give you analytics. For marketing campaigns, consider Mailchimp, Constant Contact, or similar services that are built for that purpose. Mail merge is best for internal communications, customer outreach, or one-time campaigns where you just need the emails to go out with personalized details.

Frequently Asked Questions

Can I use mail merge to send emails to a contact group instead of a spreadsheet?

Not directly through the standard mail merge process. You can export your Outlook contacts to an Excel file, then use that as your data source. Right-click a contact group in Outlook, select Export, and save it as a CSV file. Open that CSV in Excel, clean up any extra columns, and use it as your merge source.

What if I want different subject lines for different people?

Add a "Subject" column to your Excel file with the subject line for each person. In Word, instead of typing a subject in the dialog box, leave it blank and Word will use the Subject field from your data file for each email. This takes more setup but gives you full control.

Can I schedule the emails to send later instead of sending them right away?

No. Mail merge sends emails immediately as you click Send in each compose window. If you need to schedule sends, you will need to use a third-party email marketing platform or manually set a delay rule in Outlook for each message, which defeats the purpose of mail merge.

Do I need to keep the Word template and Excel file in the same folder?

No, but it is a good idea. Word remembers the path to your data file, so if you move the Excel file to a different folder, Word will ask you to locate it again the next time you open the template. Keeping them together makes it easier to share the files or move them to a new computer.