Mail Merge in Word: Step-by-Step Instructions

To perform a mail merge in Microsoft Word, prepare a recipient list, choose a document type under Mailings > Start Mail Merge, connect the list with Select Recipients, add merge fields, preview the results, and finish the merge. Mail merge creates personalized letters, labels, envelopes, or email messages from one template and a set of recipient records.

Before you begin, decide what you are producing and check that your recipient information is complete. The instructions below are for Microsoft Word for Microsoft 365 on Windows. Word for Mac has similar Mailings tools, though some dialog boxes and email options can differ. Word for the web does not provide the full desktop mail merge workflow.

What You’ll Need

Microsoft Word for Microsoft 365 desktop. Use the Windows or Mac desktop app for the full set of merge tools.
A recipient list. An Excel workbook is a convenient source, but Word can also use an Outlook contact list or a simple data file. For Excel, put field names such as FirstName, LastName, and Address in the top row, then use one row for each recipient.
A template or a blank document. This is the letter, label layout, envelope, or email text that Word will personalize.
A few minutes to check sample records. Confirm names, addresses, email addresses, and any other fields are accurate before printing or sending.

Step-by-Step

Prepare the recipient list. In Excel, make a single rectangular table with one header row and one record per row. Use short, clear column headings without blank header cells, such as FirstName, LastName, Street, City, PostalCode, and Email. Keep each kind of information in its own column; for example, put first and last names separately if you may want to address people by first name. Remove completely blank rows within the list, check spelling, and save the workbook. Close Excel before connecting it to Word to reduce file-locking issues. If your list is in another format, make sure the fields are clearly separated and the file is saved somewhere you can find.
Open the document and choose the merge type. Open an existing draft or create a new Word document. Select Mailings > Start Mail Merge, then choose Letters, E-mail Messages, Envelopes, or Labels, as appropriate. For labels, choose the label vendor and product number that match the package you will print on. For envelopes, set the envelope size and orientation when Word prompts you. Choosing the type first helps Word apply the correct layout and merge behavior.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List, browse to your Excel workbook, and select it. If Word asks which table or worksheet to use, choose the sheet containing the list and confirm that the first row contains column headers. You can instead use Type a New List to enter recipients in Word, or choose Outlook contacts if that is where your records are stored. After connecting, select Edit Recipient List to check the records and, if needed, sort, filter, or uncheck individual recipients.
Write the shared content. Type the parts that will be the same for everyone, such as the organization name, opening paragraph, and closing. Leave a clear place for details that change. For example, a letter might begin with a greeting line, followed by the personalized body. Avoid typing a recipient’s name or address directly into a spot that should vary; use a merge field there instead. For a label merge, Word displays a label grid, and the first label is the starting layout to design.
Insert the fields that personalize each copy. Click where a changing value should appear, then select Mailings > Insert Merge Field and choose the matching column, such as FirstName or City. Add punctuation and spaces around fields as needed. A greeting could read “Dear ” followed by the FirstName field and a comma. For an address block, use Mailings > Address Block and choose the preferred format, then use Preview Results to see whether the names and address lines fit. Use Greeting Line for a standard salutation, or build one with individual fields if you need more control.
Lay out labels or envelopes carefully. With labels, format the first label, then select Mailings > Update Labels so Word copies its content and fields into the other label cells. Confirm that the label product selected earlier matches the physical sheets. For envelopes, check the delivery address position and return address in the document view, and verify the printer’s envelope feed direction. Print a test on plain paper before using label stock or a stack of envelopes.
Preview several recipients. Select Mailings > Preview Results, then use the left and right record arrows in the Mailings ribbon to move through the list. Check a record near the beginning, one in the middle, and one near the end. Look for missing fields, extra spaces, awkward line breaks, incorrect names, and values that do not fit. If you need to correct the source data, edit and save the Excel workbook, then return to Word and refresh or reconnect the list as necessary.
Finish the merge. When the preview is right, select Mailings > Finish & Merge. Choose Edit Individual Documents to create a new Word document containing the merged copies; this is useful when you want to inspect or edit the output before printing. Choose Print Documents to send the merged items to a printer. Choose Send E-mail Messages for an email merge, then select the email-address field, enter the subject line, and choose a mail format. For email, Word uses a configured desktop email program; a classic Outlook desktop profile is generally the most reliable option on Windows.
Check the final output and save it. Review the merged document or print a sample before producing the full batch. For emails, send a test to yourself first and confirm that the subject, formatting, and recipient address are correct. Save the original template separately from the merged output, using clear file names so you can distinguish the reusable source document from this particular batch.

Common Mistakes

