How to Mail Merge from Excel to Word

By the end of this tutorial, Word will write a personalized letter to every person in your Excel spreadsheet: names, amounts, dates, all filled in automatically. Ten customers or a thousand, same five minutes. It also covers the formatting fix most tutorials skip, which is the exact spot where most people give up.

Set up the spreadsheet correctly

The spreadsheet decides whether this goes smoothly. Three rules:

1. Row one is your column headers, and nothing else. No title above it, no blank rows under it.
2. One row per person.
3. No merged cells anywhere.

Headers like FirstName, AmountDue, and DueDate become the buttons you’ll click in Word, so name them something you’ll recognize.

One more thing that trips everyone: close Excel before you go to Word. If the file is open, Word can’t read it and gives you a useless error.

Connect Word to your spreadsheet

Everything happens on Word’s Mailings tab, and you only need three buttons on it.

1. Start Mail Merge → Letters.
2. Select Recipients → Use an Existing List, and browse to your spreadsheet.
3. Word asks which sheet: take Sheet1, and make sure “First row of data contains column headers” is checked.

Nothing visible happens when you click OK. That’s normal. Word is now connected; it just doesn’t celebrate.

Write the letter and insert merge fields

Paste in your letter text. Everywhere the letter should say something personal, put a merge field instead:

1. Click where the name goes, then Insert Merge Field → FirstName. The chevrons («FirstName») are Word saying “I’ll swap this out for each row.”
2. Do the same for AmountDue and DueDate.
3. Mind the spaces around fields: “Dear «FirstName»,” needs a space after “Dear” like any normal word.

Preview, and spot the problem

Click Preview Results and the codes turn into real people. Arrow through a few records: each one is a different letter.

You’ll also spot the problem: a customer who owes $1,234.50 gets a letter that says “1234.5”, and the date may have a timestamp stuck to it. Nobody’s sending that. The fix is the part that matters.

Fix currency and date formatting (the part everyone misses)

Right-click the amount field and choose Toggle Field Codes. Now you can see what Word actually stores: MERGEFIELD AmountDue. Add a formatting instruction (called a switch) after the field name:

{ MERGEFIELD AmountDue \# "$#,##0.00" }

That pattern means: dollar sign, thousands separator, always two decimals. Toggle the codes back and refresh the preview: $1,234.50, with the comma and both decimals.

Same move for the date:

{ MERGEFIELD DueDate \@ "MMMM d, yyyy" }

Now the preview shows “May 14, 2026”, written out, no timestamp. Two switches. Memorize them or bookmark this page, and your merges stop looking like spreadsheet leaks.

Finish and merge

The last button is Finish & Merge. Three options: print directly, send as email if Outlook is wired up, or (the recommended one) Edit Individual Documents. That creates a brand-new document, one letter per page, every name, amount, and date filled in, which you can eyeball before anything goes out the door.

That’s the whole manual method: clean spreadsheet, three buttons on the Mailings tab, merge fields, two formatting switches, finish and merge.

The honest assessment

The Word wizard is free and it genuinely works. The costs are all in the details: the spreadsheet rules, the field-code switches, and the fact that none of it travels with your data. When the numbers change next month, you reconnect, re-check, and re-merge, and if a new column sneaks in or a header changes, the fields break quietly.

If you run a merge once or twice a year, stop here. You have everything you need.

The MergeNinja way: upload the spreadsheet

If you do this regularly, MergeNinja replaces the wizard part:

1. Upload your Excel or CSV file. You map the columns once: tell it which column is the name, which is the amount, which is the date.
2. Upload your Word template. Same .docx, same merge-field idea: you’ve already built it.
3. Merge. The run happens in the background and the finished documents arrive in your email.

Two things get better. First, no field-code switches: your company’s date and currency format settings control how amounts and dates render, once, for every template. Second, the template and mapping are saved, so the next batch is upload, merge, done.

And if your customer data doesn’t live in a spreadsheet at all, if it’s sitting in QuickBooks Online or Stripe, you can skip the export step entirely and sync it directly.

If that sounds like your situation, you can create a free account and try it for seven days, no card required to start.