How to Create a Mail Merge Letter in Microsoft Word

To create a mail merge letter in Word, prepare a recipient list, connect it to a letter, insert fields for details such as each person’s name and address, preview the results, and finish the merge. You will need the desktop version of Word and a clean data source, such as an Excel workbook. The steps below are for Word for Microsoft 365 on Windows; the Mac version follows the same basic process, though some buttons and dialogs may look different.

What You’ll Need

Microsoft Word desktop app: Use the installed version of Word for the full mail merge workflow. Word for the web has limited mail merge support and may not offer the commands needed to create and finish a merge.
A recipient list: An Excel workbook is a convenient source. You can also use a supported contacts list or another data file, but the examples here use Excel.
Your letter text: Write the parts that are the same for everyone before adding personalized fields. Save the document as a Word file.
A little time to check the output: Preview several records and create a merged document for review before printing or distributing the letters.

Step-by-Step

Set up the recipient list. In Excel, put one recipient on each row and one type of information in each column. Use clear column headings in the first row, such as FirstName, LastName, Address, City, State, and PostalCode. Avoid merged cells, blank heading cells, and completely empty rows within the list. Keep names and addresses in separate columns if you want to place them separately in the letter. Save the workbook as an .xlsx file in a location you can find. If the workbook is open in Excel, save and close it before selecting it in Word; this can prevent file-access problems.
Start a letter merge in Word. Open the letter document, or create a new one and type the shared text. On the Windows ribbon, select Mailings > Start Mail Merge > Letters. This tells Word to create a separate letter for every selected recipient. On Mac, open the Mailings tab and use the corresponding Start Mail Merge controls; the labels or dialog layout can differ slightly by release.
Connect Word to your recipient list. Choose Mailings > Select Recipients > Use an Existing List, browse to your Excel workbook, and select it. If Word asks which table or sheet to use, choose the sheet containing the list and confirm that the first row has column headings. If you have named an Excel table, select that table when it appears. Word now uses the records in that source for the merge.
Check which recipients are included. Select Mailings > Edit Recipient List to review the available records. Clear the check box beside anyone who should not receive a letter. You can sort or filter the list in this window, for example to include only one city, but make sure the filters match your intention. Check that the number of selected recipients is reasonable before continuing. If names or rows are missing, return to Excel and confirm the data range and headings.
Lay out the shared letter. Type the greeting, paragraphs, closing, and signature details that are identical for every recipient. Leave the cursor at the place where personalized information belongs. For example, you might put the cursor after Dear and before the comma, or on separate lines where the recipient’s postal address should appear. Review the page layout and line spacing as you would for an ordinary letter; merge fields will take up space in the finished versions.
Insert personalization fields. Click where a detail should appear, then select Mailings > Insert Merge Field and choose the matching column, such as FirstName or City. A field appears in the document and will be replaced with a value from each row. For a standard postal address or greeting, you can use Mailings > Address Block or Mailings > Greeting Line, then use the dialog’s options to choose the format and preview it. These blocks are convenient, but individual merge fields give you more control over spacing and wording. Do not type field names with angle brackets yourself; insert them from the Word menu.
Preview real records. Select Mailings > Preview Results. Word displays the letter with actual information from the list instead of field names. Use the previous and next record arrows on the Mailings tab to check several recipients, including records near the start and end of the list. Look for blank fields, awkward greetings, missing spaces, incorrect address lines, and values that appear in the wrong place. Turn Preview Results off if you need to edit the field layout, then turn it on again to check the changes.
Finish the merge and inspect the letters. When the preview looks right, choose Mailings > Finish & Merge > Edit Individual Documents. Select all records, or specify a range, and confirm. Word creates a new document containing the completed letters. Review the merged document, especially the first and last pages and any records with unusual or incomplete information. Save this new document under a distinct filename so it is clear that it contains the finished letters. You can print from it, or return to Finish & Merge and choose Print Documents if you are ready to print. Keep the original merge template for future updates.

Common Mistakes

Putting multiple pieces of information in one column: A column containing a full address or a combined first and last name can be difficult to personalize cleanly. Split the data into useful fields in Excel when you need to control where each part appears.

