How to Mail Merge in Word: A Complete Step-by-Step Guide

To mail merge in Word, prepare a recipient list—usually an Excel workbook—then use the Mailings tab to connect it to a letter, label, envelope, or email template. Insert merge fields, preview individual results, and finish by printing, creating a combined document, or sending messages. Before you start, check that your recipient data is complete and saved.

What You’ll Need

Microsoft Word for Microsoft 365 on Windows. The main steps are similar in Word for Mac, although some ribbon labels and email options may differ.
A recipient list. An Excel workbook is a common choice. You can also use another supported data source or create a list from Word.
A document or template. This can be a letter, label layout, envelope, or message. You can start with a blank document.
For email merges: an email address column and a compatible desktop email setup. Word uses an email application to send the messages; it does not send them independently.

Step-by-Step

Prepare and save your recipient list. In Excel, put one recipient on each row and give every column a clear heading in the first row, such as FirstName, LastName, Street, City, PostalCode, and EmailAddress. Avoid merged cells, completely blank rows, and duplicate or empty column headings. Keep each type of information in its own column; for example, separate first and last names if you want to place them independently in the document. Save the workbook as an .xlsx file. For fewer connection issues, close it before selecting it in Word.
Open Word and choose the merge type. Open your document or create a new one. On the Windows ribbon, select Mailings > Start Mail Merge, then choose Letters, E-mail Messages, Envelopes, Labels, or Directory. Choose the type that matches your goal: Letters creates a personalized copy for each recipient, while Labels lays out multiple records on a sheet. For labels, select Mailings > Start Mail Merge > Labels, choose the label vendor and product number, and confirm the label dimensions before proceeding.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List. Browse to your saved workbook, select it, and choose the worksheet or named range containing the recipient data. If prompted, confirm that the first row contains column headers. Word now treats each data row as a recipient. To create a small list directly in Word instead, use Select Recipients > Type a New List and enter the records in the form.
Check which recipients are included. Select Mailings > Edit Recipient List to inspect the names and fields Word found. Clear the checkbox beside anyone who should not receive the item. You can sort or filter records from this window—for example, to include only one city or category—then confirm the selection. Filtering here affects the current merge; it does not delete rows from your original Excel workbook.
Write the shared content. Type the parts that will be the same for everyone, such as the introduction, instructions, or sign-off. Leave the cursor where personalized information should appear. For a letter, you might write “Dear ” and then insert the recipient’s first name. For a label, begin in the first label cell. With labels, use Mailings > Update Labels after arranging the first label so Word copies its layout and fields to the other cells.
Insert the right merge fields. On the Mailings tab, choose Address Block or Greeting Line for a formatted address or salutation. For more control, select Insert Merge Field and choose a specific column, such as FirstName or PostalCode. These fields appear as placeholders in the document and are replaced by the values in each recipient’s row. If an address block does not use your columns correctly, choose Mailings > Match Fields and match Word’s address items to the corresponding headings in your list.
Format and check the placeholders. Apply normal font, spacing, and paragraph formatting to the merge fields just as you would to text. Check that punctuation and spaces around each field are in the right place; Word will not add them automatically. Date, currency, and postal-code fields deserve special attention because their display can depend on the source data’s formatting. Make postal codes text in Excel if leading zeros must be preserved. For a date or number that appears in an unwanted format, adjust the source column or use Word’s field-formatting options before producing the final copies.
Preview actual records. Select Mailings > Preview Results, then use the left and right arrows in the ribbon to move between recipients. Check the first, a middle, and the last record, as well as any unusual addresses or long names. Confirm that fields show real values rather than placeholders, that line breaks look right, and that no unwanted blank lines or missing details appear. Turn off Preview Results when you want to edit the merge fields again.
Finish the merge in the right way. Select Mailings > Finish & Merge. Choose Edit Individual Documents to create a separate combined Word document that you can review and save; choose Print Documents to send the merge to a printer; or choose Send E-mail Messages for an email merge. For email, select the column containing email addresses in the To box, enter a subject line, and choose a mail format. Word sends one personalized message per included recipient, so test the result and recipient selection before sending a large batch.
Save both the template and final output. Save the Word file with its merge fields so you can reuse it, and save the merged document separately if you need an editable record of each personalized copy. Keep the linked Excel list in a known location. If you move or rename the workbook, Word may ask you to reconnect the data source the next time you open the template.

