How to Use Mail Merge in Microsoft Word Step by Step

To use mail merge in Microsoft Word, prepare a recipient list, connect it to a Word document through the Mailings tab, insert fields such as names or addresses, preview the results, and choose Finish & Merge. Mail merge creates personalized letters, labels, envelopes, or email messages from one template. Before starting, make sure your recipient list has a separate column for each detail you want to use.

What You’ll Need

A desktop version of Microsoft Word. These steps use Word for Microsoft 365 on Windows.
A recipient list in an Excel workbook, an Outlook contacts list, or another source Word can connect to. Excel is a practical choice for most lists.
A main document, such as a letter, label layout, or email message. You can create it during the process.
For an email merge, an email address for each recipient and a desktop email program configured to send messages. Word’s email merge relies on a compatible mail setup.

Step-by-Step

Prepare your recipient list. In Excel, put one recipient on each row and one type of information in each column. Use clear headings such as FirstName, LastName, Address, City, and Email in the first row. Remove blank rows above the headings, avoid merged cells, and check that each recipient’s details stay together on the same row. Save and close the workbook before connecting it to Word. If you are using an existing list, check that it contains the fields your document needs.
Create or open the main document. Start Word and open a blank document or the letter you want to personalize. Type any wording that will be identical for everyone, such as the greeting explanation or event details. Leave the places where individual information belongs for later. For a mailing, keep the layout simple and leave enough space for names and addresses of different lengths.
Choose the type of merge. On the Windows ribbon, select Mailings > Start Mail Merge, then choose Letters, E-mail Messages, Envelopes, Labels, or Directory. Choose Letters for a standard personalized document. For labels, select Labels and choose the label vendor and product number that match the package. Directory is useful for creating a combined list or catalog from records rather than a separate letter for each person.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List to use your Excel workbook. Browse to the file and open it. If Word asks you to choose a table or worksheet, select the one containing the list and confirm that the first row contains column headings. For a small list, you can instead choose Type a New List; for contacts already in Outlook, choose Select from Outlook Contacts if that option is available.
Check who will receive the merge. Choose Mailings > Edit Recipient List to review records and temporarily exclude recipients. Clear the check box beside anyone who should not receive this batch. Use the sorting and filtering controls in this window if you need to select a subset, such as one city or a particular customer group. Check the record count and make sure the list does not include test entries or duplicate recipients before proceeding.
Insert the personalized information. Click in the document where a recipient’s name or other detail should appear. Choose Mailings > Insert Merge Field, then select the matching heading, such as FirstName. Type punctuation and spaces around fields as needed. For a postal address, Mailings > Address Block can arrange common address details, and Greeting Line can insert a salutation. Check the preview afterward because Word may not interpret every column heading or address format as you expect.
Finish the wording and layout. Write the fixed text around the fields so each result reads naturally. For example, type “Dear ”, insert the FirstName field, then type a comma. You can format inserted fields with the Home tab just like other text. For a date or number that displays incorrectly, select its merge field and adjust its field code or the source data’s format. To inspect field codes, press Alt+F9; a date code can use a format switch such as \@ "MMMM d, yyyy". Press Alt+F9 again to return to the normal view.
Preview the merged records. Select Mailings > Preview Results. Use the previous and next record arrows to inspect several people, including records with long names, missing details, or unusual addresses. Look for extra spaces, blank punctuation, broken line wraps, and fields that show a heading name instead of a value. If anything looks wrong, turn off Preview Results, correct the document or source list, and preview again before creating the final output.
Complete the merge. Select Mailings > Finish & Merge. Choose Edit Individual Documents to create a new Word document containing the merged results, Print Documents to send them to a printer, or Send E-mail Messages for an email merge. For email, choose the column containing email addresses in the To box, enter a subject line, and select a mail format. Review the selected recipient range, then confirm. Save the merged document if you want a copy to proofread or archive.

For labels, after inserting the fields in the first label, select Mailings > Update Labels so Word copies the layout to the other label positions and adds the record progression. Preview the full sheet before printing. For email, test the message with a small, appropriate recipient list first. Word creates a separate personalized message for each selected record; it does not provide a single message with all recipients visible in the To field.

In Word for Mac, use the Mailings tab for the same general workflow, but some dialog labels and recipient-list options can differ by release. If you do not see a Windows option, check the Mac version’s Mailings ribbon and Word help. Email merging also depends on having a compatible mail application configured; confirm that your setup supports sending from Word before using a large list.

