How to Create a Mail Merge Template in Microsoft Word

Create a reusable mail merge template in Word by preparing a recipient list, building a document on the Mailings tab, and inserting merge fields where personalized details should appear. You can preview the finished copies, then print them, save them as separate documents, or send them by email. Word for Microsoft 365 on Windows is covered below; the desktop Mac version has similar options, while Word for the web does not provide the full mail merge workflow.

A mail merge template is the main document that holds your shared text and placeholders, such as a recipient’s name or address. Word combines it with a separate data source, commonly an Excel workbook or Outlook contacts, to create a personalized copy for each person. Keep the template and the recipient list as separate files so you can reuse the document with updated data.

What You’ll Need

Word for Microsoft 365 desktop: Mail merge tools are available in the Windows and Mac desktop apps. If you only have Word for the web, open the document in the desktop app to create or run the merge.
A recipient list: An Excel workbook is a practical choice. Give each kind of information its own column, such as FirstName, LastName, Email, Street, City, and PostalCode. Put the column names in the first row, with one person or organization per following row.
Your text and intended output: Decide whether you are making letters, envelopes, labels, or email messages. Have the shared wording ready, and know which details need to change for each recipient.
A place to save both files: Keep the Word template and data source in a folder you can find again. If you move or rename the workbook later, Word may need you to reconnect it.

Step-by-Step

Prepare the recipient data. In Excel, make a simple table with one header row and one recipient per row. Use clear, unique headers without blank columns between fields; for example, FirstName, LastName, Email, and Company. Check that every row has the right information and remove test records you do not want in the merge. Format postal codes, account-like identifiers, or other values with leading zeros as text if Excel would otherwise remove those zeros. Save and close the workbook before connecting it to Word. This reduces the chance of selecting an unfinished or outdated list.
Start the main document in Word. Open a new blank document and draft the parts that will be identical in every copy, such as a logo, heading, greeting punctuation, message, and sign-off. On the ribbon, choose Mailings > Start Mail Merge, then select the document type: Letters for a standard letter, E-mail Messages for email, Envelopes for envelope addressing, or Labels for sheets of labels. Choosing the right type matters because Word changes the layout and available setup options accordingly. For a general reusable letter, choose Letters.
Connect the recipient list. Select Mailings > Select Recipients > Use an Existing List. Browse to the Excel workbook, select it, and choose Open. If Word asks which sheet or table to use, select the one containing your headers and recipient rows. Confirm the option that indicates the first row contains column headers, if it appears. Word may show a recipient list window; scan it to ensure the expected names appear, then confirm. You can also select recipients from Outlook or create a new list from the Select Recipients menu, but an existing Excel list is easier to maintain for many workflows.
Write the shared text and place personalization fields. Click where a variable detail should appear, then choose Mailings > Insert Merge Field and select the matching column name. For example, write Dear, insert the FirstName field, then type a comma and continue the letter. Insert Street, City, and PostalCode fields into an address block as needed. A field is a placeholder, not the final value; Word fills it from the matching row when you preview or complete the merge. Type spaces and punctuation around fields yourself. Avoid adding a space after a field if the next text already begins with one, or the output may have doubled spacing.
Build a complete address block or greeting when useful. You may use Mailings > Address Block or Mailings > Greeting Line to insert a formatted group of fields. Follow the dialog to choose the preferred format, then use the matching-fields option if Word cannot recognize a column automatically. Preview the result before relying on these shortcuts: headers such as GivenName may not map automatically to First Name. In a simple letter, inserting individual fields gives you precise control over layout and punctuation.
Check the connection and preview several records. Choose Mailings > Preview Results to replace field placeholders with real recipient data on screen. Use the next and previous record arrows on the Mailings ribbon to review more than the first person. Check long names, missing values, address wrapping, punctuation, and any details that differ in length. Use Mailings > Check for Errors if available in your Word build to identify problems before completing the merge. Turn Preview Results off when you need to adjust the field layout.
Filter or sort recipients if needed. Select Mailings > Edit Recipient List to deselect people, sort a column, or filter the records included in this run. For example, filter a Region column to make letters for one area, or uncheck a test row. Apply filters carefully and verify the first and last records in the preview so you do not accidentally omit intended recipients. The source workbook remains your master list; recipient selections control the current merge.
Complete the merge. Select Mailings > Finish & Merge. Choose Edit Individual Documents to create a new Word document containing the merged copies and inspect or adjust them before printing. Choose Print Documents to send the results to a printer, or select Send E-mail Messages for an email merge. Email merging requires an email field in the recipient list and a configured email account in Outlook. For a first run, editing individual documents is usually the safest option because you can review the actual output before sending or printing.
Save the reusable template and the merged output separately. Save your main document with its merge fields intact. To reuse it as a Word template, choose File > Save As > Browse, set Save as type to Word Template (*.dotx), and save it in a known folder. When you open a .dotx template, Word creates a new document based on it, leaving the template itself unchanged. You can also save the connected main document as a regular .docx if you prefer to open and edit that same file. Save the completed merged document under a different name so it does not replace your reusable source.