Common Mistakes

A frequent problem is having headings missing, repeated, or placed somewhere other than the first row of the data. Word may then show generic field names or fail to recognize the intended columns. Clean up the headings and reconnect the workbook if needed. Another common issue is storing a full name or address in one cell when the document needs separate parts. Split the data into columns before merging, or insert the whole field where it belongs.

Do not assume the preview alone proves every record is correct. A long company name, an empty apartment number, or a postal code beginning with zero can expose problems that the first record does not. Also avoid clicking the final send or print option before checking the recipient list and merge type. Selecting Labels instead of Letters, for example, changes the document layout and may require starting the setup again.

Tips

Use descriptive, simple column headings such as EmailAddress rather than punctuation-heavy headings.
Keep a clean source workbook and use a separate copy for sorting, filtering, or correcting data.
Use Preview Results to inspect several records, then use Edit Individual Documents for a final review when the content is important.
For mailing labels, verify the package’s product number and print a test page on plain paper. Hold it behind a label sheet to check alignment before using the labels.
For an email campaign, send a test merge to yourself first. Check the subject, message formatting, links, and whether the correct email field is selected.
Be careful with personal information. Include only the fields needed, protect the recipient workbook, and check organizational rules before sharing or sending the merged output.

Troubleshooting

The fields are missing or the wrong list appears: Go to Mailings > Select Recipients and reconnect the correct workbook. Check that you selected the worksheet with the data and that its first row contains headings. If the workbook was moved, browse to its new location.

Word displays a blank field or the wrong value: Check the matching column in Excel for empty cells, extra spaces, or inconsistent entries. Reopen Edit Recipient List to confirm the correct records are selected, then preview the affected recipient again. If Word used the wrong address columns, set them in Match Fields.

Leading zeros disappear or dates look strange: Excel may interpret a value as a number or date rather than the text you intended. Format the source column appropriately—postal codes are often best stored as text—and save the workbook. Reconnect or refresh the list in Word, then preview the result. Check the merged output before printing if formatting is critical.

Labels repeat the same person or leave cells empty: Confirm that you chose the correct label product and inserted the fields in the first label. Select Mailings > Update Labels to copy that layout to the rest of the sheet, then preview more than one record. If the alignment is off, check the label product number and printer settings.

Email messages do not send: Confirm that every intended recipient has a valid email address and that the correct address column is selected in Send E-mail Messages. Word relies on a compatible email application and account configured on the computer. On Windows, this commonly means a desktop Outlook setup that supports Word’s mail-merge sending process; a browser-only mailbox may not be enough. If you’re using Word for Mac, the core merge steps are similar, but available email options and the compatible email-app workflow can differ. Check your installed Word and email-app versions, or create a merged document and use an approved sending method instead.

Frequently Asked Questions

Can I mail merge in Word without Excel?
Yes. Word can use other supported recipient sources, and you can choose Mailings > Select Recipients > Type a New List to enter a small list. Excel is convenient when you already have many records or need to maintain the data separately.

Can I use an existing Word document?
Yes. Open it, choose the merge type from Mailings > Start Mail Merge, connect the recipient list, and insert fields where personalized details belong. Save a copy first if you want to preserve the unmerged original.

Does a mail merge create one file per person?
Not automatically. Edit Individual Documents creates a combined Word document containing the selected records. You can review and separate the results afterward if you need an individual file for each recipient.

Can I mail merge to email addresses?
Yes. Choose E-mail Messages as the merge type, include an email-address column, and select Finish & Merge > Send E-mail Messages. Word sends a personalized message to each selected record through a compatible configured email application.

Can I filter the list before printing?
Yes. Open Mailings > Edit Recipient List and use its sort and filter controls or clear the checkboxes for records to exclude. Preview the remaining recipients before printing or 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.