Using inconsistent headers or mixed data. A column titled “Email Address” is fine, but it must have a value for each intended email recipient. Avoid multiple types of information in one column or changing a header halfway down the sheet. Word uses the header row to identify fields, so unclear or duplicate headings can make the wrong field appear in the Insert Merge Field list.

Forgetting to update labels. Designing the first label does not always fill the rest of the sheet. Use Update Labels before previewing, and inspect more than one label in the preview. Also confirm that the selected label number matches the package; even a small mismatch can shift printing across the whole page.

Assuming the preview is the final output. Preview Results displays records in the template, but it is not a substitute for reviewing the merged document or a test print. Long names, unusual address formats, blank values, and page breaks may only become obvious in the final output.

Overlooking special number formats. Postal codes, phone numbers, and account-like identifiers can lose leading zeros if Excel treats them as numbers. Store such values as text in the source list and verify them in Word. Dates or currency may also appear differently from the way they are displayed in Excel, so check those fields in the preview and merged output.

Tips

Use a small test list first, or filter the recipient list to a few records while designing. Remove the filter or select the full list before the real merge.
Keep the template readable and simple. Use ordinary paragraph formatting and tables only when they help; complicated layouts can shift when a name or address is longer than expected.
Use Edit Individual Documents for important letters. It creates a separate output file that can be checked and adjusted without changing the reusable template.
Save the Excel list and Word template in a stable folder. If you move or rename the source workbook after linking it, Word may not find it the next time you open the template.
For email merges, use plain text or restrained formatting if recipients use different email apps. Verify that the email field is correct for every selected record and that the message does not expose another recipient’s address.

Troubleshooting

The merge fields are missing or the wrong columns appear. Open Mailings > Select Recipients and confirm that Word is connected to the intended workbook and worksheet. In Excel, check that field names are in the first row, are not blank or duplicated, and that the list is saved. If necessary, select the correct source again using Use an Existing List.

Word shows «FirstName» instead of a person’s name. That is the field code view, not a completed merge. Select Preview Results to display actual recipient values. If the preview still shows blank values, check that the field name matches the Excel header and that the chosen records contain data in that column.

Some recipients are skipped. Select Edit Recipient List and check whether those records are unchecked or excluded by a filter. Confirm that you selected the correct worksheet and that the records are inside the contiguous data area. Remove filters if you intend to include everyone.

Names, dates, or postal codes look wrong. Correct the value in the source workbook and save it. For identifiers that require leading zeros, format the source column as text before entering or importing the values. Reconnect or refresh the list in Word, then preview the affected record. If date or currency display still differs from the source, use an appropriate Word field format or adjust the source values to the display you need, then verify the merged result before sending.

Labels print out of alignment. Check the product number, paper size, and printer settings. Make sure scaling is set to 100% or actual size rather than “Fit to page,” and use the printer’s correct label-sheet feed option. Print a test on ordinary paper, hold it against a label sheet, and adjust settings before printing on the actual stock.

Email merge does not send. Confirm that the selected email field contains valid addresses and that a desktop mail program is configured and signed in. On Windows, try classic Outlook if the current email app does not accept Word’s merge request. Send a single test message first. If you are using Word for Mac, check the Mailings options available in your installed version and its supported email client; email merge support and setup can differ from Windows.

On a Mac, the ribbon looks different. Look for the Mailings tab and the equivalent recipient, field, preview, and finish commands. Some versions arrange commands or dialogs differently, so use Word’s command search if a named button is not visible. The browser-based Word app has fewer features; open the document in the desktop app to use the full merge workflow.

Frequently Asked Questions

Can I do a mail merge in Word using an Excel spreadsheet?
Yes. Put field names in the first row and one recipient per row, save the workbook, then connect it through Mailings > Select Recipients > Use an Existing List. Choose the worksheet containing the list.

Can I send a personalized email to each person?
Yes. Start an E-mail Messages merge, insert fields into the message, and choose Send E-mail Messages under Finish & Merge. Word requires a supported desktop email setup, and you should send a test before sending to the full list.

Can Word make a separate file for every recipient?
The usual Edit Individual Documents option creates one merged Word document with the selected records, not automatically one file per person. You can use that combined document for review, then split or save individual copies as a separate task.

Can I merge only selected people?
Yes. Choose Edit Recipient List to uncheck records or filter the list by a field. Preview the remaining records and confirm the intended recipients are selected before choosing Finish & Merge.

Can I perform a mail merge in Word for the web?
The full Mailings merge workflow is a desktop Word feature. Open the file in Word for Microsoft 365 on Windows or Mac to connect a recipient list, insert merge fields, and finish 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.