Mail Merge in Word: A Step-by-Step Guide for Letters

To mail merge in Word, prepare a recipient list, connect it to a Word document, insert fields such as names or addresses, preview the records, then choose Mailings > Finish & Merge. This combines one document template with many records to create personalized letters, envelopes, labels, or email messages. Before starting, make sure your list is organized and decide which type of document you want to produce.

What You’ll Need

Microsoft Word for Microsoft 365 on Windows. The Mailings commands are similar in Word for Mac, although some dialogs and options may look different.
A recipient list saved as an Excel workbook or a comma-separated values (CSV) file. A simple Word table or a list you create during the merge can also work.
A document template, or a blank document where you will create the letter, labels, or other output.
For an email merge, an email address column for every recipient and an email account configured with a compatible desktop mail app. Word sends a separate message to each address; standard mail merge does not add individual attachments.

Step-by-Step

Prepare and save your recipient list. In Excel, use one row for each person or organization and one column for each kind of information you may insert. For example, headings might include FirstName, LastName, Address, City, State, PostalCode, and Email. Put the headings in the first row, keep each field in its own column, and avoid blank rows within the list. Check for misspellings and duplicate entries. Format postal codes, account numbers, and other values with leading zeros as text if those zeros must appear in the finished document. Save the workbook, preferably as an .xlsx file, and close it before connecting Word to it.
Open or create the main document. Open the letter you want to personalize, or choose a blank document and write the general text first. Leave clear spaces where variable details should appear. For example, start with a greeting such as Dear followed by a space, then insert the recipient’s first name as a merge field in a later step. Keep information that is the same for everyone, such as your organization’s return address or the body of a general announcement, in the document itself.
Choose the merge type. On the Windows ribbon, select Mailings > Start Mail Merge, then choose Letters, E-mail Messages, Envelopes, Labels, or Directory. Letters is the usual choice for personalized correspondence. For labels, select Labels and choose the label vendor and product number in the dialog before continuing. For envelopes, choose the envelope size and set the address and return-address positions. The available choices can vary slightly by Word version.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List, browse to the saved workbook or CSV file, and select it. If Word asks which table or sheet to use, choose the sheet containing the list and confirm that the first row contains column headers. Use the data range that includes the headings and all recipient rows. Alternatively, use Select Recipients > Type a New List to enter a small list directly, or choose Edit Recipient List later to review or filter the connected records.
Insert the variable fields. Click where a detail should appear, then select Mailings > Insert Merge Field and choose the matching column heading. Add fields individually for a greeting, body text, or address block. For a standard postal address, Mailings > Address Block can assemble several address fields; use Match Fields if Word does not recognize the column names. For a greeting, choose Greeting Line or insert a field such as FirstName yourself. Add punctuation and spaces around fields in the document so the finished text reads naturally.
Set up labels or other repeated layouts, if applicable. With a label merge, arrange the first label using merge fields and any fixed text. Then select Mailings > Update Labels to copy that layout to the remaining label positions and add the required next-record instructions. Check that the first label is correct before updating. For a directory merge, format the repeating record layout in the document. Letters and emails generally use one main document layout without this label-copying step.
Preview the records. Select Mailings > Preview Results. Use the left and right record arrows beside the preview controls to check several recipients, including the first and last records. Look for missing names, extra spaces, broken address lines, unexpected punctuation, and values that do not display as intended. If a field is wrong, turn off Preview Results, correct the field or source data, and preview again. Use Edit Recipient List to untick records you do not want included or apply a filter.
Finish the merge and check the output. Select Mailings > Finish & Merge. Choose Edit Individual Documents to create a separate merged Word document that you can inspect and edit; select All or a record range as needed. This is often the safest option for letters because it lets you review the complete batch before printing. Choose Print Documents when the merge is ready to print, or Send E-mail Messages for an email merge. Save the merged document if you need a copy for your records.
Send email messages carefully. If you chose E-mail Messages as the merge type, select Finish & Merge > Send E-mail Messages, choose the column containing email addresses in the To box, enter a subject line, and select the desired mail format. Send a small test or preview the message carefully before sending the full list. Word sends messages individually rather than exposing the full recipient list in a shared To line. Depending on your setup, the email option may require a supported desktop mail program configured on the computer; availability and workflow can differ on Mac and in newer Outlook versions.

Common Mistakes

