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

To mail merge in Word, prepare a spreadsheet or contact list with one person per row, choose a merge type on the Mailings tab, connect the list, insert fields such as names or addresses, preview the results, then finish the merge. Mail merge creates a separate personalized letter, label, envelope, or email for each record, so you can send a consistent message without editing every copy by hand.

Before you begin, decide what you are making and check that your recipient data is complete. The instructions below use Word for Microsoft 365 on Windows. Most letter and label steps are similar in Word for Mac, though ribbon layouts and email options can differ by version.

What You’ll Need

Microsoft Word: Use the desktop version of Word for the full set of merge tools.
A recipient list: An Excel workbook is a common choice. A Word table, Outlook contacts, or another supported data source can also work.
Clean data: Each row should represent one recipient, with a separate column for each detail you may use, such as first name, last name, street, city, and email address.
Your finished content: Draft the letter, label layout, or email message, and know which details should be personalized.
For printed labels: The label package or product number, so you can select the matching layout in Word.
For an email merge: A compatible desktop email program configured to send messages, plus a valid email address for each recipient.

Step-by-Step

Prepare and save the recipient list. In Excel, put field names in the first row, such as FirstName, LastName, Street, City, PostalCode, and Email. Use a distinct heading for each column; avoid blank headings, merged cells, subtotals, and completely blank rows within the list. Put one recipient on each row and keep each kind of information in its own column. Check spelling and remove records you do not want included. Save the workbook, then close it before connecting it to Word. If a postal code or account-like value begins with zero, store it as text so Excel does not remove the zero.
Choose the type of merge. Open or create the main document in Word. Go to Mailings > Start Mail Merge, then select Letters, E-mail Messages, Envelopes, Labels, or Directory. Choose Letters for documents that will be printed or saved individually. Choose Labels to create a sheet of repeated address labels. Directory is useful for a combined list or catalog-style document; it does not create a separate letter for each person. For a basic personalized letter, select Letters.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List, find your Excel workbook, and select it. If Word asks which table or worksheet to use, choose the one containing the data and confirm that the option indicating the first row contains column headers is selected when available. If your data is an Excel table, select that table. Word now has a source for the merge fields, but it has not yet inserted any personal details into the document.
Review who will receive the merge. Choose Mailings > Edit Recipient List to inspect the records. You can sort or filter the list and clear the check box beside any recipient to exclude them. For example, filter a City column to make a mailing for one location, or uncheck test records before printing. Take care with filters: a filter can leave out rows without deleting them from Excel. If the list looks wrong or a column is missing, cancel or reconnect to the correct sheet before building the document.
Write the shared message and insert personal fields. Type the text that every recipient should see, leaving the cursor where personalized information belongs. On the Mailings tab, use Address Block to insert a formatted postal address, or Greeting Line to add a salutation. For more control, choose Insert Merge Field and select a column such as FirstName or City. Add spaces and punctuation around fields yourself. For example, type Dear, insert FirstName, then type a comma and start the next paragraph. A field is a placeholder; it will show the recipient’s actual value when you preview or complete the merge.
Preview several records. Select Mailings > Preview Results. Use the previous and next record arrows in the ribbon to check different recipients, not just the first one. Confirm that names, addresses, punctuation, and spacing look natural, and check that no field displays as blank or as an unexpected code. If a value is missing, return to the source list and check its column heading and row. If the greeting has awkward spacing, edit the text around the merge field and preview again.
Complete a letter, envelope, or label merge. For letters, select Finish & Merge > Edit Individual Documents, choose All or a record range, and confirm. Word creates a new document containing the merged copies. Review it before printing; this gives you a chance to catch a bad address or page break without changing your original template. You can also choose Finish & Merge > Print Documents to print directly. For envelopes, check the print settings and envelope feed before producing the full batch.
Set up labels or email messages as needed. For labels, choose Start Mail Merge > Labels, select the label vendor and product number, and confirm the layout. Connect the list, insert the desired address fields in the first label, then select Update Labels so Word copies the layout across the sheet. Preview before printing. For email, choose E-mail Messages at the start, compose the message, then use Finish & Merge > Send E-mail Messages. Select the email-address column in the To box, enter a subject, and choose a mail format. Send a test to yourself first when possible.

Word for Mac: The Mailings tab generally offers the same merge concepts, including recipient selection, merge fields, previewing, and completing the merge, but some controls may be arranged differently. Use the ribbon search or Word Help to locate a command if its position differs. Email merging depends on the Word and mail-app versions available on your Mac; if the email option is missing or cannot send, create the merged content as a document or use a compatible desktop mail workflow instead.

Common Mistakes

