How to Create a Mail Merge Template in Microsoft Word

Create a mail merge template by starting a mail merge in Word, building the letter or other document, and inserting fields that match columns in a recipient list. You will need Word for desktop, a clean data source such as an Excel workbook, and a saved template. When the fields are connected, preview a few records and finish the merge to create personalized documents.

What You’ll Need

Microsoft Word for desktop: The steps below are for Microsoft 365 on Windows. Word for Mac has similar mail merge features, with small differences noted below. Word for the web does not provide the full desktop mail merge workflow.
A recipient list: An Excel workbook is a common source. Put one recipient in each row, with descriptive column headings in the first row, such as FirstName, LastName, Address, City, and Email.
A place to save your files: Keep the Word template and data source in a folder you can find again. Word may need the original data file when you reopen the template.
Your message or layout: Draft the wording, decide where personalized details should appear, and gather any logo or other content you want in the document.

Step-by-Step

Prepare and save the recipient list. Open the list in Excel and check that every column has a clear heading in the first row. Keep each person or organization on one row, and place only one kind of information in each column. For example, put first name and last name in separate columns if you want to greet people by first name. Remove completely blank rows above the headings, merged cells, notes, and subtotals. Save the workbook as an .xlsx file in the folder you chose. If a value such as a ZIP or postal code can begin with zero, format that column as text before entering or importing values; otherwise Excel may remove the leading zero.
Create the document that will become your template. Open Word and choose Blank document, or open an existing document you want to adapt. Write the parts of your letter that are the same for everyone: return address, date, greeting text, message, closing, and signature. Leave clear spaces for changing details. Save the file with a recognizable name, such as Spring_Invitation_Template.docx. Saving early makes it easier to distinguish the reusable template from the individualized documents you create later.
Choose the type of merge. On Windows, open the Mailings tab, select Start Mail Merge, and choose the document type, such as Letters. Choose Letters for a separate personalized document for each recipient. Other available types include email messages, envelopes, and labels; the layout and final steps differ for those types. In Word for Mac, use the Mailings tab and its Start Mail Merge controls; the exact arrangement may differ slightly by version.
Connect the recipient list. In Windows Word, go to Mailings > Select Recipients > Use an Existing List. Browse to the Excel workbook and select it. If Word asks which table or sheet to use, choose the worksheet that contains the list and confirm that the option indicating the first row contains column headers is selected. Review the recipient list in the selection window if available, and exclude test rows or people who should not receive the document. On Mac, select the existing list from the Mailings ribbon and browse to the workbook; prompts for the worksheet or table may look different.
Insert a greeting or address block if useful. Click in the document where the recipient information should appear. On the Mailings tab, select Address Block to insert a formatted address, or Greeting Line to create a salutation. Follow the dialog previews to choose a format and handle missing names. These tools can save time, but inspect the result carefully: the preview depends on how your column headings and data are organized. You can instead insert individual fields for more control.
Insert individual merge fields. Click where a changing value belongs, then select Mailings > Insert Merge Field and choose the matching column heading. For example, insert FirstName after “Dear” and LastName where the recipient’s surname should appear. Add City or another field in the body if needed. Repeat for every personalized value. Use Word’s Insert Merge Field menu rather than typing field names or typing angle brackets yourself; fields inserted through the menu are connected to the data source. Add spaces and punctuation around fields in the document, because the merge does not automatically add them.
Check the document’s appearance and field placement. Make sure the cursor was in the right place before each field was inserted. A greeting might read “Dear ” followed by the FirstName field and a comma. An address might use separate fields on separate lines. Use paragraph breaks and spacing as you would in a normal Word document. If you inserted an Address Block or Greeting Line, use its options to adjust the format rather than adding a second version of the same information. Save the document again after making layout changes.
Preview multiple recipients. Select Mailings > Preview Results to show real values in place of the fields. Use the previous and next record arrows on the Mailings tab to inspect different people, including the first, a middle record, and the last. Check for empty greetings, unexpected spaces, missing punctuation, long names that wrap awkwardly, incorrect addresses, and values that look like dates or numbers in an unwanted format. Turn Preview Results off if you need to see the field names again, then correct the template or source list and preview once more.
Complete a small test before producing the full merge. If the list includes a test recipient, preview that record first. For a letter, choose Mailings > Finish & Merge > Edit Individual Documents to create a separate merged document, then choose the records to include if Word offers that option. Review the resulting document before printing or sharing it. When you are satisfied, run the merge for the intended records. Use Print Documents to send the results to a printer, or Edit Individual Documents when you want to review and save a combined document containing the personalized copies. The original template remains reusable; save the merged output under a different name.
Save the template and make it easy to reuse. Save the Word file after confirming that it still contains merge fields, not just a finished set of names. Keep the Excel source in a stable location. When you reopen the template, Word may ask you to confirm or reconnect to the list; follow the prompt and select the correct workbook. To use a new list next time, select a new recipient source and check that the new column headings match the fields the template uses. If they do not match, insert the new fields or update the list headings before merging.

Common Mistakes

