Mail Merge in Word and Outlook: A Step-by-Step Guide

To mail merge in Word and Outlook, prepare a contact list in Excel, create an email in Word, connect the list, add merge fields, preview the messages, then choose Mailings > Finish & Merge > Send Email Messages. Use classic Outlook for Windows, configured with the account you want to send from; Word creates a separate personalized email for each recipient.

What You’ll Need

Word desktop for Microsoft 365 on Windows, with the Mailings tab available.
Classic Outlook for Windows installed and set up with the sending account. Word’s email merge relies on a desktop mail connection; Outlook on the web alone is not enough. New Outlook may not provide the MAPI support Word needs, so switch to classic Outlook if the send option fails.
A recipient list, preferably an Excel workbook saved locally or somewhere you can access. Include an email-address column and any information you want to personalize, such as first name or organization.
A short message and a small test list. Use an address you control for the test before sending to real recipients.

Step-by-Step

Prepare the recipient list. In Excel, place one person per row and put a unique column heading in the first row, such as EmailAddress, FirstName, and Company. Avoid merged cells, completely blank rows within the data, duplicate headings, and extra notes above the headings. Keep each value in the right column. If a postal code or other value begins with zero, format that column as Text before entering or importing the values so Excel does not remove the zero. Save and close the workbook before connecting it to Word.
Write and save the email in Word. Open Word desktop and create a new document. Draft the message as you would like it to appear in an email, including a greeting and sign-off. Save it with a clear filename. Keep the layout simple: plain paragraphs and familiar fonts are more reliable in email than complex tables, text boxes, or elaborate page designs.
Start an email merge. In Word for Windows, select the Mailings tab, then choose Start Mail Merge > E-mail Messages. This tells Word that the finished documents should be sent as email, rather than printed letters or envelopes. If you do not see the Mailings tab, confirm that you are using the desktop version of Word rather than Word for the web.
Connect your recipient list. On the Mailings tab, choose Select Recipients > Use an Existing List. Browse to the Excel workbook and open it. In the Select Table dialog, choose the worksheet or named range containing your list. Check that the option indicating the first row contains column headers is selected, if shown, and confirm. Word now uses the rows in that sheet as its recipient records.
Check who will receive the message. Select Edit Recipient List on the Mailings tab. Review the names and addresses, and use the checkboxes to exclude anyone who should not receive this particular email. You can sort or filter the list when needed, for example to send only to one department. Take care with filters: Word sends to the records that remain selected, not necessarily every row in the workbook. Close the recipient list when the selection is correct.
Add personalized fields. Click where a personal detail should appear in the message. Choose Insert Merge Field on the Mailings tab, then select the matching heading, such as FirstName or Company. For example, you might write Hello, insert the FirstName field, and add a comma after it. Insert fields only where you want information to vary; leave the rest of the message as normal text. Use the exact field name from the Excel header list.
Preview several records. Choose Preview Results on the Mailings tab. Use the next and previous record arrows to inspect more than the first recipient. Check that names appear in the intended places, punctuation and spacing look natural, and no field appears blank or as a raw field name. Previewing also helps spot a bad row, such as a missing first name or an incorrectly imported email address. Correct the source workbook or revise the message before moving on.
Send a controlled test. Before sending to the full list, use a small test list with your own address and, if useful, a colleague who has agreed to review it. You can make a copy of the workbook containing only those test rows and connect Word to that copy. Complete the merge using the send settings in the next step, then inspect the received email on desktop and mobile. Confirm the greeting, links, formatting, and subject are right. A preview is not a substitute for receiving a test message.
Set the email options and send. On the Mailings tab, choose Finish & Merge > Send Email Messages. In the dialog, select the email-address column in the To box, enter a subject line, and choose a mail format. HTML is usually appropriate for a message with basic formatting; Plain text removes formatting. Under Send records, choose all records or a specific range as appropriate. Verify the recipient count and settings, then confirm. Word hands the messages to Outlook for sending, producing individual emails rather than one message with all recipients visible.
Check the result in Outlook. Look in Outlook’s Outbox and Sent Items and confirm that the test or final messages have been processed. If a message remains in the Outbox, Outlook may be offline or unable to connect. Do not immediately run the merge again: first check Sent Items and the Outbox to avoid sending duplicates. If the merge did not send, address the connection or account issue, then test again with a single record.

Word’s merge sends one personalized message per selected record. It does not give you a normal compose window for individually editing every email, so treat the test step and recipient review as essential. For a large or time-sensitive mailing, send in manageable batches and check Outlook’s sending limits and your organization’s policies before starting.

Common Mistakes