Using unclear or duplicate column headings: Word uses the headings as field names. Give each column a distinct, simple name such as FirstName or PostalCode, and avoid blank heading cells. Putting multiple details in one column: A full name in one cell is harder to format flexibly than separate first- and last-name columns. Leaving blank rows in the list: A blank row can make Word treat the data range as though it ends early or split the records unexpectedly. Forgetting spaces or punctuation: A field placed directly beside another word can produce a joined result such as DearJordan. Add the needed space and punctuation in the template. Printing without a final review: A field can look right in the template but fail for a particular record. Preview multiple records and inspect the merged output before printing a large batch.

Tips

Keep the source list in a dedicated worksheet with one rectangular block of data and no notes or totals directly below it. Use short, consistent headings; you can make them readable without spaces, such as FirstName and StreetAddress. For dates, currency, and postal codes, inspect the preview rather than assuming Word will copy Excel’s display formatting exactly. Where formatting matters, test a few records and adjust the source data or the Word field format before generating the final batch.

Save the original template separately from the merged output so you can reuse it with an updated list. If you need to exclude certain people, use the recipient list controls instead of deleting rows from your only copy of the source workbook. For labels, print one test page on plain paper first and hold it behind a label sheet to confirm alignment. If you are working in Word for Mac, look for the same Mailings tab and command names, but expect dialogs, recipient-source selection, and email options to vary by release. Saving the contact list as a clean CSV can help when Word does not show the workbook or sheet you expect.

Troubleshooting

Word cannot find the workbook or the correct worksheet. Save the Excel file in a location you can browse to, close it, and reconnect it through Mailings > Select Recipients > Use an Existing List. If the sheet does not appear, make sure its first row contains headings and that the data is one continuous table without blank rows or columns interrupting it. If necessary, save a copy as CSV and connect to that file.

Merge fields show as names such as «FirstName» instead of values. This is normal while editing the template. Select Mailings > Preview Results to display recipient data. If preview still shows empty or incorrect values, confirm that the right data source and sheet are selected and that the corresponding source cells are populated.

A field is blank, mismatched, or has the wrong format. Turn off preview and inspect the field through Insert Merge Field. Make sure it is linked to the intended column, then check the source list for empty cells, misspelled headings, or values stored in an unexpected format. For postal codes that lose leading zeros, format the source column as text and reconnect or refresh the list. For dates or numbers that display oddly, adjust the source values and test the preview again.

The merge produces too few records or includes unwanted people. Open Mailings > Edit Recipient List and check the selected data source, record checkboxes, and any filters or sorting. Confirm that the source data range includes every row and that there is no blank row dividing the list. Clear filters if you want the full list.

Labels are repeated incorrectly or do not line up. Confirm the label vendor and product number, then select Update Labels after arranging the first label. Preview several records and print a test page on plain paper using the same printer settings and paper orientation as the label stock. Printer scaling options such as Fit to Page can shift alignment, so use the actual size setting when available.

Email sending fails or messages do not appear. Verify that every intended record has a valid address in the selected email column, that Word is using the correct field in the To box, and that a supported mail app and account are configured. Send a test to yourself first. If the email merge command is unavailable, use Word for Windows with a compatible desktop email setup or check the current support information for your Word and Outlook versions; the available email workflow can differ across platforms.

Frequently Asked Questions

Can I use an Excel spreadsheet as my Word mail merge list?

Yes. Put the field names in the first row, use one row per recipient, and save the workbook. In Word, choose Mailings > Select Recipients > Use an Existing List and select the workbook and the sheet containing the records.

How do I preview each person’s letter?

Select Mailings > Preview Results, then use the record navigation arrows on the Mailings ribbon to move through recipients. Check more than one record, since a missing value in one row may not be obvious from the first preview.

Can Word mail merge create labels?

Yes. Choose Mailings > Start Mail Merge > Labels, select the label vendor and product number, connect your recipient list, arrange the first label with merge fields, and select Update Labels. Print a test sheet before using label stock.

Can I send a separate email to each person?

Yes. Start an E-mail Messages merge, insert any personalized fields, then choose Finish & Merge > Send E-mail Messages and select the email-address column. Word creates individual messages, but the standard merge does not include personalized file attachments.

Can I edit a mail merge after creating it?

You can edit the original template or source list and run the merge again. If you chose Edit Individual Documents, you can also edit the merged copy, but changes in that copy do not update the original template or recipient list.

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.