Mail Merge in Word: How It Works and How to Use It

Mail merge in Word combines a document template with a list of information—such as names and addresses—to create a personalized letter, label, envelope, or email for each recipient. In Word for Microsoft 365 on Windows, start from the Mailings tab, choose a merge type and recipient list, insert merge fields, preview the results, then select Finish & Merge.

What mail merge does

A mail merge separates the content that stays the same from the details that change. The template might contain a standard letter, while a spreadsheet supplies a different name, address, appointment date, or account reference for each person. Word matches each row of the list to the fields in the template and produces a personalized result for that row.

For example, a community organization could prepare one event invitation and use a list with columns for FirstName, LastName, Street, City, and EventDate. The letter can greet each person by name and show their own address and event date, without requiring the writer to create and edit a separate document for every guest. The merge does not automatically verify that the source information is correct; it reproduces the data it receives.

Mail merge is useful when many documents share a structure but need individual details. It is not the same as copying a document repeatedly: fields in a merge template act as placeholders that Word fills from the selected list when you preview or complete the merge.

Prepare the recipient list

Word can use an Excel workbook, an Outlook contacts list, or a list created within Word as a source. Excel is often convenient because it is easy to review and update, but a clean list matters more than the program used to make it. Set up the data before connecting it to Word:

Put one recipient or record on each row, and put one type of information in each column.
Use a clear heading in the first row, such as FirstName, LastName, Email, or PostalCode. Avoid blank header cells and duplicate headings.
Keep the table continuous: do not insert blank rows or extra title rows within the data.
Check names, addresses, email addresses, and dates for missing or inconsistent values.
Format postal codes, identification numbers, and other values with leading zeroes as text in Excel. Otherwise, Excel may treat them as numbers and remove those zeroes.

Save and close the workbook before selecting it in Word. If Excel has several worksheets, keep the merge records together on one sheet and make sure the data range is clearly organized. Word may offer a choice of worksheet or named range when you connect the file.

Start a merge in Word

In Word for Microsoft 365 on Windows, open the template document and select Mailings > Start Mail Merge. Choose Letters, E-mail Messages, Envelopes, Labels, or Directory, depending on the result you need. A directory merge is useful for assembling a series of records into one document, such as a printed contact list.

To follow the guided workflow, choose Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard. The wizard presents the main tasks in order. You can also use the commands on the Mailings tab directly. To connect an Excel list, choose Mailings > Select Recipients > Use an Existing List, locate the workbook, and select the appropriate sheet or range in the prompts.

Use Select Recipients to choose an Outlook contacts list or to create a new list in Word instead. After connecting a list, select Edit Recipient List to inspect entries, sort or filter records, and clear the check box beside anyone who should not receive a result. Filtering can help make a smaller batch—for example, selecting only people in one city—without changing the original workbook.

Build the template with merge fields

Write the parts of the document that will be the same for everyone, then place the cursor where a personalized value should appear. Select Mailings > Insert Merge Field and choose the matching column heading. A field appears in the document as a placeholder, such as «FirstName»; the chevrons indicate a merge field, not text that you should type as a substitute.

For a standard address, Word can insert a formatted block through Mailings > Address Block. Use Mailings > Greeting Line to create a salutation, and review its options for how names should appear. These helpers are convenient, but they depend on the source columns being recognized correctly. If the proposed address or greeting does not match your data, insert individual fields instead and arrange them yourself.

A letter might begin with «FirstName» and include «EventDate» in its opening paragraph. In the template, put spaces and punctuation around fields where needed: a field will not automatically add a comma or a space just because the adjacent spreadsheet columns have them. Avoid adding a field to a location where a missing value would leave awkward punctuation or an unexplained blank line.

On Word for Mac, the Mailings tab also provides mail-merge tools, though dialog layouts and some wizard steps can differ from Windows. The same basic process applies: choose a merge type, connect a data source, insert fields, preview, and complete the merge. If you cannot find a command shown in Windows instructions, check the Mailings ribbon and the version-specific Word help rather than assuming the feature is absent.

Preview and check the results

Before producing documents or sending messages, select Mailings > Preview Results. Word replaces the visible placeholders with information from a recipient record. Use the previous and next record controls on the Mailings tab to inspect several entries, including records near the end of the list. Check not just the first record: a long surname, empty field, or unusual address can expose a layout problem that the first row does not.

