Mail merge in Excel works by connecting your spreadsheet data to an email template, then generating individual messages for each row

Excel itself does not send emails directly. Instead, you create a list of names, email addresses, and other details in your spreadsheet, then use Word's mail merge feature to pull that data into a template and generate personalized messages. Word is the tool that actually sends them. If you only have Excel and Outlook, you can set up the merge in Word using your Excel file as the data source, and Outlook will handle the sending.

The process has three parts: prepare your Excel data with headers in the first row, create a template letter or email in Word, and then connect them through Word's mail merge wizard. Once connected, Word generates one message per row in your spreadsheet, filling in the personalized details automatically.

Key Takeaways

  • Your Excel file must have headers in the first row (Name, Email, Company, etc.) and one person per row, with no blank rows in the middle.
  • Mail merge happens in Word, not Excel — Word reads your Excel data and creates individual messages from a template you write there.
  • You connect them through Word's Mailings tab by selecting "Start Mail Merge" and then "Select Recipients" from your Excel file.
  • Word inserts merge fields (like <> and <>) into your template, then generates one complete message for each row when you finish the merge.

Prepare your Excel spreadsheet with the right structure

Open Excel and create a new spreadsheet or use an existing one. In the first row, type the headers for the data you want to use: Name, Email, Company, Product, or whatever fields your message will need. Each header becomes a merge field that Word can insert into your template.

Starting in row 2, enter one person per row. Fill in all the columns for each person — if someone is missing an email address or company name, leave that cell blank rather than skipping the row. Blank cells in the middle of your data will break the merge. Save the file with a clear name (like "Email_List.xlsx") in a location you can find easily, because you will need to browse to it from Word.

Create your email template in Word

Open a new Word document. Write the body of the email as you want it to appear, including a greeting, message, and closing. This is where you will add the merge fields that pull information from your Excel columns.

Type the email as if you are writing to one person, but leave blanks where the personalized information should go. For example: "Dear [NAME], thank you for your interest in [PRODUCT]." You will replace those brackets with actual merge fields in the next step. Do not worry about the subject line yet — you will handle that differently depending on whether you are using Word's mail merge or a third-party tool.

Connect your Excel file to Word through the Mailings tab

In Word, click the Mailings tab at the top of the ribbon. Click Start Mail Merge, then select Email Messages from the dropdown (not "Letters" — that option is for printing). This tells Word you are creating emails, not printed letters.

Next, click Select Recipients and choose Use an Existing List. Browse to your Excel file and open it. Word will ask which sheet to use (usually "Sheet1") and whether the first row contains headers — say yes. Your spreadsheet is now connected to Word.

Insert merge fields into your template

Click in your Word document where you want the first personalized detail to appear. Click Insert Merge Field (in the Mailings tab) and select the column name from your Excel file — for example, "Name" or "Email". Word inserts it as <> or <>. Repeat this for each piece of information you want to pull from your spreadsheet.

Your template might look like this: "Dear <>, we have a special offer on <> just for you. Reply to this email or call us at 555-0100." When the merge runs, Word replaces <> with the actual name from each row, <> with the actual product, and so on.

Preview and finish the merge

Click Preview Results in the Mailings tab to see what the first email will look like with real data filled in. Use the arrow buttons to scroll through a few rows and make sure the data is correct and the template reads naturally. If something looks wrong, click Preview Results again to turn it off, fix the template or your Excel data, and preview again.

When everything looks right, click Finish & Merge, then Send Email Messages. Word will ask which column contains the email addresses — select "Email" or whatever you named that column. You can also set a subject line here. Word then creates one email per row and sends them through your default email program (usually Outlook).

Troubleshooting common problems

If Word cannot find your Excel file, make sure it is saved and closed before you start the merge. Word needs the file to be closed to read it properly. If the merge fields show as <> instead of the actual names, you may have clicked Preview Results but not turned it back off — click the button again to toggle it on.

If some rows are skipped or the data looks scrambled, check your Excel file for blank rows in the middle or extra spaces in the header row. Mail merge is sensitive to these issues. If Outlook does not open to send the emails, check that Outlook is set as your default email program in Windows Settings (search "Default apps" and look for email).

Frequently Asked Questions

Can I use Gmail instead of Outlook to send the merged emails?

Word's mail merge sends through your default email program, which is usually Outlook. If you use Gmail, you can set it as your default email client in Windows, but this is not straightforward. A simpler option is to export the merged emails as individual files and send them manually, or use a third-party mail merge tool that connects directly to Gmail.

What if I want to include an attachment in every email?

Word's mail merge does not attach files automatically. You can add a note in the template saying "See attached" and then manually attach the same file to each email after the merge, or use a third-party tool like Mailchimp or a Gmail extension that handles attachments in mail merge.

Can I merge to different templates based on what's in my spreadsheet?

Standard Word mail merge treats all rows the same way — they all use the same template. If you need different messages for different people (for example, different products get different emails), you would need to run separate merges for each group, or use a more advanced tool like a mail merge add-in or a dedicated email marketing platform.

How do I test the merge before sending to everyone?

Use the Preview Results button to check a few rows. When you are ready to send, you can also click Finish & Merge and choose "Edit Individual Documents" instead of "Send Email Messages" — this creates a new document with all the merged emails so you can review them before sending anything.

What happens if someone's email address is blank in my Excel file?

Word will skip that row when you send, because there is no address to send to. Before you merge, scan your Excel file and remove any rows with missing email addresses, or fill them in if you have the information.