How to Create a Mail Merge Document in Microsoft Word

To create a mail merge in Microsoft Word, prepare a recipient list—usually in Excel—then use Word’s Mailings tab to connect the list, insert fields into a letter or other document, preview the results, and finish the merge. You can create personalized letters, labels, envelopes, or email messages without typing each person’s details separately. For the full set of merge tools, use the Word desktop app; Word for the web may not provide all the commands needed to set up a merge.

What You’ll Need

Microsoft Word for Microsoft 365 on Windows. The steps below use the desktop ribbon. In Word for Mac, use the Mailings tab too; button positions and some dialog details can differ slightly.
A recipient list. An Excel workbook is a common choice. Put one person or organization on each row, use a clear heading at the top of each column, and avoid merged cells and completely blank rows within the list. For example, headings might include FirstName, LastName, Address, City, and PostalCode.
A document to personalize. This can be a new blank document or an existing letter. Decide whether you are making letters, labels, envelopes, or email messages before you start.
A saved copy of your recipient file. Save and close the Excel workbook before connecting it in Word. This reduces the chance of Word reading an outdated or unavailable version.

Step-by-Step

Prepare and check the recipient list. In Excel, put the field names in the first row and the recipient details below them. Keep each type of information in its own column: for example, use separate FirstName and LastName columns if you want to greet people by first name. Check for misspellings, duplicate records, missing addresses, and inconsistent capitalization. Format values such as postal codes as text if they may start with zero, so Excel does not remove that zero. Save the workbook, then close it.
Open or create the main document. Start Word and open the letter or document you want to personalize, or choose Blank document. Type the text that will be the same for everyone, such as the body of a notice. Leave the insertion point where a recipient-specific item should appear. You can add the merge fields now or after connecting the recipient list.
Choose the kind of merge. On the ribbon, select Mailings > Start Mail Merge, then choose Letters, E-mail Messages, Envelopes, or Labels. For a standard personalized letter, choose Letters. Labels and envelopes use their own layout dialogs, so select the correct product or size when Word prompts you. In Word for Mac, open the Mailings tab and choose the corresponding mail merge type; the arrangement of commands may differ.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List. Browse to your saved Excel workbook and select it. If Word asks you to choose a table or worksheet, select the sheet containing the list and confirm that the first row contains column headings. If the workbook has named tables, choose the table containing the data. Word uses the column headings as available merge fields. You can also select Type a New List to enter recipients in Word, or Choose from Outlook Contacts if that option is available and suitable.
Insert personalized fields. Click in the document where you want information to appear. Choose Mailings > Insert Merge Field, then select the matching heading, such as FirstName or Address. For example, type “Dear ”, insert the FirstName field, and type a comma after it to create a personalized greeting. Add address fields on separate lines where appropriate. Insert fields individually rather than typing their names in angle brackets: Word needs actual merge fields, not ordinary text that merely looks like one.
Arrange the content and check the layout. Add punctuation and spaces around fields where needed. A greeting might read “Dear ” followed by the FirstName field and a comma. For a postal address, insert the recipient’s name and address fields on separate lines. If a field may be blank, check that the surrounding punctuation or line breaks will still look sensible. Use the normal Word formatting tools to adjust fonts, paragraph spacing, and alignment; formatting the field in the document controls how its merged value appears.
Preview individual records. Select Mailings > Preview Results. Word replaces the field names with data from a recipient record. Use the left and right arrow buttons in the Mailings ribbon to move through records, and inspect several entries—not only the first one. Look for missing values, awkward spacing, unusually long names, incorrect addresses, and text that wraps badly. Select Preview Results again to return to the field view if you need to edit the template.
Filter or exclude recipients if needed. Choose Mailings > Edit Recipient List to review the connected records. You can clear the check box beside a recipient to exclude that person from this merge, or use the list controls to sort and filter records. For instance, you might filter a Region column to include only one area. Check the displayed recipient count and sample records before continuing; filtering in Word does not change the source Excel workbook.
Finish the merge and review the output. Choose Mailings > Finish & Merge. Select Edit Individual Documents to create a separate merged document you can inspect and save, or choose Print Documents to send the merged records to a printer. For email, choose Send E-mail Messages, select the column containing email addresses, enter a subject line, and choose a mail format. Email merging requires a supported email setup, commonly Outlook desktop; do not send until you have checked the recipient list and content. If you create a new merged document, review it before distributing or printing it.

Common Mistakes

Using the wrong source column. A field named “Address” may contain only a street, not a complete mailing address. Check that each inserted field matches the data you intend to show. Clear, distinct headings make this easier.

