How to Mail Merge in Word for Personalized Email Messages

To mail merge in Word for email, prepare a recipient list in Excel, connect it to a Word email message, insert fields such as each person’s name, preview the results, then choose Mailings > Finish & Merge > Send E-Mail Messages. On Windows, Word sends the messages through a configured desktop Outlook account, so make a test run before sending to your full list.

A mail merge creates a separate, personalized email for each row in your recipient list. It is useful for announcements, invitations, reminders, and other messages that share the same main text but need individual details. It does not create one email with everyone visible in the To line. The steps below are for Microsoft 365 Word on Windows and desktop Outlook; Word for the web does not provide the complete email-merge workflow.

What You’ll Need

Microsoft Word desktop: You need the desktop app, not Word for the web, to complete the merge and send the emails.
A recipient list: An Excel workbook is a practical choice. Include a column for each detail you may personalize, such as FirstName, LastName, and EmailAddress. Use one recipient per row and clear column headers in the first row.
Desktop Outlook configured to send mail: On Windows, Word’s email merge relies on Outlook or another compatible desktop mail program. For the most predictable Microsoft 365 setup, use classic Outlook for Windows with the sending account already added. New Outlook and Outlook on the web do not provide the same Word desktop merge connection.
A tested message and permission to contact recipients: Check the content, recipient addresses, and any applicable organizational or privacy requirements before sending.

Step-by-Step

Prepare and check your recipient list. In Excel, put field names in the first row, such as FirstName, EmailAddress, and AppointmentDate. Put each person’s information on one row below the headings. Remove completely blank rows within the list, correct misspelled addresses, and make sure there is only one email address in each recipient’s email cell. Save the workbook as an .xlsx file. If you have several sheets, note which one contains the list; Word will ask you to choose it. Close the workbook before connecting it to Word if you can, which avoids some file-access or refresh problems.
Start an email merge in Word. Open Word desktop and create a new document. Go to Mailings > Start Mail Merge > E-mail Messages. This sets the document up as the body of an email rather than a printed letter or a set of labels. Type the shared parts of your message, such as the greeting, main information, and sign-off. You can draft the message before or after linking the list.
Connect the Excel list. Select Mailings > Select Recipients > Use an Existing List. Browse to your saved workbook and select it. In the dialog box, choose the worksheet that contains the recipient list. If the first row contains your column names, confirm that Word recognizes the first row as headers. If prompted to select a table or named range, choose the one that includes the header row and all recipient records. If the wrong sheet or range is selected, the merge fields may be missing or the recipient list may be incomplete.
Choose who should receive the message. Select Mailings > Edit Recipient List to review the connected names and addresses. Untick a row to exclude that person from this send. Use the available sorting or filtering options if you need to target a subset, for example, recipients in one region. Check that the selected records match your intended audience; an accidental filter can omit people or include the wrong group.
Write the personalized message and insert fields. Click where a personalized value should appear, then choose Mailings > Insert Merge Field and select the relevant column. For example, write “Hello ”, insert the FirstName field, and type a comma after it. A greeting might appear in the document as “Hello «FirstName»,”. Insert other fields only where they belong, and type punctuation or spaces around them as needed. Do not type the angle brackets yourself; use Insert Merge Field so Word links the placeholder to the spreadsheet column. Keep the message readable if a field is empty, or clean up missing data before sending.
Preview individual records. Select Mailings > Preview Results. Word replaces the merge-field placeholders with actual values from the list. Use the previous and next record arrows on the Mailings tab to check several recipients, including the first and last records and anyone with an unusual name or date. Confirm that spacing, punctuation, line breaks, and any personalized details look right. Turn Preview Results off and on if you need to edit the underlying message or inspect the field names again.
Run a small test before the full send. The safest approach is to use a separate test workbook containing only your own email address, then preview and send that single record. Check the received email on a computer and, if relevant, a phone. Confirm that the subject, formatting, links, greeting, and sender account are correct. A test sent from the real recipient list can reach someone unintentionally, so do not rely on sending a full merge and hoping to recall it.
Send the email merge. When the message and recipient selection are ready, choose Mailings > Finish & Merge > Send E-Mail Messages. In the dialog, select the spreadsheet column containing email addresses in the To box. Enter a subject line, choose HTML as the mail format if you want basic formatting and links preserved, and select whether to send all records or a specified range. Verify the details, then click OK to start sending. Word hands the messages to the configured mail program; depending on your Outlook setup, you may see messages in the Outbox while they are being processed. Keep Outlook open and online until sending has completed.

Each recipient gets an individually addressed message, but the standard Word email merge does not attach a separate file to each message or let you set individual CC and BCC fields in the send dialog. If you need attachments or advanced recipient-specific rules, use an approved mailing platform or a carefully designed alternative rather than assuming the merge will handle them.

Common Mistakes

