Mail Merge From Excel to Word (Easy Step-by-Step Guide)

This guide shows you how to mail merge from Excel to Word using the desktop version of Word. You will prepare a clean recipient list, place fields in a letter, preview every record, finish the merge, and fix the formatting problems Word commonly exposes.

Prepare the Excel file before opening Word

Most mail merge problems begin in the spreadsheet. Give Word a plain, rectangular list before you design the letter.

1. Use the first row for column headings such as FirstName, LastName, Address1, City, PostalCode, DueDate, and Amount.
2. Give every column a unique heading. Short names without punctuation are easiest to recognize in Word.
3. Put one recipient on each row. Do not use a second row for the same person's address or notes.
4. Remove blank rows and columns from the middle of the list. Word may treat a blank row as an empty recipient.
5. Remove merged cells, subtotals, and decorative titles. Keep those in a separate sheet.
6. Check formula cells for errors such as #N/A and #VALUE!. Word will not repair them.
7. Store postal codes, account numbers, and IDs as text when leading zeroes matter. Set the cells to Text before entering the values.
8. Keep dates as real Excel dates and amounts as numbers. You can control their printed appearance in Word later.
9. Save the workbook, note the worksheet name, and close Excel. Closing it avoids a locked-file or stale-data prompt when Word connects.

If the workbook has several sheets, put the final list on one clearly named sheet. Each heading should describe the data beneath it, and each column should contain one kind of value.

How to mail merge from Excel to Word, step by step

These menu names are from desktop Word.

1. Start the main document

1. Open a blank Word document or the letter template you want to reuse.
2. Open the Mailings tab.
3. Choose Start Mail Merge → Letters.
4. Write the text and set the margins, fonts, logo, header, and footer now.
5. Save this file as the main mail merge document.

2. Connect the Excel recipient list

1. Choose Mailings → Select Recipients → Use an Existing List.
2. Select the saved Excel workbook and choose Open.
3. In the Select Table window, choose the worksheet that contains the list.
4. Leave First row of data contains column headers selected.
5. Choose OK.
6. Open Edit Recipient List to sort, filter, or clear any rows that should not be included.

Worksheet names usually appear with a dollar sign, such as Recipients$. That is normal. If no usable sheet appears, save the workbook as .xlsx, close Excel, and attach it again.

3. Insert the merge fields

1. Click where the first changing value should appear.
2. Choose Mailings → Insert Merge Field.
3. Select the matching Excel heading, such as FirstName.
4. Type spaces, commas, line breaks, and labels outside the merge fields.
5. Repeat until every variable value is placed.

An address can be assembled from individual fields so you control every line:

«FirstName» «LastName»
«Address1»
«City», «State» «PostalCode»

Address Block and Greeting Line are shortcuts, but they depend on Word matching your headings correctly. Individual fields are easier to diagnose when an address is missing a part.

4. Preview more than the first record

1. Choose Mailings → Preview Results.
2. Use the arrow buttons in the ribbon to move through recipients.
3. Check the first, a middle, and the last record.
4. Look for blank fields, doubled spaces, broken address lines, long names, and values with the wrong format.
5. Use Find Recipient when you need to inspect a particular row.
6. Choose Preview Results again to return to the field view and make corrections.

Do not edit a name or amount in the preview. Correct the Excel source, save it, then use Edit Recipient List → Refresh or reconnect the workbook.

5. Finish and inspect the merge

1. Save the main document again.
2. Choose Mailings → Finish & Merge → Edit Individual Documents.
3. Select All, or enter a record range for a small test.
4. Choose OK. Word creates a new document containing the completed letters.
5. Check page breaks, headers, footers, amounts, and the last record in that new document.
6. Print or save the completed document only after that check.

Choose Print Documents instead when you want to send the result directly to a printer. Choose Send Email Messages only when the recipient list includes an email column and Outlook is configured.

Fix dates that appear as 46095

Excel stores a date as a serial number and displays it through a cell format. Word may receive the stored value without that display format.

1. In Word, press Alt+F9 to show field codes.
2. Find the date field, such as { MERGEFIELD DueDate }.
3. Change it to { MERGEFIELD DueDate \@ "MMMM d, yyyy" }.
4. Press Alt+F9 again, then press F9 to update the field.
5. Preview several records.

The braces must be Word field braces. Do not type new braces with the keyboard; press Ctrl+F9 if you need to create a field.

If Word still shows a serial number, add a helper column in Excel with =TEXT(G2,"mmmm d, yyyy") and merge that text column instead.

Fix 1,250.00 when Word shows 1250

The comma and decimal places are Excel formatting. Add a numeric picture switch in the Word field:

1. Press Alt+F9.
2. Change { MERGEFIELD Amount } to { MERGEFIELD Amount \# "#,##0.00" }.
3. For dollars, use { MERGEFIELD Amount \# "$#,##0.00" }.
4. Press Alt+F9, press F9, and preview the result.

If a currency symbol varies by row, keep the symbol in its own Excel column or create a finished text column there.

Fix 7.5% when Word shows 0.075

Excel stores 7.5% as 0.075. Tell Word to print the fraction as a percentage.

1. Press Alt+F9.
2. Change { MERGEFIELD Rate } to { MERGEFIELD Rate \# "0.0%" }.
3. Press Alt+F9, press F9, and preview several rows.

A reliable Excel alternative is a helper column with =TEXT(H2,"0.0%"). Merge the helper column, not the raw percentage.

Fix formatting that disappears after the merge

Word does not copy an Excel cell's font, color, number format, or alignment. Format the merge field in the Word main document.

1. Turn off Preview Results.
2. Select the complete merge field, including the field name and its chevrons.
3. Apply the font, size, bold, color, or paragraph alignment in Word.
4. Use a \# switch for numbers and a \@ switch for dates.
5. Preview again and test more than one record.

Changes made in the newly merged output affect that output only. Make reusable corrections in the original main document, then run Finish & Merge again.

Fix missing headers and footers

Headers and footers belong to Word sections. Copying only the visible body of a completed letter into a blank file leaves them behind.

1. Return to the original main mail merge document.
2. Add the letterhead, page number, and footer with Insert → Header or Insert → Footer.
3. Confirm that the merge type is Letters.
4. Run Finish & Merge → Edit Individual Documents again.
5. Do not create separate letters by copying only their body text into blank documents.

If the header appears on some pages but not others, open the header and check Different First Page, Different Odd & Even Pages, and Link to Previous. Those section settings decide which header each page uses.

What Word creates at the end

A mail merge from Excel to Word produces one long output document when you choose Edit Individual Documents. Each row is merged, but Word does not save each row as an independent file. The menu wording refers to individually merged records inside the new document, not separate files on disk.

If one file or PDF per row is the actual requirement, see the guides to mail merge into separate Word files and mail merge into individual PDFs. For a deeper explanation of field switches and helper columns, read why mail merge changes numbers and dates.