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

To do a mail merge in Word, prepare a recipient list, connect it to a Word document, insert merge fields, preview the results, then choose Finish & Merge to create, print, or email personalized copies. You will need the desktop version of Word, a document or template, and a list of recipients—usually an Excel workbook—with one row per person. Mail merge lets you produce many customized letters, labels, envelopes, or email messages without typing each one separately.

What You’ll Need

Microsoft Word for Microsoft 365 desktop. The instructions below use Word on Windows. Word for the web can open and edit many documents, but it cannot run a full mail merge; open the file in the desktop app to complete the process.
A recipient list. An Excel workbook is a convenient choice. Give each column a clear heading, such as FirstName, LastName, Address, City, PostalCode, and Email. Put one recipient on each row, with no blank rows inside the list.
A document or template. Start with a blank document or an existing letter, label, or envelope layout. Decide what information should be personalized, such as a name, address, appointment date, or account reference.
Optional: a configured email account. If you plan to send an email merge, you need an email column and a compatible desktop email setup. Printing or creating merged documents does not require email.

Step-by-Step

Prepare and save your recipient list. In Excel, put field names in the first row and recipient details below them. Use one column per type of information: do not combine a first and last name in one cell if you want to place them separately. Remove empty rows and columns from the list, check spelling, and save the workbook in a location you can find. For postal codes or other values that may begin with zero, set the column to Text before entering or importing the values; otherwise Excel may remove leading zeros. Close the workbook before connecting it to Word if you run into a file-access or refresh problem.
Open the main document and choose the merge type. In Word for Microsoft 365 on Windows, open a new or existing document and select the Mailings tab. Choose Start Mail Merge, then select Letters for personalized documents, E-mail Messages for individual email messages, Envelopes for addressed envelopes, or Labels for a sheet of matching labels. For labels, choose Labels and select the label vendor and product number that match the package. If you are merging a standard letter, choose Letters and write or paste the reusable text now.
Connect the recipient list. On the Mailings tab, select Select Recipients > Use an Existing List. Find and open the Excel workbook. If Word asks you to select a table or worksheet, choose the one containing the data and confirm that the first row contains column headers when that option appears. If the list is stored in another format, use the available recipient-list option or save a clean copy as an Excel workbook first. To make a small list inside Word instead, choose Select Recipients > Type a New List and enter the recipients in the form.
Choose which recipients to include. Select Edit Recipient List on the Mailings tab to review the connected records. Clear the checkbox beside anyone you do not want to include. Use the sort and filter options in that window if you need a particular group, such as one city or a specific category. Check that you are using the intended worksheet and that its records appear in the list. Keeping the recipient list focused prevents accidental copies for people who should not receive the document.
Write the shared text and insert fields. Type the wording that will be the same for everyone. Click where a personalized value should appear, then select Insert Merge Field on the Mailings tab and choose the matching column heading. For example, write “Dear ”, insert the FirstName field, then add a comma and the rest of the letter. You can also use Address Block to insert a formatted mailing address or Greeting Line to create a salutation. Review the preview before relying on either feature, because its format depends on the names and fields available in your list.
Format the document around the fields. Treat each inserted field as a placeholder: Word will replace it with the value from each recipient’s row. Add spaces and punctuation outside the field where needed. For an address, put fields on separate lines if that is how you want it printed. Apply normal font, paragraph, and page formatting to the document. If you are making labels, set up the first label and its fields, then select Update Labels on the Mailings tab so Word copies that layout to the rest of the sheet. Check that the first label is not the only one containing merge fields.
Preview several records. Select Preview Results on the Mailings tab. Word replaces the field names with details from the current recipient. Use the previous and next record arrows beside the preview control to inspect more than one person, including a record with a long name, a missing optional value, or a longer address. Look for extra spaces, awkward line breaks, missing punctuation, and text that does not fit. Select Preview Results again to return to the field view and make corrections.
Complete the merge. When the preview looks right, select Finish & Merge. Choose Edit Individual Documents to create a new Word document containing the merged copies; this is often the safest choice when you want to review or adjust the results before printing. Choose Print Documents to send the copies to a printer, or choose Send E-mail Messages for an email merge. For email, select the column containing email addresses in the To list, enter a subject line, and choose a mail format. Confirm the recipient range when prompted. A merge does not automatically mean that messages have been sent: review the email setup and the final action before proceeding.

Mac note: In the desktop version of Word for Mac, the Mailings tab provides a similar workflow for connecting recipients, inserting fields, previewing, and finishing a merge. Some dialog names and email options can differ by Word and Outlook version. If you do not see a needed command, check that you are using the desktop app and an updated version; Word for the web does not complete the merge.

Common Mistakes