Using the wrong email column: The To box must point to the column with addresses, not names or another contact detail. Confirm the field header and check several values before sending.
Leaving placeholder text or field names in the message: Preview Results should show real recipient data. If you still see «FirstName» in the preview, check that the field was inserted from the connected list and that the correct worksheet was selected.
Forgetting spaces and punctuation: Word places a field exactly where the cursor is. Type any space before or after the field yourself, then preview examples such as short names and names with hyphens.
Assuming a merge is a single group email: Word prepares individual messages, but a large send can still trigger organizational limits or spam controls. Follow your email provider’s sending limits and use a suitable bulk-email service for large campaigns.
Sending before checking the subject and range: A blank or incorrect subject looks unprofessional, while selecting all records instead of a small test range may send to the whole list. Read the Send E-Mail Messages dialog carefully before clicking OK.
Expecting attachments or a later undo: Standard email merge does not add per-recipient attachments, and sent messages cannot reliably be recalled. Verify the recipient list and content before sending.

Tips

Use clear, simple column headings. Names such as FirstName and EmailAddress make it easier to recognize fields in Word. Avoid duplicate or blank headers.
Keep the email body focused. Use a short opening, a clear purpose, and one obvious next step. Long, heavily formatted documents may not display consistently across email apps.
Check data formats in the preview. Dates, phone numbers, and values with leading zeroes can display differently from how they appear in Excel. Format the source data appropriately and inspect the merged result, rather than assuming the spreadsheet’s display will carry over exactly.
Make a separate test list. A copy of the workbook with only your own address lets you check the finished message without risking a send to customers or colleagues.
Send in a manageable batch. For a large list, ask your organization’s IT or email administrator about sending limits, throttling, and approved tools. A Word merge is intended for straightforward sends, not necessarily high-volume marketing.
Keep a record of what you sent. Save the final Word document and a copy of the recipient list used, following your organization’s rules for handling personal data. Remove or protect information that you no longer need.

Troubleshooting

Send E-Mail Messages is unavailable: Confirm that the document was started as an E-mail Messages merge and that you are using desktop Word. On Windows, check that classic Outlook is installed and configured with an account. Word for the web cannot complete this desktop workflow. New Outlook may not provide the required integration; if the command remains unavailable, use a supported desktop Outlook setup or an approved sending tool.
The Excel headers or recipients do not appear: Reconnect through Mailings > Select Recipients > Use an Existing List. Select the correct workbook and worksheet, and make sure the header row is included and the list has no blank header cells. If you changed the workbook after connecting it, reconnect or refresh the recipient source.
Messages do not send or remain in the Outbox: Open Outlook and check that the correct account is signed in, connected, and able to send a regular test email. Look for an offline status, an authentication prompt, a full mailbox, or an organization sending limit. Keep Outlook open while the merge is processed. If messages are queued, avoid running the merge again until you know whether the first batch has been sent, or recipients could receive duplicates.
Recipients receive a blank message or see merge codes: Return to Word and confirm that the message body contains your text and correctly inserted fields. Preview several records. In the send dialog, choose HTML for formatted content, then send a new test to yourself.
Formatting or dates look wrong: Simplify the formatting and inspect the source values. For dates or other values that Word displays unexpectedly, test a few records and consider preparing a separate, clearly formatted text column in Excel for use in the email. Preview that field before sending the whole list.
Some recipients are missing or duplicated: Review Mailings > Edit Recipient List for filters and unticked rows. Then inspect the Excel source for duplicate addresses, blank rows, or multiple entries for one person. Correct the list and reconnect it before another send.

Frequently Asked Questions

Can I mail merge emails in Word without Outlook?

On Windows, Word’s built-in email merge normally sends through Outlook or a compatible desktop email program. If you do not have a supported program configured, the Send E-Mail Messages command may be unavailable or fail to hand off the messages. Outlook on the web alone is not a substitute for the desktop connection.

Can I use Word for the web to send a mail merge?

No. Word for the web can open and edit documents, but it does not provide the full desktop mail-merge sending workflow. Use desktop Word with a supported mail program for this process.

Will each recipient see the other email addresses?

No. The merge creates a separate message addressed to each selected recipient; it is not a shared To or CC list. Still, check the To field mapping and do a test send to confirm the result.

Can I add an attachment to every merged email?

The standard Word Send E-Mail Messages dialog does not include an attachment option. For individualized or repeated attachments, use a suitable approved email service or another workflow designed to handle attachments.

Can I send only selected people from my spreadsheet?

Yes. Open Mailings > Edit Recipient List and untick recipients you want to exclude, or use the recipient-list filtering options. Preview the remaining records and check the send range before starting the merge.

Can I cancel or recall a mail merge after clicking OK?

Do not count on recall. Once messages have been handed to Outlook or delivered, stopping or recalling them may not work. If you notice an error, check the Outbox immediately and contact your email administrator if necessary, but always test and verify the list before sending.

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.