Mail Merge in Word, Excel & Outlook: A Step-by-Step Guide

To mail merge in Word with an Excel list and Outlook, prepare a spreadsheet with one recipient per row, connect it in Word through Mailings > Select Recipients, add merge fields to your message, then choose Finish & Merge > Send E-mail Messages. You will need desktop Word and a configured classic Outlook account for email merging; check the result with a small test before sending to everyone.

What You’ll Need

Microsoft Word and Excel for Microsoft 365 on Windows, or compatible desktop versions.
Classic Outlook for Windows with an email account set up and available to send messages. New Outlook may not support Word’s email-merge connection; switch to classic Outlook if the merge command cannot send.
An Excel workbook containing recipient details, saved in a location you can access.
A message or letter to personalize, plus permission to contact the recipients and an accurate list of their email addresses.

Step-by-Step

Build a clean recipient list in Excel. Put field names in the first row, such as FirstName, LastName, EmailAddress, Company, and AppointmentDate. Use one recipient per row, with no completely blank rows or columns inside the list. Give each column a unique, simple heading; avoid merged cells, totals rows, and multi-row headings. For an email merge, every person who should receive a message needs a valid address in the email column. Save the workbook as an .xlsx file and close it before connecting it in Word. Keeping it closed helps avoid file-locking or update prompts.
Check the data before using it. Scan for misspelled addresses, duplicate records, missing names, and unintended recipients. If a field is blank for some people, decide whether your message will still read naturally without it. Format dates and numbers in Excel so the values are clear, but remember that Word may not display Excel’s formatting exactly as it appears in the worksheet. If you need to exclude a group, filter or remove those rows before the merge, or use Word’s recipient filtering later. Keep a separate copy of the original list before making large changes.
Start an email merge in Word. Open a new document in Word, select the Mailings tab, choose Start Mail Merge, and select E-mail Messages. This sets up the document as the body of an email rather than a printed letter. Write the shared parts of the message, such as the greeting, explanation, and sign-off. Use ordinary text and formatting that will work in email; avoid relying on complex page layouts, headers, footers, or print-only elements.
Connect the Excel workbook. On the Mailings tab, select Select Recipients > Use an Existing List. Browse to your saved workbook and open it. If Word asks you to choose a table or sheet, select the worksheet containing the list and confirm that the first row contains column headers. The list should then be available to the document. If you do not see the expected fields, cancel and check the workbook’s header row, sheet selection, and whether the workbook is saved and closed.
Choose and filter recipients, if needed. Select Mailings > Edit Recipient List to review the records Word will use. Clear the checkbox beside any row that should not receive the message. Use the sort or filter controls in the recipient list to narrow recipients by a field such as city, category, or status. Do not assume a filter in Excel automatically excludes records if you later change or reconnect the source; verify the recipient list in Word before sending.
Insert personalization fields. Click where a personalized value should appear, then choose Mailings > Insert Merge Field and select a field, such as FirstName. For example, you could write Hello, followed by the FirstName field and a comma, then continue with the shared message. Insert fields for other details only where they make the message more useful. The field names are placeholders: during preview and sending, Word substitutes the value from the matching row in Excel. Type punctuation and spaces around fields as needed.
Preview several records. Select Mailings > Preview Results. Use the next and previous record arrows to inspect different recipients, including at least one record with missing or unusual data. Check that names appear in the right places, punctuation is correct, and the text still makes sense for each person. If a field appears as a field name rather than a value, make sure Preview Results is turned on and that the recipient list is connected.
Send a test before the full merge. For a safe check, select a small set of records in Edit Recipient List and temporarily leave only your own address or a colleague’s consenting test address selected. Preview the message and send that limited merge. Check the received email’s subject, formatting, links, and any personalized details. A mail merge can send individual messages as soon as you confirm the send command; it is not simply a preview or a batch of drafts. Restore the intended recipient selection after testing.
Send the email merge. When the test is correct, select Mailings > Finish & Merge > Send E-mail Messages. In the dialog, choose the Excel field that contains email addresses in the To box, enter a subject line, and select the desired mail format. HTML is generally suitable for a message with basic formatting; Plain text removes formatting. Choose whether to send all records, the current record, or a range, then select OK to send. Use a small range first if you have not already tested the setup.
Confirm delivery and keep a record. Outlook sends the messages through the account configured for the merge. Check Outlook’s Sent Items and any delivery or error notifications, and confirm with a test recipient that the message arrived as intended. Save the Word document and the final Excel list in a secure location if you need a record of the merge. Avoid keeping unnecessary copies of personal data, and follow your organization’s retention and privacy rules.