Using unclear or inconsistent column headings. Headings such as FirstName and Email are easier to identify than blank cells, duplicate names, or headings with unexplained abbreviations. Make the heading row distinct from the recipient records.
Leaving blank rows in the data. Empty rows can make Word interpret the list differently or create blank records. Remove fully empty rows within the recipient list and check the selected worksheet or table when connecting it.
Forgetting spaces and punctuation around fields. If the document contains “Dear” immediately followed by a first-name field, the result may read “DearMorgan.” Put a space after the word and preview the output.
Assuming Excel display formats will always carry over. Postal codes, dates, and numbers may appear differently in Word than they looked in Excel. Store identifiers such as postal codes as text, and preview actual records rather than trusting the field names.
Printing or sending without checking multiple records. One correct preview does not guarantee every record fits. Long names, missing values, or unusual addresses can expose layout problems. Review several records and, for important mailings, create an individual merged document before printing.
Editing the wrong file after merging. The original document contains fields; the merged output contains recipient-specific copies. Save the original main document and recipient workbook separately so you can update the list or rerun the merge later.

Tips

Use a test list first. Create a small copy with two or three sample recipients, including one with a long name or address. Test the layout before using the full list, especially for labels, invitations, or time-sensitive correspondence.
Keep the source list tidy. Use one record per row, consistent formats, and simple headings. Do not add explanatory notes, totals, or extra title rows inside the data range. If some fields are optional, decide how the document should read when they are blank.
Save a reusable main document. Save the Word file with its merge fields before completing the merge. It can serve as a template for later mailings, while the new merged document provides a snapshot of the current results.
Filter rather than deleting records you may need later. Use Edit Recipient List to exclude recipients for one run. This keeps the original workbook intact and makes it easier to reuse the full list next time.
Check label alignment with plain paper. When creating labels, use the correct product number and print a test page on ordinary paper. Hold it against a label sheet to check alignment before using the actual stock.
Protect personal information. Use only the recipient fields needed for the document. Before sharing the merged output, check that each copy contains the correct person’s information and that no extra recipient data is visible.

Troubleshooting

Word cannot find the workbook or asks for a data source. Confirm that the file still exists and that you selected the correct workbook. Close it in Excel, then return to Word and use Mailings > Select Recipients > Use an Existing List to reconnect. If the workbook has several sheets, select the worksheet that contains the actual list.
Merge fields are not available or show the wrong headings. Reconnect the source and inspect the first row of the selected sheet. Make sure it contains headings rather than blank cells or a title, and confirm that the data is on the worksheet Word selected. If you changed the workbook after connecting it, reconnect the list so Word reads the current columns.
Some records are missing. Open Edit Recipient List and check whether their boxes are selected and whether a filter is excluding them. Also check the range or worksheet chosen when you connected the source; records added outside the original data area may not be included. Reconnect the source after expanding the list if needed.
Postal codes lose zeros, or dates and numbers look wrong. Check the underlying value and cell format in Excel. Enter postal codes as text so leading zeros remain, and use a consistent date format. Reconnect the workbook and inspect the Word preview. If a value was already changed when it was entered in Excel, formatting the cell afterward may not restore the missing digits; re-enter the correct value.
The merged page layout is wrong. Return to the main document, check paragraph spacing and page breaks, and preview records with the longest values. For labels, verify the product number and select Update Labels after arranging the first label. Generate an individual merged document to inspect the complete output before printing the full job.
Email merge is unavailable or does not send. Confirm that you selected E-mail Messages as the merge type, that the recipient list has a valid email column, and that Word and your desktop email application are configured for sending. Email merge integration varies by platform and app version. If the command is missing on a Mac or messages do not reach the email app, use a supported desktop setup or create individual merged documents and resolve the email configuration before sending.

Frequently Asked Questions

Can I do a mail merge in Word without Excel?
Yes. Choose Mailings > Select Recipients > Type a New List to enter a small recipient list in Word. You can also connect another supported data source. Excel is often easier when the list is large or needs regular updates.

Can I use mail merge in Word for the web?
Word for the web can open and edit many Word files, but it does not provide the full desktop mail-merge workflow. Open the document in Word for Microsoft 365 desktop on Windows or Mac to connect a list, preview records, and finish the merge.

How do I make a mail merge for labels?
On the Mailings tab, choose Start Mail Merge > Labels, select the label vendor and product number, connect your recipient list, and add fields to the first label. Select Update Labels, preview the sheet, and test alignment on plain paper.

Can I save the merged letters as a separate document?
Yes. Choose Finish & Merge > Edit Individual Documents. Word creates a new document with the personalized results, which you can review and save without replacing the original merge template.

Does Word send all the emails as soon as I click Finish & Merge?
The email option uses your configured email setup and the details you confirm in its dialog. Check the recipient field, subject, format, and recipient range carefully. If you are unsure, first test with a small list and confirm the sending workflow on your version of Word and Outlook.

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.