Look for correct names, spacing, punctuation, line breaks, dates, and page breaks. If a field shows the wrong value, confirm that it is connected to the intended column. If the data itself is wrong, correct the source list and refresh or reconnect it as needed. If the text is right but the layout is not, edit the template and preview again. A small test using a few selected recipients can be safer than immediately processing a large list.

Finish the merge

For letters, choose Mailings > Finish & Merge > Edit Individual Documents to create a new document containing the merged results. You can review and save that output before printing. Choose Print Documents when you are ready to print the selected records directly. In the merge prompts, you can usually choose all recipients, the current record, or a range of records.

For an email merge, choose Mailings > Finish & Merge > Send E-Mail Messages. Select the column containing each recipient’s email address, enter a subject line, and choose a mail format. Word creates a separate personalized message for each selected record rather than one message with all recipients visible to one another. Sending depends on a supported, configured desktop email setup and may also be controlled by workplace policies. Preview and verify the recipient list before sending; a message sent to the wrong address cannot be recalled reliably.

For envelopes or labels, Word uses the selected merge type to set up the page layout. Follow the prompts to choose the envelope or label product and insert address fields in the intended position. Print a test on plain paper first and compare it with the actual stock, since printer feed direction and label alignment can vary.

Common problems and fixes

A field appears instead of a name. Preview Results may be off, or the document may show field codes. Turn on Preview Results to see the recipient value; if needed, use Alt+F9 on Windows to toggle field-code display. On Mac, the keyboard shortcut differs by keyboard and Word settings; use the field-code display command in Word’s menus or help.
Postal codes lose leading zeroes. Format the relevant Excel cells as text before connecting the workbook, then save and close Excel. Reconnect the list if Word continues to show values from an earlier connection.
Dates or numbers look different from Excel. Word may not display a value exactly as it appears in a formatted spreadsheet cell. Check the underlying data and the merged preview. For precise presentation, format the field in Word or prepare a separate text column in the source for the display value.
The address block is incomplete or oddly arranged. Confirm that the source has recognizable, distinct column headings and that the correct fields are mapped in the Address Block options. Insert individual fields if the automatic mapping does not fit the list.
Word cannot find the list or worksheet. Check that the workbook is saved in an accessible location, close it in Excel, and select the correct sheet or data range. A consistent header row and uninterrupted table make the source easier to identify.
There are extra pages or blank lines. Review the template for paragraph marks, page breaks, and spaces around fields. Preview records with missing values as well as completed ones, since an empty field can change the surrounding layout.

Privacy and good sending practice

A merge can expose personal information if the wrong file, recipient column, or output document is used. Store recipient lists and merged results in locations appropriate to the sensitivity of the data, limit access to people who need it, and remove temporary output files when they are no longer required. Before printing or emailing, verify the selected records and inspect a sample of the final output. For workplace or regulated information, follow the organization’s data-handling rules; mail merge itself does not provide a privacy review or guarantee secure delivery.

When another approach makes sense

For a handful of documents, manually editing a copy may be quicker and easier to inspect. For recurring correspondence or a long list, a well-maintained merge template reduces repetitive typing and helps keep the wording consistent. If the task is to send a general announcement rather than individualized messages, a mailing-list or email-marketing service may offer subscription management and delivery reporting that Word does not provide. Choose the method according to the size of the job, the need for personalization, and how recipients’ information must be handled.

Frequently Asked Questions

Can I use Excel as the data source for Word mail merge?
Yes. Save the workbook, close it in Excel, and in Word choose Mailings > Select Recipients > Use an Existing List. Select the workbook and the sheet or range containing the records.

Can Word mail merge create labels?
Yes. Choose Mailings > Start Mail Merge > Labels, select the label vendor and product number, connect the recipient list, and insert the address fields. Preview the sheet and test the printer alignment before using label stock.

Can I send personalized emails with Word?
Yes. Choose E-mail Messages as the merge type, select an email-address column, and use Finish & Merge > Send E-Mail Messages. Word sends an individual message for each selected record through a supported configured email setup.

Does mail merge change my Excel file?
Using a workbook as the recipient source does not mean Word is editing its records. Make corrections in the source workbook when the data needs fixing, and save the merged document separately if you want a reviewable output.

Why does Word show «FirstName» instead of a person’s name?
The document may be showing the merge field rather than its previewed value. Select Mailings > Preview Results, then move through several records to confirm that Word is displaying the correct data.

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.