How to Mail Merge in Word: Step-by-Step Guide

To mail merge in Word, prepare a recipient list in Excel, open Word and choose Mailings > Start Mail Merge, connect the list with Select Recipients, add merge fields, preview the records, and choose Finish & Merge. A mail merge creates a separate personalized letter, label, envelope, or email for each person using information from a data source.

What You’ll Need

A desktop version of Microsoft Word for Microsoft 365. The instructions below use Word on Windows; the Mac notes explain the main differences.
A recipient list, commonly an Excel workbook. Give each column a clear heading such as FirstName, LastName, Address, or Email. Put one recipient in each row.
A Word document containing the text or layout you want to personalize. You can also start a new blank document while setting up the merge.
For an email merge, a configured desktop email app that Word can use to send messages, plus an email address for every recipient. Sending a test message first is strongly recommended.

Step-by-Step

Prepare the recipient list. In Excel, put the field names in the first row and one person’s information in each following row. Keep each type of information in its own column: for example, use separate FirstName and LastName columns rather than a single full-name column. Remove completely blank rows and columns, check spelling, and make sure every recipient has a value in any field you plan to use. Save the workbook as an .xlsx file. If the workbook has multiple sheets, keep the merge list on a clearly named worksheet. Close the workbook before connecting it to Word to reduce file-access problems.
Choose the type of merge in Word. Open or create the document that will become the template. Select the Mailings tab, choose Start Mail Merge, then select the output type: Letters, E-mail Messages, Envelopes, or Labels. For a standard personalized letter, choose Letters. For labels, Word will ask you to choose the label product and size; confirm these match the labels loaded in your printer.
Connect your recipient list. On the Mailings tab, choose Select Recipients > Use an Existing List. Browse to the Excel workbook and open it. If Word asks which table or sheet to use, select the worksheet containing your list and confirm that the first row contains column headers. If you need a smaller group, use Edit Recipient List to uncheck recipients or sort and filter the records. Check that the displayed recipient count looks plausible before continuing.
Write the template text. Type the parts that will be the same for everyone, such as the greeting, message, sign-off, and return address. Leave the cursor where a person’s details should appear. For a letter, you might type “Dear ” and then insert the recipient’s first name. Avoid typing a name directly where you intend to insert a field; the point is for Word to fill that space separately for each record.
Insert the merge fields. Put the cursor at the insertion point, select Mailings > Insert Merge Field, and choose the matching column heading, such as FirstName or City. Repeat for each personalized detail. You can also use Address Block or Greeting Line on the Mailings tab to insert a formatted address or salutation, then choose the options that fit your list. A field appears in the template as a placeholder, not as the person’s actual information. Add normal punctuation and spaces around fields where needed.
Preview the records. Select Mailings > Preview Results to see the first recipient’s details in the document. Use the left and right record arrows on the Mailings tab to inspect several people, including the first and last entries. Check names, spacing, addresses, punctuation, and page breaks. If a detail is wrong, turn off Preview Results, correct the source list or field placement, and preview again.
Finish the merge. Choose Finish & Merge on the Mailings tab. For a print job, select Print Documents; for a reviewable combined file, choose Edit Individual Documents and select which records to include. Word creates a new document with the merged results, which you can inspect and save before printing. For email, select Send E-mail Messages, choose the email-address column in the To box, enter a subject line, and select a mail format. Send a test to yourself or a small checked group first. In the dialog, choose the records to send and confirm before proceeding.

On a Mac: Word for Mac also has a Mailings tab with mail-merge commands, though their placement and available options can differ slightly from Windows. Start the merge from the Mailings tab, select or create a recipient list, insert fields, and preview before completing it. If a command is not visible, check the Mailings tab or Word Help for your installed version. Email merges depend on the email app and account configuration on the Mac; if sending is unavailable, create the merged documents and send them through your normal email workflow instead.

Common Mistakes