Common Mistakes

Using unclear or missing column headings: A blank heading or two identical headings can make it hard to choose the right field. Give each column a unique, descriptive name.
Leaving the workbook open or changing it after connecting: Word may retain the previous version of the data. Save and close the source workbook, then reconnect or refresh the recipient list if you have made changes.
Skipping Preview Results: A field can be technically correct but still look awkward in the sentence or label. Preview several records, not only the first one.
Assuming formatting will transfer exactly: Dates, postal codes, and numbers can display differently from their appearance in Excel. Keep postal codes as text when leading zeroes matter, and check merged output before distributing it.
Printing directly without a proof: A wrong label size or an unintended recipient can waste paper or expose information. Use Edit Individual Documents or a small test print when layout or recipient selection is important.

Tips

Use plain, stable column headings without punctuation or blank spaces at the beginning or end. Headings like FirstName and PostalCode are easy to identify in Word.
Keep one row per person or household, depending on how you intend to address the mail. Do not put multiple recipients in one cell if you need separate personalized messages.
Use Address Block for a conventional mailing address, but use individual merge fields when you need precise control over line breaks or local address conventions.
Make a copy of the source workbook before sorting, filtering, or cleaning a large list. This gives you a dependable original if the data needs to be restored.
For a first run, merge to a new document rather than printing immediately. You can inspect page breaks, spacing, and every personalized result before deciding what to do next.
When preparing email, write the subject line clearly and avoid sending confidential information to a list until you have checked the email column and tested the message.

Troubleshooting

Word does not show the expected worksheet. Save and close the Excel file, then reconnect it with Mailings > Select Recipients > Use an Existing List. Confirm that the data is on a normal worksheet with headings in the first row and no blank rows above them. If the workbook has several sheets, select the one containing the recipient table when Word prompts you.

A merge field appears as FirstName or another heading. Turn off Preview Results to check whether you inserted a merge field rather than typed the heading as ordinary text. If the field is correct but still displays a heading, turn Preview Results on and move through the records. Check that the source column has a heading and that the selected list is the right one.

Dates or postal codes look wrong. Check the source values first. Excel can remove leading zeroes from numbers, so store postal codes as text when those zeroes are meaningful. For dates, confirm that the source cells contain real dates rather than inconsistent text, then use a Word date field format switch if the merged appearance needs to change. Re-preview the records after editing.

Email messages do not send. Confirm that the recipient column contains valid email addresses, that Word is connected to the intended list, and that the desktop email program is configured and able to send. Try a small test merge and check the program’s outbox or error message. Some email setups, including certain newer app configurations, may not work with Word’s mail-merge sending method; use a compatible desktop mail client or create merged documents and send them through an approved alternative.

Labels do not line up. Verify the label brand and product number under Mailings > Start Mail Merge > Labels. Check the printer’s paper size and print scaling, and avoid settings such as Fit to Page if they change the label dimensions. Print a test on plain paper and compare it with a label sheet held up to the light before using the actual labels.

Frequently Asked Questions

Can I use an Excel file as the mail-merge list?
Yes. Put headings in the first row and one recipient per row, save the workbook, then connect it through Mailings > Select Recipients > Use an Existing List.

Can I send personalized emails with Word?
Yes. Choose E-mail Messages when starting the merge, include an email-address column, and use Finish & Merge > Send E-mail Messages. Word sends a separate message for each selected record through a compatible email setup.

Can I add an attachment to every mail-merge email?
Word’s email merge is designed to personalize message content and does not offer a straightforward way to attach a different file to each message. The merge dialog may offer an Attachment mail format, but that treats the merged content as an attachment rather than adding a separate file. For file attachments, use a workflow designed to send them and verify each recipient’s file carefully.

How do I print address labels from a mail merge?
Choose Labels under Mailings > Start Mail Merge, select the matching label product, connect the list, insert fields in the first label, and choose Update Labels. Preview the sheet and test the alignment before printing on label stock.

Can I edit each letter after the merge?
Yes. Choose Finish & Merge > Edit Individual Documents to create a new document with the merged records. Edit or proofread that document without changing the original template or recipient workbook.

Does mail merge work in Word for the web?
Mail merge is primarily a desktop Word feature, and the full Mailings workflow may not be available in Word for the web. Open the document in the desktop app to connect a recipient list and complete the merge.

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.