Using unclear or duplicate column headings: Headings such as Name and Name are hard to distinguish when inserting fields. Use specific, unique labels such as FirstName and LastName.
Putting multiple recipients in one row: Each row should represent one merge result. Split separate people or addresses into separate rows if they need separate letters.
Forgetting to update labels: If you put fields in only the first label and do not choose Update Labels, the rest of the sheet may be empty or repeat incorrectly.
Printing without previewing: A merge can contain blank names, an unexpected page break, or the wrong selection of recipients. Preview and inspect the completed document before printing a large batch.
Relying on spreadsheet display formatting: Some values, especially dates, long numbers, and postal codes with leading zeros, may not appear as expected after Word connects to Excel. Make the source data unambiguous and check the merged output.
Sending email to the whole list without a test: A wrong To column or subject line can affect every recipient. Verify the address field and send a test message before sending the complete merge.

Tips

Make a small test list. A few sample records with different names, addresses, and edge cases make it easier to check the layout before you use the full list.
Use meaningful field names. FirstName, PreferredName, and PostalCode are easier to identify than Column1 or Data. Avoid punctuation in headings where possible.
Keep a clean original template. Save the main Word document before completing the merge. Edit the newly generated merged document when you need to correct an individual copy, and edit the template when you want to change all copies.
Check page layout for the output type. For a letter, confirm margins and page breaks. For labels, use the exact product number and print a test sheet on plain paper to compare alignment before using label stock.
Use Preview Results as you build. Preview after inserting a field and again after making layout changes. This catches spacing problems earlier than reviewing a large final document.
Keep sensitive information out of unnecessary fields. Include only the data needed for the mailing, and store the workbook and merged output where their access is appropriate.

Troubleshooting

The field list is empty or the wrong columns appear. Confirm that the Excel headings are in the first row, that each heading has a name, and that the correct worksheet or table was selected. Save and close the workbook, then reconnect using Mailings > Select Recipients > Use an Existing List. If you recently changed the headings, reconnect so Word refreshes the available fields.

Names or addresses are blank in the preview. Check the corresponding cells in Excel and confirm that the selected recipients include those rows. Make sure you inserted the intended field and not a similarly named column. If some records legitimately lack a value, revise the source data or adjust the wording so the result still reads well when that field is empty.

Postal codes lose leading zeros or dates look strange. Correct the source column in Excel, preferably by storing postal codes as text, save the workbook, and reconnect it in Word. Do not assume a number’s display format in Excel will carry through. Preview records with the shortest and longest values, and consider using a separate, clearly formatted text column if the data needs a specific display.

Labels do not line up with the sheet. Verify the label vendor and product number in the label setup, confirm the printer’s paper size, and check that the sheet is loaded in the correct direction. Print on plain paper first and hold it against the label sheet. Printer scaling settings such as Fit to Page can shift the layout, so use the actual size setting when available.

The email merge does not send. Check that the selected To field contains complete email addresses and that a compatible desktop mail program is configured. Confirm that the subject and mail format are filled in, and test with one or a few addresses. If your organization blocks bulk sending, ask its administrator about approved limits or use its authorized mailing service rather than repeatedly retrying the merge.

The merged document has unexpected pages or repeats. Use Preview Results to find where the layout changes, then inspect paragraph marks and page breaks in the original document. For a label merge, confirm that Update Labels was used. For a letter merge, create a fresh merged document after correcting the template instead of continuing to edit an earlier output.

Frequently Asked Questions

Can I use Google Sheets or a CSV file as the recipient list?
Yes. Save or download the data as an Excel workbook or a comma-separated values file, then choose it through Use an Existing List. Check the column headings and sample values after connecting, because CSV files do not preserve spreadsheet formatting and can treat values such as leading-zero postal codes differently.

Can I edit each letter after the merge?
Yes. Choose Finish & Merge > Edit Individual Documents to create a separate Word document containing the results. You can edit that output without changing the original template or recipient list. If you need to change the shared wording for everyone, revise the template and run the merge again.

Can Word mail merge create personalized emails?
Yes. Start with E-mail Messages, insert merge fields into the message, then use Send E-mail Messages and choose the column containing recipients’ email addresses. The messages are individualized rather than one message with all recipients visible in the To line. Sending availability depends on a compatible mail program and your organization’s configuration.

How do I send the merge to only some people?
Choose Mailings > Edit Recipient List and clear the check boxes for people to omit, or use the available sort and filter controls to narrow the list. Preview the remaining records before completing the merge. If you use a filter, remember that it changes which rows participate in the merge, not the underlying spreadsheet data.

Can I use mail merge for address labels?
Yes. Choose Labels under Start Mail Merge, select the package’s vendor and product number, insert the address fields, and select Update Labels. Preview the sheet and print a plain-paper test to verify alignment before loading the actual label stock.

Do I need to keep the Excel file after merging?
Keep it if you may need to revise the recipient data or run the merge again. The merged Word document contains the results created at that time, but it is not a substitute for a well-maintained source list. Store both files securely if they include personal information.

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.