Typing field names instead of inserting fields. Text such as «FirstName» typed by hand will not populate automatically. Insert fields through Mailings > Insert Merge Field.

Leaving blank rows or headings in the wrong place. A blank row in the middle of a list can interrupt the records Word reads, while a missing or duplicate heading can make it hard to identify the right field. Keep one header row and a continuous block of recipient data.

Skipping preview. A template can look correct while merged records contain extra spaces, missing details, or unexpectedly long text. Preview multiple records and inspect the completed merged document, especially before emailing or printing a large batch.

Assuming Excel’s display formatting will always carry over. Dates, postal codes, and numbers can appear differently after merging. Preserve postal codes as text in the source when leading zeros matter, and preview dates and amounts in Word before sending.

Tips

Use short, descriptive column headings such as FirstName, City, and EmailAddress. Avoid blank headings, duplicate names, and punctuation that makes a field difficult to recognize.
Test the merge with a small selection first. In Edit Recipient List, temporarily select just a few records, finish to a new document, and inspect the results before merging the full list.
Keep the original Excel workbook unchanged while you build the merge. If details need correction, update the workbook, save and close it, then reconnect or refresh the list in Word as needed.
For dates that display in an unwanted style, you can format the date merge field in Word. In field-code view, a date field can include a format switch such as \@ "MMMM d, yyyy". Field-code display and editing can vary by platform, so preview the result and consult Word’s field-code help if the switch does not take effect.
For letters, choose Edit Individual Documents when you want a final combined file to proofread. This gives you a chance to correct a problem in the merged output without altering the original template.
Save the main document with a useful name and keep it with the associated data file. The Word document stores the layout and fields; keeping the source workbook available makes it easier to update the recipient list for a later merge.

Troubleshooting

The recipient list does not appear or Word cannot find the workbook: Confirm that the Excel file is saved locally or in a location you can access, and close it before selecting it in Word. Use Mailings > Select Recipients > Use an Existing List to browse to it again. If prompted, choose the correct worksheet or table and confirm the header-row setting.

Merge fields show instead of recipient data: Turn on Mailings > Preview Results. If the preview still shows a field name or an empty result, check that the field was inserted from the correct source heading and that the selected record has a value in that column. Reconnect the list if the source or worksheet changed.

Some recipients are missing: Open Edit Recipient List and check whether their boxes are selected or a filter is excluding them. Also inspect the source sheet for blank rows, data placed outside the main list, or a different worksheet that Word may have connected to.

Postal codes lose leading zeros or dates look wrong: Correct the source data and formatting in Excel, then save and close the workbook. Reconnect or refresh the recipient data and preview again. If a date still appears in an unsuitable style, adjust the date field’s formatting in Word and check the merged result before producing the final document.

Labels or envelopes are misaligned: Check that you selected the exact label or envelope product and size when starting the merge. For labels, use Mailings > Update Labels after arranging the first label so the layout is repeated across the sheet. Print a test on plain paper and compare it with the label sheet before using actual labels.

Email messages do not send: Check that the selected email-address field contains valid addresses and that your email account is configured in the supported desktop mail app. In the send dialog, verify the address field, subject, and mail format. If the email option is unavailable, use Word desktop with a compatible mail setup or create personalized documents instead.

Frequently Asked Questions

Can I use an Excel file as the mail merge list?
Yes. Save the workbook with a clear header row and one recipient per row, then connect it using Mailings > Select Recipients > Use an Existing List. Choose the worksheet or table that contains the data.

Can I create a mail merge without Excel?
Yes. Word can create a new recipient list through Mailings > Select Recipients > Type a New List, and it may also offer Outlook contacts. Excel is often easier when you already have many records or need to maintain the list separately.

Does mail merge change my original document?
The merge fields remain in the main document. Choosing Edit Individual Documents creates a separate merged document, while printing sends the output to a printer. Keep the original template so you can reuse it.

Can I send a personalized email to each recipient?
Yes. Start an E-mail Messages merge, insert fields into the message, then choose Finish & Merge > Send E-mail Messages. Select the email-address column and review the subject and format. A compatible email setup is required, and you should verify the recipient list before sending.

Can Word for the web create a mail merge?
Word for the web may not include the complete desktop mail merge setup and finish commands. Use Word for Microsoft 365 on a Windows PC or Mac to create and complete the merge; you can still use a browser to view or edit many ordinary Word documents.

How do I make one letter for each person?
Choose Letters under Start Mail Merge, add the fields you need, preview the recipients, and select Finish & Merge > Edit Individual Documents. Word creates a combined document containing a personalized copy for each selected record.

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.