Mac note: Word for Mac has Mailings tools for creating and previewing merges, but the exact ribbon labels and email integration can differ by Word and Outlook version. For email merges, make sure Outlook is configured and available as the mail application, and test one message first. If the email-send option is missing or does not work, use a supported desktop configuration or ask your organization’s Microsoft 365 administrator; the steps above describe Microsoft 365 on Windows.

Common Mistakes

Using the wrong email column. Selecting a name or company field in the To box can prevent delivery. Check that the chosen field contains addresses, and preview several records.
Leaving unintended people selected. Word may include every record in the connected list. Review Edit Recipient List and confirm the record count and selections before sending.
Expecting Excel formatting to carry over. Dates, currency, and leading zeros may appear differently in Word. Preview those fields carefully and adjust the source data or the message before sending.
Using a blank or ambiguous heading. Word relies on the first row for merge field names. Replace generic headings such as Column1 with clear, unique labels, then reconnect the workbook if necessary.
Sending without a test. A typo in a field, subject, or recipient selection can be repeated across the whole list. Send to a test address and inspect the actual email first.
Assuming the merge creates drafts. The Send E-mail Messages command sends messages through Outlook after confirmation. Do not use the full recipient list as a way to review the message later.

Tips

Use headings without punctuation or extra spaces, such as EmailAddress and FirstName, to make fields easy to identify.
Keep the message concise and avoid putting sensitive personal details in the subject line, where they may be visible in notifications.
Use a clear subject that recipients can recognize. If the subject is the same for everyone, enter it in the Send E-mail Messages dialog rather than adding it as a spreadsheet field.
For a message that needs a name in the greeting, include a fallback phrase in your workflow for records with no first name. Word does not automatically invent a polite greeting when a merge field is blank, so fix or exclude those records.
For large lists, send in manageable groups and check the organization’s sending limits and anti-spam policies first. A mail merge does not bypass restrictions imposed by Microsoft 365 or your email provider.
Keep the data source simple. If the workbook changes after you connect it, review the recipients and preview again before sending; do not assume the document is still using the version you expect.

Troubleshooting

The Excel fields do not appear in Word: Confirm that you chose the correct worksheet, that the workbook has a header row, and that it is saved as an Excel workbook. Close the file, then reconnect through Mailings > Select Recipients > Use an Existing List. If the first row contains blank or duplicate headings, correct them and reconnect.

Word cannot connect to the workbook: Close Excel and Word, make sure the file is stored somewhere you can access, and try selecting it again. If prompted for a sheet or table, choose the one that contains the data. A protected, moved, or renamed file can break an existing connection; reconnect to its current location.

The send option is unavailable or Outlook does not open: Make sure you are using desktop Word and a configured classic Outlook profile, and that Outlook can send a regular test message. New Outlook may not provide the integration required by Word’s email merge. If you use a work or school device, an administrator may control the default mail application or restrict the feature.

Messages go to the wrong people or do not arrive: Stop before sending more. Check the selected To field, the recipient checkboxes, and the email values in Excel. Send one test to an address you can access. Then check Outlook’s Sent Items, junk folders, delivery notifications, and any organizational sending limits. Correct the source or selection and run a new small test before resuming.

A name, date, or number looks wrong: Compare the preview with the Excel row. Correct the source value or change its presentation in the message. For dates and numbers, Word may use its own display rather than Excel’s visible cell format, so do not rely on appearance in the worksheet alone. Re-preview multiple records after making a change.

Frequently Asked Questions

Can I use Excel as the source and Outlook to send the merge?
Yes. Word connects to the Excel workbook as its recipient list and uses Outlook to send a separate email to each selected recipient. You create and run the merge from Word.

Does each person see the other recipients?
No. A standard Word email merge creates an individual message for each selected record, rather than placing the whole list in To or Cc. Still, check that the To field is mapped to the correct email-address column.

Can I mail merge to a printed letter instead of an email?
Yes. In Word, choose Mailings > Start Mail Merge and select Letters instead of E-mail Messages. Connect the same Excel list, insert fields, preview, and use Finish & Merge to complete or print the letters.

Can I use the new Outlook app?
Word’s email merge depends on desktop mail integration, and new Outlook may not support that connection. Use classic Outlook for Windows when the send command is unavailable, and test your setup before relying on it.

Can I send attachments with a Word mail merge?
Word’s standard Send E-mail Messages workflow does not provide a per-recipient attachment option. Do not assume a file attached to one Outlook message will be included in the merge. For individualized attachments, use an approved tool or workflow designed for that purpose.

Can I send a merge from Word for the web?
The instructions here use desktop Word. Word for the web does not offer the same complete mail-merge workflow, so open the document in the desktop app to connect the recipient list and run the merge.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.