Mail Merge from Excel to Word: Steps and Fixes

To mail merge from Excel to Word, prepare your recipients in an Excel worksheet, then in the desktop version of Word choose Mailings > Select Recipients > Use an Existing List and connect the workbook. Insert the spreadsheet columns as merge fields, preview the results, and use Finish & Merge to create, print, or send the personalized documents.

What mail merge does

Mail merge combines a template in Word with rows of information in an Excel list. Word treats each row as a separate record and each column as a field. A letter template can therefore use the same wording for every recipient while inserting a different name, address, account number, or other detail in the appropriate places.

For example, an Excel list might have columns named FirstName, LastName, Street, City, and MembershipLevel. A Word letter can begin with a greeting such as “Dear” followed by the FirstName field, and later mention the MembershipLevel field. The merge creates a personalized version for every row without requiring you to copy and edit the letter repeatedly.

Mail merge is useful for form letters, mailing labels, envelopes, certificates, and personalized email messages. It is not a way to combine unrelated documents: it works best when each row represents one recipient or record and each column represents one piece of information about that record.

Prepare the Excel recipient list

Good source data prevents many merge errors. In Excel for Microsoft 365 on Windows, put the column headings in the first row and one recipient in each following row. Keep the list in a single worksheet with no completely blank rows or columns inside the data. Save the workbook as an Excel file, such as .xlsx, before connecting it to Word.

Use short, distinct headings such as FirstName, EmailAddress, and PostalCode. Avoid duplicate headings and blank heading cells.
Keep one type of information in each column. Put a full name in one column or separate first and last names into separate columns, depending on what the template needs.
Remove totals, notes, and extra title rows from the recipient range. If the worksheet has unrelated material, put the mail-merge list on its own sheet.
Check for accidental spaces, misspelled addresses, duplicate recipients, and blank records before starting the merge.
Save and close the workbook before selecting it in Word. This can prevent file-access conflicts and makes it easier to select the intended saved data.

Excel’s display formatting can cause surprises. A postal code such as 00421 may be treated as a number, with the leading zeros removed. Set that column to Text before entering or importing the codes, or store the values in a form that preserves the zeros. Dates and amounts should also be stored as actual Excel dates or numbers when practical, rather than as inconsistent text strings.

Start a mail merge in Word

These steps apply to the desktop version of Word for Microsoft 365 on Windows. Open a new document or the letter you want to reuse, then follow the sequence below:

Choose Mailings > Start Mail Merge and select the document type, such as Letters. For labels or envelopes, choose the corresponding option instead.
Choose Mailings > Select Recipients > Use an Existing List.
Browse to the Excel workbook and open it. If Word asks which table or worksheet to use, select the sheet or named range containing the list. Confirm that the first row contains column headers if the prompt offers that option.
Click where a personalized value should appear. Choose Mailings > Insert Merge Field and select the relevant heading, such as FirstName or City.
Add the rest of the letter’s fixed wording and fields. Use the Address Block or Greeting Line commands if their standard layouts suit your document, or insert individual fields to control the wording yourself.
Choose Mailings > Preview Results and move through several records to check that the fields show the expected values.
Choose Mailings > Finish & Merge and select an output option.

Word for Mac also has a Mailings tab and supports connecting a recipient list and inserting merge fields in the desktop application. Dialog wording or layout may differ slightly from Windows, so follow the prompts shown on your Mac. Word for the web does not provide the full desktop mail-merge workflow; open the document in the desktop Word app to create or run a merge.

Insert fields and check the preview

Merge fields are placeholders, not ordinary text. When you insert a field named FirstName, Word displays a field such as «FirstName» in the template. During the merge, Word replaces that placeholder with the value from the selected Excel row. Do not type the angle-quote marks and field name as plain text; use Insert Merge Field so Word recognizes the placeholder.

Preview more than the first record. Use the record navigation controls in the Mailings tab to inspect later entries, including the last one. Look for missing names, unexpected blank lines, repeated addresses, and values that seem shifted into the wrong fields. A blank field may be correct if the source cell is empty, but it can also reveal a gap in the source data or a selected range that does not include all the intended rows.

For a letter, check the layout as well as the data. Long names or addresses can wrap onto another line, and a short greeting may look awkward if some recipients have no first name. You can edit the template wording or clean the corresponding Excel entries, then preview again. Changes made to the source workbook after connecting may require refreshing or reconnecting the recipient list; save the workbook and check the records in Word before producing the final output.

