How to Mail Merge From Excel to Word: A Complete Guide

Mail merge is one of those features that sounds intimidating until you understand what it actually does — and then it becomes indispensable. If you've ever needed to send the same letter, label, or email to dozens (or hundreds) of people with personalized details, mail merge is the tool that makes it possible without copy-pasting endlessly.

What Is Mail Merge, and Why Does Excel Play a Role?

Mail merge is a process that combines a fixed template document with a data source to produce multiple personalized outputs. Word handles the template and formatting. Excel handles the data — names, addresses, account numbers, dates, or whatever fields you need to personalize.

The two programs work together through a linked data connection. Word reads each row of your Excel spreadsheet as one record, then generates a separate version of your document for each row, swapping in the relevant values wherever you've placed merge fields.

The result: one template, potentially thousands of unique, personalized documents.

Setting Up Your Excel Data Source the Right Way

Before you open Word, your Excel spreadsheet needs to be structured correctly. This step is where most problems originate.

Key rules for your Excel data source:

• Row 1 must be your header row — these column names become your merge field labels in Word (e.g., FirstName, LastName, Address, City)
• Each subsequent row is one record — one letter, one label, one email
• No blank rows or merged cells — these confuse the merge process
• Keep data in a single, contiguous table — avoid gaps between columns
• Format cells as plain text where needed — ZIP codes starting with zero, for example, can lose their leading zero if stored as numbers

Your column headers can be descriptive but should avoid spaces if possible. First_Name is safer than First Name, though Word handles both in most cases.

Save and close the Excel file before connecting it to Word. Some versions of Word require exclusive access to the file during the merge process.

How to Start the Mail Merge in Word

Open a blank document (or an existing template you want to personalize) in Microsoft Word.

Step 1: Launch the Mail Merge Wizard Go to the Mailings tab in the ribbon. Click Start Mail Merge, then choose your document type:

• Letters — for printed or PDF correspondence
• Email Messages — for sending directly via Outlook
• Labels — for address labels or sticker sheets
• Envelopes — for printing directly on envelopes
• Directory — for lists and catalogs where all records appear in one document

Step 2: Connect to Your Excel File Click Select Recipients, then choose Use an Existing List. Navigate to your Excel file and select it. Word will prompt you to choose which sheet to pull from — select the tab where your data lives. You'll see a preview of your records in the confirmation dialog.

Step 3: Insert Merge Fields Place your cursor in the document where you want personalized data to appear. Click Insert Merge Field in the Mailings ribbon and choose from the column headers you set up in Excel. Fields appear in your document wrapped in double chevrons like this: «FirstName»«LastName».

You're not limited to one field per line — you can combine them: Dear «FirstName», or «Address1», «City», «State» «ZIP».

Previewing and Filtering Records 🔍

Before generating your final output, use the Preview Results button in the Mailings tab. This replaces the field placeholders with actual data so you can check that names, addresses, and formatting all look right.

Preview controls let you:

• Step through each record individually
• Check for formatting issues (extra spaces, missing commas)
• Spot data problems in your Excel sheet before they multiply across hundreds of documents

You can also filter or sort recipients before completing the merge. Click Edit Recipient List to:

• Exclude specific rows (uncheck individual records)
• Filter by a column value (e.g., only records where State equals CA)
• Sort alphabetically by last name or any other field

This filtering capability is useful when your Excel sheet contains a master list but you only need a subset for a particular mailing.

Completing the Merge

Once your template looks right and your recipients are set, click Finish & Merge. You'll have three options:

For email merges, you'll be asked to specify which column contains the email addresses and what the subject line should be. Word sends one email per record, each personalized.

Variables That Affect How Smoothly This Works

The mail merge process is consistent in principle, but several factors shape the experience in practice:

• Office version — The Mailings tab interface and available options differ slightly between Office 2016, 2019, Microsoft 365, and the Mac versions of Word
• Data complexity — Simple name-and-address merges are nearly frictionless; merges involving conditional logic (e.g., showing different paragraphs based on a field value) require IF field rules and more setup time
• Email vs. print output — Email merges depend entirely on Outlook being installed and properly connected to your mail account; browser-based email clients aren't supported natively
• Data formatting in Excel — Dates, currency, and numbers often need explicit formatting rules in Word's merge fields to display correctly (e.g., { MERGEFIELD Date @ "MMMM d, yyyy" })
• Record volume — Merging 50 letters behaves differently in terms of processing time and file size than merging 5,000

When Merge Fields Don't Display Data Correctly 🛠️

A common frustration: numbers and dates show up in raw format (like 44927 instead of January 15, 2023). This happens because Excel stores dates as serial numbers internally, and Word inherits that raw value.

The fix is adding a field switch directly in the merge field code. Right-click a merge field, choose Toggle Field Codes, and add a formatting switch after the field name. For dates, @ "MMMM d, yyyy" is a common format. For currency, # "$#,##0.00" formats a number as dollars and cents.

These switches are consistent across Word versions but require familiarity with field syntax — something many users encounter only when something looks wrong in their output.

Whether a basic merge takes you five minutes or requires troubleshooting depends heavily on how clean your Excel data is, which version of Office you're running, and how complex your template needs to be. The mechanics are standardized, but the path through them looks different depending on what you're starting with.