How to Do a Mail Merge from Excel to Word — Complete Step-by-Step Guide (2026)
What Is a Mail Merge?
A mail merge combines two things:
- A data source — your Excel spreadsheet containing the variable information (names, addresses, amounts, etc.)
- A Word template — your document with placeholders where the variable data should appear
When you run the merge, Word reads every row in your Excel file and creates a separate, personalized document for each one — automatically replacing the placeholders with the actual data from that row.
Common mail merge use cases in the USA:
- Personalized letters to clients or customers
- Address labels for mass mailings
- Envelopes with recipient addresses
- Invoices or statements with individual amounts
- Certificates or awards with names and dates
- Form letters for HR, legal, or compliance
- Event invitations with personalized details
- Collection notices or payment reminders
Part 1 — Prepare Your Excel Data Source
The quality of your mail merge depends entirely on how well your Excel data is organized. Spend a few minutes setting this up correctly and the rest of the process will go smoothly.
Step 1 — Open a new Excel workbook
Create a new .xlsx file that will serve as your data source. This is the file Word will pull information from.
Step 2 — Set up your column headers in Row 1
Your first row must contain column headers — these become the field names you'll insert into your Word template. Use clear, descriptive names with no spaces (use underscores if needed).
Good column header examples:
| First_Name | Last_Name | Address | City | State | ZIP | Amount | Date | | John | Smith | 123 Main St | Chicago | IL | 60601 | $1,250.00 | May 15, 2025 | | Sarah | Johnson | 456 Oak Ave | Houston | TX | 77001 | $875.00 | May 15, 2025 | | Michael | Williams | 789 Pine Rd | Phoenix | AZ | 85001 | $2,100.00 | May 15, 2025 |
Step 3 — Data formatting rules (critical for USA users)
- No merged cells — merged cells break mail merge completely
- No blank rows — Word stops reading at the first blank row
- No blank columns between data columns
- Dates — format as text ("May 15, 2025") or Excel will export raw date numbers
- Currency — format cells as Currency before saving so "$1,250.00" appears correctly
- ZIP codes — format as Text to preserve leading zeros (00501 not 501)
- Phone numbers — format as Text to preserve formatting (555-123-4567)
Step 4 — Save your Excel file
Save the file as .xlsx format in a location you'll remember. Do not move or rename the file after connecting it to Word — the connection will break.
Step 5 — Close the Excel file
Word needs the Excel file to be closed before it can connect to it as a data source. Close Excel completely before starting the mail merge in Word.
Part 2 — Set Up Your Word Template
Step 1 — Open Microsoft Word and create your document
Write your letter, label template, or form exactly as you want it to appear — leaving blank spaces where the personalized data will go.
Example letter template:
[Date]
Dear [First_Name] [Last_Name],
We are writing to inform you that your account balance of [Amount]
is due on [Due_Date].
Please send payment to:
[Address]
[City], [State] [ZIP]
Thank you for your continued business.
Sincerely,
The Billing Team
The words in brackets are where you'll insert mail merge fields — they'll be replaced by the actual data from your Excel file.
Step 2 — Go to the Mailings tab
In Word, click on the Mailings tab in the ribbon. This is where all mail merge controls live.
Step 3 — Click "Start Mail Merge"
Click Start Mail Merge and choose your document type:
- Letters — for personalized letters (most common)
- Email Messages — for personalized emails sent directly from Outlook
- Labels — for address labels (Avery, etc.)
- Envelopes — for addressed envelopes
- Directory — for lists and catalogs
Part 3 — Connect Word to Your Excel File
Step 1 — Click "Select Recipients"
In the Mailings tab, click Select Recipients → Use an Existing List.
Step 2 — Browse to your Excel file
Navigate to the .xlsx file you created in Part 1 and click Open.
Step 3 — Select your sheet
Word will ask which sheet in the Excel file to use. Select the sheet containing your data (usually Sheet1) and make sure "First row of data contains column headers" is checked. Click OK.
Word is now connected to your Excel data. You'll see the mail merge controls become active in the ribbon.
Step 4 — Filter recipients (optional)
Click Edit Recipient List to:
- Uncheck specific rows you don't want to include
- Sort by any column (e.g., by State or ZIP code)
- Filter to only include certain rows (e.g., only customers in Texas)
Part 4 — Insert Mail Merge Fields Into Your Document
This is where you place the Excel column data into your Word template.
Step 1 — Click where you want the data to appear
Place your cursor in the document exactly where the first piece of data should go — for example, right after "Dear ".
Step 2 — Click "Insert Merge Field"
In the Mailings tab, click Insert Merge Field and select the column name from your Excel file (e.g., "First_Name").
Word inserts a merge field that looks like this: «First_Name»
Step 3 — Repeat for all fields
Continue clicking through your document and inserting the appropriate merge fields everywhere you need personalized data.
Your finished template should look like this:
Dear «First_Name» «Last_Name»,
Your account balance of «Amount» is due on «Due_Date».
Please send payment to:
«Address»
«City», «State» «ZIP»
Step 4 — Preview your merge
Click Preview Results in the Mailings tab. Word replaces the field codes with actual data from your first Excel row. Use the arrow buttons to flip through different records and make sure everything looks correct.
Part 5 — Complete the Mail Merge
Step 1 — Click "Finish & Merge"
In the Mailings tab, click Finish & Merge and choose:
- Edit Individual Documents — creates one Word document with all merged letters (one per page). Best for reviewing before printing.
- Print Documents — sends all merged documents directly to the printer
- Send Email Messages — sends personalized emails via Outlook (requires Outlook to be set up)
Step 2 — Choose which records to merge
Select All to merge every row, Current record for just the one you're previewing, or a specific range of rows.
Step 3 — Save your merged document
If you chose "Edit Individual Documents", save the resulting file. It will contain all your personalized letters — one per page — in a single Word document.
How to Mail Merge from Excel to Word for Labels
Printing address labels is one of the most common mail merge tasks for USA businesses. Here's the specific process for labels:
Step 1 — Go to Mailings → Start Mail Merge → Labels
Step 2 — In the Label Options dialog:
- Choose your label vendor (Avery is most common in the USA)
- Select your product number (e.g., Avery 5160 for standard address labels)
- Click OK
Step 3 — Connect to your Excel file (same as Part 3 above)
Step 4 — Click Address Block in the Mailings tab This inserts a pre-formatted address block field that automatically combines name, street, city, state, and ZIP in the correct US address format.
Or manually insert fields:
«First_Name» «Last_Name»
«Address»
«City», «State» «ZIP»
Step 5 — Click Update Labels to apply the layout to all labels on the page
Step 6 — Preview and then Finish & Merge → Print Documents
Most popular Avery label sizes for US mail:
- Avery 5160 — 1" x 2-5/8" (30 labels per sheet) — standard address
- Avery 5163 — 2" x 4" (10 labels per sheet) — shipping labels
- Avery 5167 — 1/2" x 1-3/4" (80 labels per sheet) — return address
How to Mail Merge from Excel to Word Without Microsoft Office
Don't have Microsoft Word? Or want a faster, simpler process? Our free browser-based Excel to Word converter handles mail merges without requiring any Microsoft Office software.
How to use our free mail merge tool:
- Go to mergeexcelfiles.org/excel-to-word
- Upload your Excel data file
- Upload your Word template (or create one using our editor)
- Map your Excel columns to the template placeholders
- Click Merge and download all your personalized documents
Why USA users prefer this method:
- ✅ No Microsoft Office license required
- ✅ Works on any computer — Mac, Windows, Chromebook
- ✅ Files never uploaded to a server — 100% private
- ✅ No signup required
- ✅ Handles letters, labels, and certificates
Common Mail Merge Problems and How to Fix Them
Problem 1 — Numbers showing as raw values (e.g., 45000 instead of $45,000.00)
Cause: Excel stores dates and currency as numbers internally. Word displays the raw number.
Fix: Format the cells in Excel as Currency or Date before connecting. Or use Word field switches:
- For currency:
{ MERGEFIELD Amount \# "$#,##0.00" } - For dates:
{ MERGEFIELD Date \@ "MMMM d, yyyy" }
To edit a field switch: right-click the merge field → Toggle Field Codes → edit the code → right-click again → Toggle Field Codes.
Problem 2 — ZIP codes losing leading zeros (06001 becomes 6001)
Cause: Excel treats ZIP codes as numbers.
Fix: Format the ZIP column as Text in Excel before entering data. Or use the field switch: { MERGEFIELD ZIP \# "00000" }
Problem 3 — "Word could not re-establish a DDE connection"
Cause: The Excel file is open while Word is trying to connect.
Fix: Close Excel completely, then try connecting again in Word.
Problem 4 — Mail merge fields showing as {MERGEFIELD First_Name} instead of the data
Cause: Field codes are being displayed instead of field results.
Fix: Press Alt + F9 to toggle between field code view and field result view.
Problem 5 — Extra blank pages between letters
Cause: An extra paragraph mark at the end of your template is being included in every merged document.
Fix: Place your cursor at the very end of your document and delete any extra blank lines or paragraph marks.
Problem 6 — Only first row of Excel data is merging
Cause: The Excel file has a blank row somewhere in the data, or the sheet name has special characters.
Fix: Check your Excel file for any blank rows and delete them. Make sure your sheet name is simple (e.g., "Sheet1").
Mail Merge from Excel to Word — Tips for USA Business Users
Tip 1 — Use a dedicated data sheet Keep your mail merge data on a separate sheet named "MailMergeData" — never on a sheet with formulas or pivot tables.
Tip 2 — Test with 5 rows first Before running a merge for 5,000 records, test with just 5 rows to make sure the formatting and fields are correct.
Tip 3 — Save your template separately Save your Word template as a separate .dotx file. That way you can reuse it next month without rebuilding from scratch.
Tip 4 — Use conditional fields for salutations Instead of "Dear John," you can set up conditional logic: { IF «Gender» = "F" "Dear Ms." "Dear Mr." } «Last_Name»,
Tip 5 — Verify addresses before printing labels For large label runs, use USPS address verification to clean your Excel data before merging — this prevents wasted label sheets from bad addresses.
Frequently Asked Questions
How do I do a mail merge from Excel to Word?
Prepare your Excel data with headers in row 1, open Word, go to Mailings → Start Mail Merge → Letters, click Select Recipients → Use an Existing List, browse to your Excel file, insert merge fields into your document, preview, and click Finish & Merge.
Can I mail merge from Excel to Word without Microsoft Office?
Yes — use our free tool at mergeexcelfiles.org/excel-to-word. Upload your Excel file and Word template, map the fields, and download the merged documents. No Office license required.
How do I mail merge from Excel to Word for labels?
In Word, go to Mailings → Start Mail Merge → Labels. Select your Avery label size, connect your Excel file, insert the Address Block field or individual fields, click Update Labels, then Finish & Merge → Print.
Why is my mail merge showing numbers instead of dates?
Excel stores dates as serial numbers. Use a Word field switch to format them: right-click the date merge field → Toggle Field Codes → add \@ "MMMM d, yyyy" after the field name.
How many records can I mail merge at once in Word?
Word can handle thousands of records in a single mail merge. For very large merges (10,000+ records), consider splitting the Excel file into batches to avoid performance issues.
How do I mail merge from Excel to Word on a Mac?
The process is identical on Mac. Open Word for Mac, go to the Mailings tab, and follow the same steps. Make sure your Excel file is closed before connecting it as a data source.
How do I send mail merge emails from Excel through Word?
Go to Mailings → Start Mail Merge → Email Messages. Write your email template, connect your Excel file, insert merge fields, then Finish & Merge → Send Email Messages. Word sends through Outlook — make sure Outlook is configured on your computer.
Can I preview the mail merge before printing?
Yes — click Preview Results in the Mailings tab. Use the left/right arrows to flip through each record and verify the merge looks correct before printing or saving.
Quick Reference — Mail Merge Checklist
Before starting your mail merge, make sure:
- ☑️ Excel file has column headers in Row 1
- ☑️ No merged cells in the Excel data
- ☑️ No blank rows in the Excel data
- ☑️ Dates formatted as text or properly formatted cells
- ☑️ ZIP codes formatted as Text
- ☑️ Excel file is saved and closed
- ☑️ Word template has placeholders where data should go
- ☑️ Tested with 5 rows before running full merge
Final Thoughts
Mail merge from Excel to Word is one of the most time-saving skills any USA business user can learn. Once you've set up your Excel data source and Word template correctly, you can generate hundreds or thousands of personalized documents in under a minute — letters, labels, envelopes, invoices, certificates, and more.
The key to a smooth mail merge is clean Excel data — proper headers, no blank rows, correctly formatted dates and numbers. Get that right and the rest of the process is straightforward.
Need a faster way? Try our free tools — no Microsoft Office required:
- 🔗 Excel to Word Converter — mail merge without Microsoft Office
- 🔗 Merge Excel Files — combine multiple workbooks instantly
- 🔗 Split Excel Files — split workbooks by sheet
- 🔗 VBA Macro Generator — automate Excel tasks in plain English
- 🔗 AI Excel Assistant — ask any Excel or mail merge question
Last updated: May 2026 | MergeExcelFiles.org — Free Excel Tools for USA Users
Tags
how to do a mail merge from excel to word mail merge from excel to word how to mail merge from excel to word mail merge excel to word how do you mail merge from excel to word how can i mail merge from excel to word mail merge from excel to word labels mail merge from excel mail merge excel excel to word mail merge word mail merge mail merge labels excel mail merge without microsoft office how to mail merge mail merge step by step mail merge avery labels excel mail merge data source mail merge envelopes excel free mail merge tool mergeexcelfiles.org