On Word for Mac, use the Mailings tab for the desktop mail merge tools; the exact arrangement can vary by version. If the ribbon is hidden, show it from Word’s ribbon controls. Some older Mac versions use a Mail Merge Manager instead. The Windows steps above are not available in the same way in Word for the web, so use the desktop app to set up and finish a merge.

Common Mistakes

Using unclear or inconsistent headers: Headers such as Name or Field1 make it harder to identify the right data. Use descriptive names and keep them in the first row. Avoid blank header cells and merged cells in the data range.
Putting two details in one column: A FullName field may be difficult to format if you need different greetings. Separate first and last names when the document needs to address people by first name, and keep street, city, and postal code in distinct columns when you need to control the address layout.
Expecting a merge field to add formatting automatically: Word inserts the value from the source, but it does not know how you want to handle spacing, punctuation, or missing information. Review a record with an empty field as well as one with a long value.
Editing the data after connecting without checking: If you add columns or change headers in Excel, Word may not show the updates in the current connection. Save and close the workbook, then reconnect or refresh the recipient list as needed.
Sending or printing without a final review: Previewing one person is not enough to catch an unusual address or blank entry. Review multiple records and, when practical, use Edit Individual Documents to inspect the merged output before distribution.
Saving over the wrong file: The main document, reusable .dotx template, recipient workbook, and completed merge have different purposes. Give them distinct, recognizable file names and save the finished output separately.

Tips

Use a dedicated folder for the template and data source. Stable file locations make it easier for Word to find the recipient list when you reopen the main document.
Include a few realistic test records in a copy of the workbook, including a long company name, a missing optional value, and a postal code with a leading zero. Preview these before using the full list.
Keep the source list tidy: one header row, no totals row, no blank rows inside the records, and consistent formats for dates and numbers. This makes it easier to select the correct range and interpret the results.
For a reusable template, add a short note outside the final letter text or in a separate instruction file explaining which workbook to connect and which fields the document expects. Remove any internal instructions from the customer-facing content before merging.
When the same template will be used by colleagues, share the data-source location and explain that they should choose the correct worksheet when prompted. Test the template from the location where others will open it.
For labels, select the label product and layout through Mailings > Start Mail Merge > Labels before inserting fields. Use Update Labels to copy the first label’s layout across the sheet, then preview the page to check alignment and whether records flow correctly.

Troubleshooting

Word cannot find the workbook: Use Mailings > Select Recipients > Use an Existing List and browse to its current location. If the workbook was moved, renamed, or stored on a drive that is unavailable, reconnect it. If the sheet is not listed, open the workbook in Excel, confirm the data is saved, and close it before trying again.

The field list is missing or shows unexpected columns: Check that the first row of the selected worksheet contains the intended headers and that the recipient data is on that same sheet. Reconnect the correct workbook or worksheet. If you changed the headers after the initial connection, reconnect the list so Word reads the updated structure.

Preview shows «FirstName» instead of a name: Preview Results may be turned off, or the field may not be a real merge field. Select Mailings > Preview Results. If the placeholder remains, delete it and insert the field again using Mailings > Insert Merge Field.

Names or addresses appear in the wrong places: Check that the selected worksheet and recipient records match the headers you used, then compare a previewed row with the same row in Excel. Use Edit Recipient List to confirm the right records are selected. For address blocks or greeting lines, use the matching-fields control to assign each Word field to the correct source column.

Leading zeros disappear or dates look wrong: Format the relevant Excel column appropriately before connecting it. Postal codes and identifiers that must retain leading zeros are usually best stored as text. For dates, use a consistent date format in the source, then verify several merged examples; if the display is still unsuitable, adjust the field’s formatting in Word or make a clearly formatted text column in the source list.

The labels do not line up: Confirm the label manufacturer and product number in the Labels setup, then check the printer’s paper size and label stock. Use Update Labels after arranging the first label, and print a test page on plain paper to compare alignment before using label sheets.

Frequently Asked Questions

Can I create a mail merge template without Excel?
Yes. Word can use Outlook contacts, a new list created from the recipient-selection tools, or another supported data source. Excel is useful when you need to edit many records or share a structured list.

Can I reuse the same Word mail merge template?
Yes. Save the main document as a .dotx template or keep a separate .docx master with its merge fields. Reconnect or select the current recipient list each time, then preview the records before completing the merge.

Can I send a mail merge as individual emails?
Yes. Choose E-mail Messages as the merge type, include an email-address column, and select Finish & Merge > Send E-mail Messages. Word uses Outlook to send the messages, so confirm the account, recipient field, subject line, and output before sending.

Can I make each merged letter a separate file?
Word’s standard Edit Individual Documents option creates one new document containing the selected merged records. It does not automatically save each record as its own file. You can split and save the results afterward, or use a suitable add-in or carefully designed automation if separate files are essential.

Will the merge fields appear when I print?
Normally Word prints the merged values, not the field names. Use Preview Results to check what the output will contain, then choose Print Documents or print the completed document created by Edit Individual Documents.

Why can’t I find Mail Merge in Word for the web?
Word for the web has limited mail merge support and does not provide the full desktop workflow for creating and completing a merge. Open the document in Word for Microsoft 365 on Windows or Mac to connect a recipient list 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.