Mail Merge in Word: Practical Questions and Answers

To run a mail merge in Microsoft Word for Microsoft 365 on Windows, open the Mailings tab, choose Start Mail Merge, select a recipient list with Select Recipients, insert fields such as names or addresses, preview the results, and choose Finish & Merge. Mail merge combines one document template with a list of records to create personalized letters, labels, envelopes, or email messages.

What mail merge does—and when to use it

A mail merge keeps shared wording in one Word document while filling selected places with information from a data source. For example, a community group could prepare one invitation template and use a spreadsheet with columns for first name, postal address, and event date. Word can produce a separate invitation for each row without requiring someone to copy and edit the document repeatedly.

The source list is usually an Excel workbook, but Word can also use other supported data sources, including a list created in Word or contacts from Outlook. Each row in a list represents one recipient, and each column represents a type of information. In the document, a merge field such as «FirstName» marks where Word should put the value from the matching column.

Letters: Create a separate personalized document for each recipient.
Labels and envelopes: Put a different address in each label or envelope position.
Email messages: Prepare a common message with personalized text for each recipient.

Mail merge is useful when the content is mostly the same but a few details vary. It is not a substitute for a system that manages complex customer records, tracks consent, or sends large campaigns with delivery analytics.

Prepare a clean recipient list

Taking time to organize the source list prevents many common merge problems. In Excel, put clear column headings in the first row, such as FirstName, LastName, Street, City, and PostalCode. Keep one person or mailing destination per row, and put one kind of value in each column. Avoid blank heading cells, merged cells, subtotal rows, and notes inside the data range.

Check for missing or duplicated entries, inconsistent spellings, and stray spaces. If a recipient should be addressed differently from their name in the list, add a separate column such as GreetingName rather than trying to make Word infer the preferred form. For example, a formal letter might use a full name in the address block but a first name in its opening sentence.

Pay particular attention to postal codes, account identifiers, and other values with leading zeroes. Excel may treat them as numbers and remove those zeroes. Set the relevant cells to Text before entering or importing the values, or prepare a dedicated text-formatted column. Save the workbook, close it, and then select it from Word; a closed, clearly structured source is easier to connect reliably.

Create a basic letter merge

In Word for Microsoft 365 on Windows, the usual sequence for a letter is:

Open a new document or the letter you want to personalize. Select Mailings > Start Mail Merge > Letters.
Choose Mailings > Select Recipients > Use an Existing List, locate the Excel workbook, and select the worksheet or table containing the records. Confirm that the option indicating the first row contains column headers is selected when appropriate.
Write the shared text. Click where personalized information belongs, then use Mailings > Insert Merge Field to add the matching column, such as FirstName or City.
Select Preview Results and use the previous and next record controls to inspect different recipients.
When the preview is right, choose Finish & Merge. Select Edit Individual Documents to create a combined document you can inspect, or choose Print Documents to send the merged output to a printer.

For example, a template might say, “Dear ” followed by the FirstName field and a comma. The rest of the letter remains unchanged, while Word replaces that field with each person’s value. For an important or large mailing, creating and reviewing the individual documents first is safer than printing immediately.

On Mac, Word also provides mail merge tools on the Mailings tab, though dialog boxes and some labels can differ slightly from Windows. If the ribbon is collapsed or the tab is hidden, use Word’s ribbon display options to show it. Word for the web does not provide the full desktop mail-merge workflow; open the document in the desktop Word app to set up and complete a merge.

Choose the right fields and personalize text

Use Mailings > Insert Merge Field to add a particular source column wherever its value belongs. Word also offers common insertions such as an address block and greeting line, which can save time for standard correspondence. After inserting a field, the document may show a label like «City» rather than a real city. That is expected: select Preview Results to see the value for a record.

Do not assume that a column heading will automatically appear in the document. The merge field must be inserted where you want the data. Also check the exact heading names when a field is missing or Word displays an unexpected column: a source heading like “First Name” may appear differently from “FirstName.” Re-selecting or reconnecting the correct worksheet can help if the source list changed after setup.

For optional wording, use Mailings > Rules and choose a rule such as If…Then…Else. For example, a template could show one sentence to recipients in a particular membership category and another sentence to everyone else. Rules need careful testing: preview records that meet both conditions, as well as records that meet neither, so no one receives a blank, misleading, or awkward sentence.

Handle dates, numbers, and formatting

Word may not display dates, currency, or numbers exactly as they look in Excel. A date that appears as “March 8, 2026” in a worksheet might show as a different date style in the merged document. Previewing is essential because the output depends on how the source values are stored and interpreted.