Using the wrong Outlook version. Word email merge works most reliably with classic Outlook for Windows. New Outlook and Outlook on the web may not work as the desktop mail connection for this feature. Check which Outlook you have open before building the message.
Choosing the wrong To field. The To box in the send dialog must point to the column containing email addresses, not a name or company column. If addresses are stored under a different heading, select that heading.
Sending to the full list too soon. Selecting all records can send to every included address immediately. Preview the list, test with a copy containing a few recipients, and confirm the record selection before the final send.
Using inconsistent or blank data. A blank FirstName field can produce a greeting such as Hello, with no name. Inconsistent headers or a blank row may also make Word interpret the source differently than expected. Clean the list before connecting it.
Assuming formatting will match Word exactly. Email clients can display fonts, spacing, and links differently. Avoid relying on page layout features, and check a received test email in the clients your audience is likely to use.
Repeating the merge after a delay. Messages can take time to leave the Outbox, especially when there are many recipients. Check Sent Items and the Outbox before trying again; otherwise, recipients may get duplicate messages.

Tips

Use clear, short Excel headings without duplicate names. Headings such as EmailAddress and FirstName are easier to identify than generic names such as Column1.
Keep the workbook and Word document in a stable location while you work. If you rename or move the Excel file after connecting it, Word may lose its data source and ask you to locate it again.
Make the message understandable even when a personal field is missing. If some contacts do not have first names, either fill those values, exclude those records, or use a greeting that does not depend on the field.
Use a clear subject line that describes the email accurately. The subject is shared across the merge; standard mail merge does not create a different subject for each row through the Send Email Messages dialog.
Remember that a mail merge does not automatically attach a file. If you need to send individualized attachments, use an approved method designed for that purpose rather than assuming Word will attach the document being merged.
Keep a dated copy of the source list and the final message. This makes it easier to identify which records were included if a recipient asks about the mailing later.

Troubleshooting

Send Email Messages is unavailable or nothing happens: Confirm that the document was started as Mailings > Start Mail Merge > E-mail Messages, and that classic Outlook for Windows is installed, configured, and open with a working account. New Outlook may not support the desktop connection Word needs. If your organization manages Outlook, ask its support team whether desktop mail merge is allowed.

Word cannot find the Excel workbook or worksheet: Close the workbook in Excel, return to Word, and use Mailings > Select Recipients > Use an Existing List to reconnect it. Select the worksheet that contains the headers and records. If the workbook has several sheets, verify that you chose the right one. Save changes in Excel before reconnecting.

Merge fields are blank or show unexpected values: Check that the column has a header in the first row, that the correct worksheet is selected, and that the relevant cells contain values. In Word, reinsert the field using Insert Merge Field rather than typing a field name as ordinary text. Review several records, not just the first.

Dates, numbers, or leading zeros look wrong: Excel may store or display a value differently from how you expect Word to import it. Make sure the source cells contain the intended values and formats, then reconnect the list and preview the merge. For identifiers such as postal codes, account codes, or membership numbers, store them as text in Excel so zeros are retained.

Messages do not appear in Sent Items: Check whether Outlook is offline, whether the correct account is configured, and whether messages are waiting in the Outbox. Send a normal test email from Outlook to confirm the account can send. If Word reports an error, resolve it before restarting the merge, and check for messages that may already have been sent.

The message looks different after delivery: Simplify the Word layout, select HTML as the mail format if you need basic styling, and send another test. Avoid complex page elements and inspect hyperlinks and line breaks in the received message. If the email must look identical across recipients, use a format or mailing system specifically suited to that requirement.

Frequently Asked Questions

Can I use Outlook on the web for a Word mail merge?
Not as the desktop email program Word hands the merged messages to. Use a supported desktop Outlook setup, preferably classic Outlook for Windows, with the account configured there. Outlook on the web can still be used to check the mailbox afterward.

Does each person see the other recipients?
No. Word creates separate messages and puts each selected address in the To field for that individual message. It does not send one group email that exposes the full address list.

Can I personalize the subject line for each recipient?
The standard Send Email Messages dialog uses one subject line for the merge. It does not insert a different Excel field into the subject for every record. Keep the subject consistent or use a specialized mailing tool if per-recipient subjects are essential.

Can I include an attachment in every merged email?
The standard Word email merge does not attach a file from the document or a file path in each row. Send the attachment separately or use an approved mail-merge solution that explicitly supports attachments, taking care to protect recipient data.

Can I do the same process on a Mac?
Word for Mac has mail merge tools, but the connection to email depends on the installed mail app and setup, and the Windows classic Outlook workflow may not translate exactly. Look for the equivalent Mailings and Finish & Merge controls in desktop Word for Mac, use a configured desktop mail app, and send a test first. Word for the web and Outlook on the web do not provide the same desktop merge handoff.

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.