Merge mail in Excel means pulling names, addresses, or other details from a spreadsheet into a template email so you send personalized messages to many people at once

Excel itself does not have a built-in mail merge feature. Instead, you use Excel as the data source and let Outlook (Microsoft's email program) handle the merge. Outlook reads the names and addresses from your Excel file and fills them into a template email you create, then sends a separate personalized copy to each person on your list.

The process has three parts: prepare your Excel data in the right format, create a mail merge template in Outlook, and run the merge. Most people complete this in 15 to 30 minutes once they understand the steps.

Key Takeaways

  • Your Excel file must have column headers in the first row (like "First Name", "Email Address", "Company") so Outlook knows which data goes where.
  • Mail merge works through Outlook, not Excel — you create the template email in Outlook and tell it to pull data from your spreadsheet.
  • Each column in Excel becomes a field you can insert into your email, so "First Name" in column A lets you write "Dear [First Name]" in the message.
  • You must save your Excel file before starting the merge, and Outlook needs to be your default email program for the feature to work.

Set up your Excel spreadsheet with the right structure

Open Excel and create a new spreadsheet. In the first row, type the column headers — these are the labels that tell Outlook what each column contains. Common headers are "First Name", "Last Name", "Email Address", "Company", and "Title". Type each header in its own cell across the top row.

Below the headers, enter your data. Put one person per row. If your header is "First Name" in column A, type the actual first names in column A rows 2, 3, 4, and so on. Keep the data clean: no extra spaces before or after names, no blank rows in the middle of your list. Save the file with a clear name like "Mail Merge List.xlsx" in a location you can find easily.

Check that every row has data in the columns you plan to use in your email. If you have 50 people but only 30 have a company name, that is fine — you can still merge. Just do not leave random blank cells in the middle of your list, because Outlook may stop reading the data when it hits an empty row.

Create your email template in Outlook

Open Outlook and start a new email. Do not fill in the "To" field yet — mail merge will do that automatically. Write your subject line and the body of your email as you normally would, but leave placeholders where you want the personalized data to appear.

For example, if you want to greet each person by their first name, type "Dear [First Name]," in the email body. The brackets and the exact column header name tell Outlook where to insert the data. If your Excel column is called "First Name", use [First Name]. If it is called "FirstName" with no space, use [FirstName]. The name must match exactly.

You can use as many fields as you need. A sample email might read: "Dear [First Name], Thank you for your interest in [Company]. We look forward to working with you." Outlook will replace [First Name] and [Company] with the actual data from each row of your spreadsheet.

Start the mail merge from Outlook

With your template email open in Outlook, go to the Mailings tab at the top of the screen. (If you do not see a Mailings tab, you may be using a version of Outlook that does not support mail merge — see the FAQ section below.) Click Start Mail Merge, then select Step by Step Mail Merge Wizard.

The wizard opens a panel on the right side of your screen. It walks you through four steps. In Step 1, choose Email Messages as the document type. In Step 2, select Use the current document so Outlook uses the email template you just wrote. Click Next to move forward.

In Step 3, click Browse and navigate to your Excel file. Select it and click Open. Outlook reads the file and shows you a preview of your data. Check that the names and addresses look correct. If you see blank rows or strange data, go back to Excel, fix the file, save it, and start the merge again.

Insert fields and preview the merged emails

Back in the wizard, you are now at the step where you insert the field placeholders into your email. Position your cursor in the email body where you want data to appear — for example, right after "Dear ". Click More Items in the wizard panel, select the field you want (like "First Name"), and click Insert. Outlook adds the field code to your email.

Repeat this for every field you need. You can also type the field names manually with brackets if you prefer — [First Name], [Email Address], and so on. Either method works. Once all your fields are in place, click Preview Your Email in the wizard. Outlook shows you what the first email will look like with real data filled in. Use the arrow buttons to scroll through and check a few examples.

If the data looks wrong — names are in the wrong place, fields are blank, or text is misaligned — click Back and fix the template or the Excel file. Do not proceed until the preview looks correct.

Complete the merge and send

When the preview looks right, click Complete the Merge in the wizard. You have two options: Edit Individual Messages or Send Email Messages. If you choose Edit Individual Messages, Outlook creates a new email for each person in your list and opens them all in a new window. You can review and edit each one before sending. This takes longer but gives you a chance to catch mistakes.

If you choose Send Email Messages, Outlook sends all the merged emails when ready. A dialog box appears asking you to confirm the number of messages. Double-check that the number matches your list, then click OK. The emails are sent to the addresses in your "Email Address" column.

After the merge completes, close the wizard. Your original template email remains in your Drafts folder unsent — you can delete it or keep it as a template for future merges.

Troubleshoot common problems

If the Mailings tab does not appear in Outlook, you may be using Outlook Web (the browser version) or an older version that does not support mail merge. Mail merge works in Outlook 2016 and newer versions installed on your computer. If you have Outlook Web only, you can still merge by opening Excel, going to the Data tab, and using Text to Columns to prepare your list, then copying the data into a Gmail or other email service that supports mail merge.

If Outlook cannot find your Excel file, make sure the file is saved and closed before you start the merge. Outlook cannot read a file that is currently open in Excel. If the merged emails show field codes like [First Name] instead of actual names, the field name in your template does not match the column header in Excel exactly. Check spelling and spacing, then try the merge again.

If some rows of data are missing from the merge, check your Excel file for blank rows or extra spaces in the column headers. Delete any blank rows and re-save the file. If emails go to the wrong addresses, verify that your "Email Address" column header is spelled correctly and that every row has a valid email in that column.

Frequently Asked Questions

Can I merge to Gmail or other email services instead of Outlook?

Gmail does not have a native mail merge feature, but you can use third-party tools like Google Sheets with add-ons such as Mail Merge for Gmail. These work similarly to Outlook: you prepare data in a spreadsheet, create a template, and the tool sends personalized emails. Some are free, others charge a small fee per month.

What if I want to send the merged emails later instead of right now?

Choose Edit Individual Messages instead of Send Email Messages. Outlook creates all the emails in a new window. You can then close that window without sending, and the emails stay in your Drafts folder. Open Drafts later and send them whenever you are ready. This also lets you review each email before it goes out.

Can I merge data from a Google Sheet instead of an Excel file?

Not directly through Outlook. You must read the Google Sheet as an Excel file (.xlsx) first. Open Google Sheets, click File, then read, and choose Microsoft Excel. Save the file to your computer, then use that file for your mail merge in Outlook.

What happens if I accidentally send a merge email to the wrong person?

Once an email is sent, you cannot unsend it in most cases. Before you run the merge, always preview several emails in the wizard to catch mistakes. If you do send to the wrong list, you can send a follow-up email explaining the error, but you cannot retrieve the original message.

Do I need to set up mail merge every time, or can I save the template?

You can save your template email in Outlook as a draft or in a template folder for reuse. However, you must run the mail merge wizard again each time you want to send merged emails, because the wizard connects your template to a specific Excel file. If you use the same list of people repeatedly, keep both the template email and the Excel file in an straightforward-to-find location.