How to Mail Merge From Excel to Word, Step by Step

A mail merge from Excel to Word turns one list into many personal documents: a letter, label or email for every row. Excel holds the names and details; Word holds the template and fills in the gaps. Most problems come from the Excel side, such as stray spaces, blank rows and amounts that lose their formatting. This step-by-step guide shows how to prepare the list so the merge works the first time.

How a mail merge from Excel works#

A mail merge has three parts:

1. The data source: your Excel list. Each column is a field (First name, Amount due) and each row is one recipient.
2. The main document: a Word letter, label sheet or email with placeholders called merge fields, such as «First_name».
3. The merge: Word makes one copy of the main document per row and swaps each field for that row's value.

You need the desktop version of Word on Windows or Mac. Excel itself has no merge command; it only supplies the list. Word's Mailings tab does the rest.

Step 1: Prepare the Excel list#

Word reads your sheet as a simple table, so the list has to look like one. Here is a merge-ready list:

Check these points before you open Word:

• Headers in row 1 only, with short, unique names. Word turns them into field names.
• One row per recipient, with no blank rows, subtotal rows or notes in the middle of the list.
• No merged cells. They confuse the column layout.
• One detail per column. Keep first and last names apart so the greeting can say "Dear Maria".
• Clean text. Imported names often have extra spaces or random capitals. In a helper column, =PROPER(TRIM(A2)) turns " maria " into "Maria". TRIM removes the spaces at both ends and doubles in the middle; see the TRIM function guide.

If the list came from another system as a CSV file, open it with the right column types first: the guide to importing a CSV into Excel explains how to keep leading zeros and dates intact. For bigger clean-ups, cleaning messy data in Excel covers duplicates, spaces and inconsistent values.

Save the workbook when the list is ready. Word reads the saved file, so unsaved edits won't appear.

Step 2: Fix money, dates and ZIP codes with TEXT#

Word takes the value stored in a cell, not the format you see. That causes three common surprises:

The ZIP and percentage rows assume extra columns F and G in your list. Add these helper columns next to the originals, give them clear headers like "Amount text", and merge those fields. TEXT turns a number into text that looks exactly the way the format code says. The TEXT function guide lists the codes, and TEXT function formats has a longer cheat sheet. Phone numbers have the same problem; see how to format phone numbers in Excel.

There is a Word-side fix too: right-click a field, choose Toggle Field Codes, and add a format switch such as \# "$#,##0.00". It works, but you have to repeat it for every field and every new template. A helper column in Excel is easier to check.

Step 3: Connect the Excel list in Word#

Open a blank document, or your letter, in Word. Then:

1. Go to Mailings > Start Mail Merge and choose Letters, Email Messages, Envelopes or Labels.
2. Click Select Recipients > Use an Existing List.
3. Browse to your workbook and open it.
4. Pick the sheet that holds the list, and make sure First row of data contains column headers is ticked.

To merge only some rows, click Edit Recipient List. Untick people you want to skip, or use Filter to keep rows that match a condition, such as Amount due greater than 0. The steps are the same in Word for Mac, on the Mailings tab.

Step 4: Insert merge fields and preview#

Write the letter as usual, and wherever a personal detail goes, use Insert Merge Field and choose the column. A reminder letter might read:

Dear «First_name», your balance of «Amount_text» is due on «Due_date_text».

Greeting Line and Address Block insert ready-made combinations of name and address fields. If you'd rather build the full text in Excel, you can join columns there first; see how to combine text in Excel.

Click Preview Results and use the arrows to step through a few records. Check the first row, the last row and any row with a long name or an empty cell. This is where you spot missing spaces, wrong formats and blank fields.

Step 5: Finish the merge#

Click Finish & Merge and choose one of three options:

• Edit Individual Documents creates a new Word file with every letter in it. Use this to check or tweak letters before printing.
• Print Documents sends them straight to the printer.
• Send Email Messages asks which column holds the email address and what the subject line is, then sends one email per row. Word sends through the desktop Outlook app, so Outlook must be set up on your computer.

Before a real email merge, send a test to yourself: make a copy of the list with only your own address in it, merge that, and read the result.

Common mail merge problems and fixes#

Most failed merges have one of these causes:

1. Wrong number format. Amounts show too many decimals or dates swap day and month. Merge a TEXT helper column.
2. Missing leading zeros. Use =TEXT(F2,"00000") or store the codes as text.
3. Blank letters at the end. The list has empty rows that still contain formatting or spaces. Delete the rows below your data.
4. Fields show «First_name» instead of names. Click Preview Results to switch to real data.
5. Odd spacing in names. Run TRIM on the column and copy the clean values over the originals with Paste Special > Values.
6. Word can't see the sheet. The data is on a sheet whose first row isn't the header row. Move the headers to row 1.

Practise it#

A smooth mail merge is really about a clean Excel list. Practise cleaning messy text in a live spreadsheet: you fix spaces and capitals with TRIM, PROPER and SUBSTITUTE, and each formula is checked instantly. Then practise TEXT and VALUE to format amounts and dates inside text, just like the helper columns above.