Choose the right Finish & Merge output

The final command depends on what you want to do with the personalized records. Word’s Finish & Merge menu offers different routes rather than requiring you to save every result in the same format.

Edit Individual Documents: Creates a new Word document containing the merged records. Choose this when you want to review, adjust, or save the complete set before printing.
Print Documents: Sends the merged output to the print workflow. Review the printer settings and record range before confirming.
Send Email Messages: Creates a separate personalized email for each record. Choose the email-address column for the To field and enter a subject line. Check your mail setup and test with a small, controlled list before sending broadly.

For labels, use Mailings > Start Mail Merge > Labels and select the label product or dimensions that match the sheets you will print on. Word lays out a grid of label positions; insert the fields in the first label, then use Update Labels to copy the layout across the sheet. Preview the records and print a test on plain paper first. Hold that page behind a label sheet to verify alignment before using the actual labels.

Fix common formatting and data problems

Dates, currencies, and leading zeros are common sources of confusion because Word may not display an Excel value exactly as it appears in the worksheet. First confirm that the source column contains the intended value and that the selected worksheet is correct. Then check the merged result in Word rather than relying only on Excel’s cell display.

For a date that appears in an unexpected format, you can format the merge field in Word. In Word’s field-code view, a date field can use a switch such as { MERGEFIELD StartDate \@ "MMMM d, yyyy" } to display a value like March 8, 2026. A number field can use a numeric picture switch, for example { MERGEFIELD Amount \# "$#,##0.00" }, to display a value with a dollar sign and two decimal places. Replace the field names with the exact headings in your workbook. Field-code braces are special Word field braces; they are not ordinary typed curly braces. If you are not comfortable editing field codes, use a consistently formatted source column and check the result in Preview Results.

If names or addresses appear in the wrong order, verify the column headings and the fields inserted in the template. If records are missing, check that the correct worksheet or range was selected and that the rows are included. If a blank line appears where an optional field should be, consider adjusting the template layout or cleaning the source data. For example, a second address line that is often empty may need to be handled differently from a line that every recipient must have.

If Word cannot find the workbook, confirm that it still exists at the selected location, is saved, and is not blocked by a permissions or file-access prompt. Reconnect using Select Recipients if the file was moved or renamed. If you have made changes to the workbook, save them and verify the displayed records before you create the final merged document.

Privacy, accuracy, and practical limits

A mail merge can rapidly produce many documents, which makes a small source-data mistake consequential. Before printing or emailing, check the recipient count, inspect a range of records, and make a test output. For a sensitive letter, confirm that confidential fields are mapped to the correct columns and that no unintended recipients are included. Keep the workbook and merged output in locations appropriate for the information they contain, and delete temporary copies when they are no longer needed under your organization’s policies.

Mail merge does not validate whether an email address is deliverable, whether a postal address is current, or whether a value is legally or financially correct. It inserts the data provided. Word also does not turn a spreadsheet into a database: for recurring or complex workflows, you may need stronger controls for permissions, updates, and record history.

One common misconception is that formatting a cell in Excel guarantees the same appearance in Word. It may not: Word can interpret or display a value differently during the merge. Treat Excel as the source of the underlying data, and use Word field formatting or carefully prepared text columns when the exact output matters. Always review the merged document itself.

Frequently Asked Questions

Can I mail merge an Excel file into Word without Outlook?
Yes, if you are creating letters, labels, envelopes, or a merged Word document. Outlook or a compatible mail setup is relevant when you choose Send Email Messages; it is not required just to connect Excel and create printed or editable documents.

Why are leading zeros missing from my merged postal codes?
Excel may have stored the codes as numbers, so it removed the zeros before Word read the data. Store postal codes as text in Excel and check the saved source values. Then reconnect or refresh the list as needed and preview the merged output.

Can I use Excel formulas in the recipient list?
Yes, but check that the workbook is recalculated and saved before connecting it. Word uses the available cell results as merge data; preview the records to confirm that the formula results, rather than an unexpected blank or outdated value, appear in the document.

Can I merge only selected Excel records?
Word provides recipient controls after you connect the list. In Mailings, choose Edit Recipient List to sort, filter, or clear individual records from the merge. Check the resulting recipient selection before choosing Finish & Merge.

Can I do mail merge in Word for the web?
The full mail-merge creation and execution tools are in desktop Word, not Word for the web. Open the file in Word for Microsoft 365 on Windows or Word for Mac to connect the Excel list and run 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.