For a Word date field, you can set a display format using a field switch. Press Alt+F9 on Windows to show field codes, locate the date field, and add a format switch such as \@ "MMMM d, yyyy" inside its field code. Press Alt+F9 again to return to the normal view and preview several records. On Mac, the keyboard shortcut for showing field codes can vary with the keyboard and Word version; use Word’s field-code display command if the shortcut differs.

For values that must retain exact characters, such as postal codes, it is often more dependable to store them as text in the source rather than relying on display formatting. If a number or date is important, compare the merged preview with the source row before producing the final batch.

Make labels, envelopes, or email messages

For address labels, choose Mailings > Start Mail Merge > Labels, then select the label vendor and product number that match the package. Connect the recipient list and insert the address fields in the first label. Use Update Labels to copy the layout to the other label positions, then preview the sheet. A mismatch between the selected product and the physical label stock can shift printing, so print a test on plain paper and compare it with an unused label sheet before using the labels.

For envelopes, choose the envelope merge type and check the envelope size, feed method, and address placement in the layout options. Printer settings matter: the envelope may need to be loaded in a particular orientation. Test one envelope before preparing a full batch.

For email, select the email merge option and use Finish & Merge > Send Email Messages. Choose the source column containing each recipient’s email address, enter a subject line, and select the desired message format. Word sends a separate message for each selected record; it does not create one message with all recipients visible to one another. Email merging relies on a compatible desktop email setup, commonly classic Outlook on Windows, and availability can depend on the Outlook configuration. Send a test to yourself and verify the recipient field, subject, links, and personalized text before sending to the list.

Filter recipients and prevent common mistakes

You do not have to send to every row. Choose Mailings > Edit Recipient List to sort or filter the connected records and clear the selection for recipients you want to exclude. For example, filter a City column to prepare invitations for one location, or exclude rows with missing email addresses before an email merge. Make sure the preview controls are showing the intended recipients, not simply the first few entries in the full source.

Typical problems have straightforward checks:

Wrong worksheet or incomplete list: Reconnect the workbook and confirm the correct table or sheet and data range.
Blank or incorrect field: Check the source heading, the selected field, and whether the corresponding row actually contains a value.
Leading zeroes disappear: Store the source value as text and verify the merged preview.
Every label shows the same address: Use Update Labels after setting up the first label so Word advances through records.
Output has an unwanted blank page or spacing: Inspect the merged document’s page breaks, paragraph spacing, and label layout before printing.

One misconception is that Preview Results creates the final letters. It only displays sample records in the main merge document; Finish & Merge is the step that produces or sends the merged output. Another is that merging automatically corrects poor data. Word inserts what the source provides, so misspellings and incomplete addresses need to be fixed in the source list or handled with appropriate rules.

Review privacy and final output

A merge can create a document containing many people’s names, addresses, or other personal details. Keep the source workbook and merged output in a location with appropriate access controls, avoid sharing the combined document unnecessarily, and delete temporary copies when they are no longer needed under your organization’s retention practices. Before printing or emailing, verify the selected recipient records and inspect the final output for personal information in the wrong place.

For a large mailing, work from a copy of the source list and make a small test batch first. Check the first, middle, and last records, along with any unusual cases such as a long name, a blank optional field, or an international address. This catches layout and data issues that a single preview may miss.

Frequently Asked Questions

Can I use an Excel spreadsheet for Word mail merge?
Yes. In Word, choose Mailings > Select Recipients > Use an Existing List and select the workbook. Keep the first row as clear column headings and use one record per row.

How do I make a separate letter for each person?
Set up a letter merge, insert the required fields, and choose Finish & Merge > Edit Individual Documents. Word creates a document containing the merged letters, which you can review and save or print.

Why does my mail merge show the field name instead of the value?
The main document normally displays field names until you select Mailings > Preview Results. If the preview still shows an unexpected result, check that the field matches a heading in the connected source list.

Can I send a mail merge to only some recipients?
Yes. Open Mailings > Edit Recipient List and use its sorting, filtering, or selection controls to choose the records for the current merge.

Can I do a mail merge in Word for the web?
The full setup and completion tools are in desktop Word, not Word for the web. Open the document in the desktop app to connect a recipient list, insert fields, and finish the merge.

How do I avoid printing hundreds of incorrect letters?
Preview several records, create the merged output for review with Edit Individual Documents, and print a small test batch before printing the full set.

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.