Missing or unclear headers: Word uses the first row as field names. Blank, duplicate, or cryptic headings make it harder to choose the right field. Use unique labels without unnecessary punctuation.
Putting multiple recipients in one row: Each row should represent one record. Do not put several people in the same cell or separate recipients with commas in one row.
Assuming the preview is the final output: Preview Results shows records in the template, but it does not replace checking the completed merged document. Review a few pages from the result before printing a large batch.
Overlooking Excel formatting: Leading zeros in postal codes, long numbers, dates, and currency can display differently after a merge. Store codes that need leading zeros as text, and check how dates and amounts appear in Word. If necessary, correct the source data or apply suitable formatting to the merge field.
Sending without checking recipients: A wrong email-address column or an unfiltered list can send personal information to unintended people. Confirm the To field, recipient selection, subject, and sample message before sending.
Editing only the merged result: Changes made to the finished output do not automatically update the original template or recipient list. Keep the source files and make reusable corrections in the template or list.

Tips

Use a simple, well-organized Excel table for the source list. Clear headers and consistent data make field selection and later updates easier.
Use Edit Recipient List to filter or exclude records rather than deleting rows from the source workbook when you only need a one-time subset. You can also select only the records you want during the final merge.
Save the Word template separately from the merged output. A useful file naming pattern is “Notice template” and “Notice merged November,” so you can distinguish the reusable source from the finished batch.
For labels, complete the first label and use Update Labels on the Mailings tab to copy the layout and required next-record fields across the sheet. Preview the full page and print a test on plain paper to compare alignment before using label stock.
For a letter or envelope, use Word’s page layout and address tools to position fields. Print one sample on ordinary paper and check it against the actual paper or envelope before producing the entire batch.
When names or dates need special treatment, make the source values consistent first. For example, if names need a preferred form of address, create a dedicated Salutation column instead of relying on Word to infer it from a full name.

Troubleshooting

Word cannot find the workbook: Confirm that it is saved locally or somewhere you can access, close it in Excel, and try Select Recipients > Use an Existing List again. If the file is stored in a cloud folder, make sure it has finished syncing and that you have permission to open it.

Fields are missing or have the wrong names: Reconnect the correct sheet and verify that its first row contains headers. Save changes to Excel, close the workbook, and reconnect it if you renamed columns after selecting the data source. If the wrong worksheet was selected, use Select Recipients to choose the intended list.

Every record shows the same person: Turn off Preview Results and check that the correct list is connected. Then use the record arrows to move through entries. If the data itself repeats, inspect the Excel rows; if it is correct there but not in Word, reconnect the source and confirm the worksheet range includes all recipient rows.

Numbers or dates look wrong: First check the source cell and its underlying value. Postal codes that begin with zero should be stored as text or otherwise prepared so the zeros are retained. For dates and currency, use consistent source data and inspect the merged document; Word may not carry over Excel’s display formatting exactly. Correct the source or field formatting, then generate a new merge to verify the result.

Email sending fails or no email option appears: Confirm that a compatible desktop email app is installed, configured with an account, and available to Word. Try a one-record test and verify that the selected To field contains valid email addresses. If the command remains unavailable, finish the merge to documents and use your email service’s approved method to distribute them.

Frequently Asked Questions

Can I mail merge from an Excel spreadsheet into Word?
Yes. In Word, choose Mailings > Select Recipients > Use an Existing List and select the workbook. Choose the worksheet that contains the recipient records, then insert fields matching its column headings.

Can I use a Word document as the recipient list?
Word can use a structured recipient list, but Excel is usually easier to maintain. If you use another supported data source, make sure it has clearly named fields and one recipient per record, then connect it through Select Recipients.

How do I mail merge only selected people?
Choose Mailings > Edit Recipient List and clear the check boxes beside people you want to exclude. You can also sort or filter the list, or specify a record range when you finish the merge.

Can I save the merged letters as separate files?
Finish & Merge > Edit Individual Documents creates one new document containing the selected merged records. Word does not automatically save each record as a separately named file through that command; separate-file workflows may require additional tools or manual saving.

Can I undo a mail merge email after sending it?
No. Once Word has handed the messages to the email system, you generally cannot recall them reliably. Check the recipient list, address field, subject, and test message before sending the full batch.

Do I have to print the merged document immediately?
No. Choose Finish & Merge > Edit Individual Documents to create an output document you can inspect, edit, and save before printing. Keep the template and recipient list too, especially if you may need to repeat 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.