Typing field names instead of inserting fields. Text such as «FirstName» typed from the keyboard is not necessarily a working merge field. Insert fields from Mailings > Insert Merge Field.
Using unclear or inconsistent headings. A heading such as “Name” is ambiguous if you need both first and last names. Use distinct headings, and do not rename a source column without checking how the template uses it.
Leaving extra rows in the source. A blank row, old test contact, or totals row can become an empty or incorrect merged document. Check which recipients are selected before finishing.
Skipping the preview. A field can be technically connected but still appear in the wrong place or produce an awkward greeting. Inspect several records, not only the first one.
Overwriting the reusable file. Finish and save merged results as a new document. If you replace the template with a document containing fixed recipient details, you may lose the reusable fields.

Tips

Make the template work with real-world variations. Some entries may have a blank company name, a long surname, or no optional detail. Avoid writing sentences that become confusing when a field is empty. If necessary, keep optional information on its own line or remove incomplete records before merging.
Use simple, stable column headings. Names such as FirstName and PostalCode are easier to identify than headings with symbols or long descriptions. Keep the heading row in the first row of the worksheet and do not leave blank headings between used columns.
Check formatting in the merged output. Phone numbers, postal codes, dates, and amounts can display differently from how they look in Excel. Format the source data appropriately, and use the merged preview and final document to confirm the result rather than assuming the source cell’s display will carry over exactly.
Keep a clean master list. Make a copy of the recipient workbook before removing records or changing data for a particular mailing. That helps preserve the original list and makes it simpler to correct a mistake later.
For an email merge, verify the sending setup first. Choose Email Messages as the merge type, make sure the source includes an email-address column, and use the email field when Word asks which column contains addresses. Word sends individual messages rather than one message with every recipient visible. Check the message and recipient selection carefully before sending; email merge availability and sending behavior can depend on the installed Outlook setup.

Troubleshooting

Word cannot find the workbook or asks for a data source. The file may have moved, been renamed, or become unavailable. In the Mailings tab, use Select Recipients to choose the correct workbook again. If you share the template with someone else, give them the data file too; a link to a file on your computer will not automatically work on theirs.
One or more fields are missing from the Insert Merge Field menu. Check that the worksheet has a heading in the first row and that the correct worksheet was selected. Close the workbook if Word has trouble reading it, then reconnect from Word. Avoid merged heading cells or blank column names, and save the workbook before reconnecting.
The merged document contains blank lines or incomplete names. Find the affected source rows and correct or remove incomplete entries. A field can only show information that exists in its corresponding cell. If a whole line is optional, a simple line break in the template may leave a blank line when the source cell is empty; adjust the wording or data layout and preview again.
Numbers or dates look wrong. Check how the value is stored in Excel, not only how the worksheet appears. Postal codes with leading zeros should be stored as text. For date or numeric fields, adjust the source data or the field formatting, then preview the results again. If Word has already created a merged document, correct the source or template and run a fresh merge rather than editing every copy by hand.
Every page shows the same recipient, or fields remain visible. Confirm that Preview Results is enabled when checking names, and use the record arrows to move between recipients. When creating output, use Finish & Merge and choose the records you intend to merge. If the finished file still shows field names, reopen the template, reconnect the list, and complete the merge through Word rather than printing the template itself.
The labels or addresses do not line up. For labels, choose the correct label type and product under the label setup options, then use Update Labels where available to copy the first label’s layout to the others. Print a test on plain paper and compare it with the label sheet before using actual labels. Printer scaling or margins can affect alignment even when the Word layout is correct.

Frequently Asked Questions

Can I create a mail merge template without Excel?
Yes. Word can use another supported recipient source, such as an Outlook contact list, or you can create a simple list through Word’s recipient-list options. Excel is often convenient because its columns are easy to edit and review. Whichever source you use, make sure each recipient is a separate record and the fields have clear headings.

Can I reuse the same Word mail merge template?
Yes. Save the Word document while it still contains the merge fields, and keep the linked recipient list available. The next time you use it, reconnect to the correct source if Word asks, check the recipients, and preview the records again. Different lists may have different headings, so confirm that every template field has a matching column.

Does Word save the personalized letters into separate files automatically?
Not by default through the usual Finish & Merge options. Edit Individual Documents creates a new document containing the selected merged records, while Print Documents sends them to a printer. If you need one file per recipient, you will need a separate workflow or tool to split the merged output.

Can I use a mail merge for labels?
Yes. Choose Mailings > Start Mail Merge > Labels, select the label vendor and product number, connect the recipient list, and insert fields in the first label. Use Update Labels to replicate the layout across the sheet, then preview and print a plain-paper test before printing on label stock.

Can Word mail merge send personalized emails?
Yes. Choose Email Messages as the merge type, connect a list with an email-address column, write the message, and use merge fields where personalization is needed. Complete the merge through the email option and carefully check the recipient field and message before sending. Email merge requires a compatible email setup, and sending is not the same as creating a draft for each person.

Can I make a mail merge in Word for the web?
The full mail merge creation and finishing workflow is available in desktop Word, not Word for the web. Open the document in the desktop app to connect a source, insert fields, preview records, and finish the merge. You can then save the resulting document and use supported web features to view or share it.

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.