Using unclear or duplicate headings: Word uses column headings as field names. Give every column a distinct, descriptive heading, and avoid blank headings. If the wrong sheet or table is selected, the fields you expect may not appear.

Trusting the first preview alone: One recipient may have complete, typical information while another has a long name, missing apartment number, or blank optional field. Check different records, not just the first one.

Formatting special values as ordinary numbers: Postal codes, account-like identifiers, and phone numbers can lose leading zeros or display in scientific notation if Excel treats them as numbers. Store these as text in the source list and inspect their appearance in Word. For dates or numbers, verify the merged display rather than assuming the Excel cell format will carry over exactly.

Printing directly without reviewing the merged file: A field can be positioned correctly in the template but create a badly wrapped line in one recipient’s letter. Create the individual-document output first and scan it before printing a large batch.

Tips

Use consistent, simple headings in Excel, and avoid blank rows inside the recipient list. A clean source is easier to update and reconnect.
Use Address Block for a conventional mailing address, but inspect its preview and use individual fields when your address format needs to be exact.
Write a neutral greeting or provide a fallback in the Greeting Line options if some recipients do not have a usable name. A blank first-name field can otherwise leave an incomplete salutation.
Keep the source workbook, merge template, and final merged document as separate files. This makes it easier to correct the source and regenerate letters without losing the original layout.
For a small test, temporarily select a few records in Edit Recipient List, finish the merge, and inspect the result. Restore the full recipient selection before producing the final batch.
On Mac, the Mailings tab and merge concepts are similar, but the file picker and command placement may vary. If a button is not visible, widen the Word window or look for the command in the Mailings ribbon rather than relying on a Windows-only dialog description.

Troubleshooting

The merge fields are not listed: Recheck the workbook selection and the sheet or table chosen in Word. Confirm that the first row contains headings, that the file is saved, and that the column names are not blank. Close Excel, then reconnect through Mailings > Select Recipients > Use an Existing List. If the list has changed since it was connected, select the source again.

Word shows field names instead of recipient details: Click Mailings > Preview Results. If preview is already on but you see unexpected text, check that you inserted a merge field using Insert Merge Field, not ordinary typed text. Use the record arrows to see whether the current recipient has a value in that source column.

Letters show the wrong people or too many records: Open Edit Recipient List and review the selected check boxes and any filters. Then use Finish & Merge > Edit Individual Documents again with the intended records. Do not assume that a filter applied in Excel automatically controls the Word recipient selection.

Postal codes lose zeros, or dates look wrong: Correct the source values in Excel, format identifiers as text, save, and reconnect the list. If a date is still displayed differently in the merged letter, adjust the formatting in the Word merge field or use a clearly prepared text column in the source. Preview multiple records after making the change.

The merge stops or Word cannot open the list: Save both files locally, close the workbook in Excel, and try connecting again. Check that you have permission to open the file and that it is not being moved or renamed. If the source has unusual formatting or errors, create a fresh workbook with one header row and a continuous block of data, then select that file in Word.

Frequently Asked Questions

Can I use an Excel spreadsheet for a Word mail merge?
Yes. Arrange recipients in rows with one field per column, add headings in the first row, save the workbook, and connect it with Mailings > Select Recipients > Use an Existing List.

Can I create a mail merge letter in Word for the web?
The full letter-merge workflow is designed for the desktop Word app. Use Word for Microsoft 365 on Windows or Mac to connect a data source, insert merge fields, and finish the merge. You can use the web app for other document tasks, but its available merge features may be limited.

How do I make a separate letter for each person?
Choose Mailings > Finish & Merge > Edit Individual Documents, then select all recipients or a range. Word creates one combined document with a separate completed letter for each selected record.

Can I leave out some recipients?
Yes. Before finishing, open Mailings > Edit Recipient List and clear the check boxes for recipients to exclude. You can also use the list controls to filter records, then verify the selected recipients before creating the final letters.

Why is a merge field blank?
The corresponding cell may be empty, Word may be connected to the wrong sheet, or the inserted field may refer to a different column. Check the source row and field name, reconnect the correct list if needed, and preview that recipient again.

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.