Mail Merge in Excel: Complete Guide (2026)

What Mail Merge Actually Does (And Why People Get It Wrong)

Mail merge takes a list of data — names, addresses, order numbers, anything you can put in columns — and stamps each row into a personalized document. One spreadsheet, hundreds of letters. Or emails. Or shipping labels. You write the template once. Word does the rest.

Here's where people stumble. They open Excel, type their data, then hunt for a "Mail Merge" button somewhere in the ribbon. It's not there. Excel holds the data. Word performs the merge. Outlook (on the desktop) sends the emails. Three apps, one workflow. If you've been searching excel tutorials looking for a hidden mail merge command, that's why you can't find it.

The data flow looks like this. Your Excel file holds rows of recipients. Word opens that file as a "data source." Each placeholder in your Word document (a "merge field") points to a column in Excel. When you finish the merge, Word generates one output per row — either as printed pages, a saved document, or sent emails.

Mail merge handles four document types out of the box: letters, envelopes, labels (Avery sheets and most generics), and email messages. The setup is nearly identical for each — pick the type at the start, and Word adjusts the layout rules. Form letters are the most common. Email merges are the most powerful. Labels are the trickiest because spacing matters.

Worth knowing upfront: mail merge to email only works with the desktop Outlook app, not Outlook on the web and not Gmail. If your office runs on Google Workspace, you'll need a different route (covered later). And the email version requires Outlook to be your default mail handler on that machine — if you've never opened desktop Outlook on your computer, Word won't have anywhere to send the messages.

Step 1 — Prep Your Excel List the Right Way

The whole merge stands or falls on this step. Clean spreadsheet in, clean merge out. Messy spreadsheet, messy everything. Spend ten minutes here and you'll save an hour of debugging later.

Open a fresh workbook. Put your column headers in row 1 — and only row 1. No title row above them, no merged cells, no "Customer List for Q3" banner spanning A1:F1. Word reads row 1 as the field names; anything fancy up there breaks the merge. Use single-word or underscored headers when you can: FirstName, LastName, OrderTotal, ShipCity. Spaces are tolerated but emoji and special characters cause weird display bugs.

Below row 1, one record per row. No blank rows in the middle. If you have a blank row, Word treats it as a recipient and ships a half-empty letter to nobody. Filter and delete blank rows before saving. Same goes for blank columns — they confuse the field picker later.

Now the formatting trap. If you have ZIP codes, phone numbers, currency, dates, or anything where the display format matters, format those columns as text before typing data, or use a leading apostrophe. ZIP code 02134 typed into a number-formatted cell becomes 2134. Date "5/3/2026" stored as a real date will render in Word as "5/3/2026 12:00:00 AM" because Word reads the underlying serial. Save yourself the headache: format as text, or build a helper column with TEXT(A2,"mm/dd/yyyy") and merge from that.

One sheet, named clearly. If your workbook has six tabs, Word will ask which one — and the sheet names show up exactly as you saved them, dollar signs and all ("Sheet1$"). Rename to something obvious like "Recipients" so future-you doesn't pick the wrong tab. For more spreadsheet hygiene tricks, the keyboard shortcut to delete row in excel and the separate first and last name in excel tutorials cover the two prep tasks most mail merge users need.

Save the file as .xlsx. Not .xls. Not .csv (Word can read CSV but loses formatting hints). Close the workbook before starting the merge — Word can't read an open file in some Office versions and will throw a vague "cannot connect to data source" error.

Step 2 — Connect Word to Your Spreadsheet

Open Word. Blank document. Head to the Mailings tab in the ribbon. If you don't see it, you're either in Word Online (which doesn't support mail merge) or on a version of Word older than 2007 (upgrade). The Mailings tab is where the entire workflow lives.

Click Start Mail Merge — it's the second button from the left. Pick your document type from the dropdown: Letters, E-mail Messages, Envelopes, Labels, or Directory. For our walkthrough, pick Letters. The other types follow the same steps with minor layout tweaks.

Now click Select Recipients → Use an Existing List. A file browser opens. Navigate to your .xlsx and double-click. Word pops a dialog asking which sheet — pick the one with your data ("Recipients$" if you renamed it). Critically, leave the First row of data contains column headers checkbox ticked. Click OK.

Nothing visible happens. That's normal. Word silently linked your document to the Excel file in the background. You can verify the connection by clicking Edit Recipient List — a window opens showing every row. Use the checkboxes to exclude rows you don't want, or use the column filters to send only to specific groups ("State = TX", "OrderTotal > 100"). This is where you do the last sanity check before merging.

If you ever change the Excel file mid-merge — add rows, fix a typo — Word doesn't auto-refresh. Close and reopen the document, or click Edit Recipient List → Refresh. Skip this and your merge will use the stale data.

What if you don't have an Excel file yet?

Word can build one for you. Select Recipients → Type a New List opens a small form-based editor. Fine for ten people. Terrible for a thousand — Excel is faster and more flexible. If you started without a list and want to upgrade, save the typed list as a .mdb, then export. Or just rebuild in Excel; usually faster than fighting the small editor.

Step 3 — Insert Merge Fields and Preview

Type your letter as you normally would. When you reach a spot that needs personalization — "Dear ___," — leave the cursor there and click Insert Merge Field. A dropdown shows every column from your Excel file. Pick FirstName. A grey-shaded placeholder appears: «FirstName». Type the comma and a space, then keep writing.

Repeat for every spot that needs data. Order number? Insert «OrderNum». Shipping address? Insert «Address1», a new line, «City», comma, space, «State», space, «Zip». You can use the same field as many times as you want — there's nothing wrong with «FirstName» appearing four times in one letter if that's natural.

One trick worth learning: Address Block and Greeting Line. Those two buttons next to Insert Merge Field are pre-built combinations. Address Block stacks the address fields in standard postal format and even handles missing data gracefully (skips blank rows instead of leaving gaps). Greeting Line gives you "Dear Mr. Smith," with formatting options. Both save typing if your fields are named conventionally.

Now hit Preview Results. The «FirstName» placeholders swap for real names. Use the < and > arrows in the ribbon to step through each recipient. Look at row 1, row 50, and the last row at minimum. If your Excel had a typo in row 47, this is when you catch it — fix in Excel, refresh the recipient list, preview again.

This is also when date and number formatting issues surface. If "5/3/2026" displays as "43955" in the letter, you didn't format the date column as text in Excel. Bail out, fix the spreadsheet, restart. Don't try to fix it in Word — the field-switch syntax for date formatting is ugly (\@ "MMMM d, yyyy") and breaks on machines with different regional settings.

Mail Merge for Email — The Outlook Bridge

Email merge is identical to letter merge until the final step. Start Mail Merge → E-mail Messages instead of Letters. Select your Excel file. Compose the email body in Word. Insert merge fields like normal — «FirstName» in the greeting, «OrderNum» in the body, whatever you need.

The new piece: one of your Excel columns must hold email addresses. Name that column "Email" or "EmailAddress" — Word looks for the column by header name when you reach the final step.

Click Finish & Merge → Send E-mail Messages. A dialog asks three things. To: pick the column with email addresses (the dropdown shows your headers). Subject line: type the subject — this is plain text, not a field, but you can manually insert field syntax like <<FirstName>>'s order shipped if you want personalization (advanced trick). Mail format: HTML keeps your formatting; Plain Text strips it; Attachment sends each letter as a .docx file.

Click OK. Word hands every message to Outlook. Outlook queues them in the Outbox. They send in order, usually within a minute. The catch: if Outlook isn't already running, Word launches it silently and a permission popup may appear — click Allow within 10 seconds or the merge fails halfway through. Don't walk away during a big send.

Worth knowing: there's no "undo" once Word hands the batch to Outlook. If you discover a typo after sending, you're recalling messages one by one. Always send a test run to yourself first. Filter your recipient list to one row (your own email), do the merge, check the output, then remove the filter and re-merge.

Why email merge fails (most common reasons)

Outlook isn't the default mail handler — Windows Settings → Default Apps → Email → set to Outlook. Outlook isn't activated/signed in — open it once, complete setup. Word and Outlook aren't from the same Office installation — mixing Office 2019 Word with Microsoft 365 Outlook breaks the bridge. You're on a Mac with Outlook for Mac — works, but the dialog is slightly different and HTML formatting is less reliable.

Conditional Fields — IF, THEN, ELSE Inside Word

Conditional fields are mail merge's hidden power. They let one template handle multiple scenarios without splitting your list. Example: if the OrderTotal is over $100, the letter says "Thanks for your generous order!" — otherwise it just says "Thanks for your order!" One document, two outcomes, zero copy-paste.

Insert one through Mailings → Rules → If…Then…Else. A dialog asks for three pieces. Field name: the Excel column you're testing (e.g., OrderTotal). Comparison: equal, not equal, greater than, less than, is blank, is not blank. Compare to: the value (e.g., 100). Then type the text for the true outcome and the text for the false outcome. Click OK. Word inserts the rule at your cursor; previewed output shows the appropriate text per row.

Real-world uses pile up fast. Show "Mr." or "Ms." based on a Gender column. Display "Premium member" badge only for customers with Tier = Gold. Skip the discount paragraph entirely when DiscountCode is blank. Hide the shipping section for digital-only orders. Each rule is one If…Then…Else; nest them by inserting one rule inside another's true/false text.

Two other Rules worth knowing. Skip Record If drops a recipient from the merge entirely based on a condition — useful for excluding test rows or opted-out customers without editing your spreadsheet. Next Record If moves to the next row when a condition is met — mostly for advanced label and directory layouts.

The rules engine has limits. No AND/OR combinations (workaround: nest rules). No math operations (workaround: compute in Excel, merge the result). No regex. If your logic needs more than three nested IFs, you're outgrowing mail merge and should look at a real templating tool or Python script. For most users, three nested rules covers 95% of needs.

Fixing the Errors Everyone Hits

Five errors cover 90% of mail merge frustration. Know them, debug fast, move on.

Dates show as ##### or a serial number

Word reads the underlying Excel date (a number like 43955) instead of the formatted display. Fix in Excel: add a helper column with =TEXT(A2,"mm/dd/yyyy") and merge from that column instead. Don't try to fix in Word — the date-switch syntax breaks across regional settings.

Currency loses decimals or shows the wrong currency symbol

Same root cause as dates — Word reads the raw number. Helper column with =TEXT(B2,"$#,##0.00") solves it. For Euro, Pound, Yen, use the appropriate symbol in the format string.

ZIP codes drop leading zeros

02134 becomes 2134. Format the ZIP column as Text before typing, or prefix with an apostrophe ('02134). If your data is already corrupted, use =TEXT(C2,"00000") to pad back to five digits.

"Word found a problem opening the data source"

Three common causes: the .xlsx file is open in Excel (close it), the file path has special characters (rename to ASCII), or the file is on a network drive that's temporarily disconnected (copy locally and retry).

Recipient list is empty or missing rows

You either picked the wrong sheet (rerun Select Recipients), or your spreadsheet had blank rows that Word treated as the end of data (delete the blanks, save, refresh). Click Edit Recipient List → Refresh to force-reload.

Email merge sends nothing

Check Outlook's Outbox — messages may be stuck waiting to send. Confirm Outlook is your default email handler (Windows Settings → Default Apps). For Office 365 setups, both Word and Outlook must be from the same install — mixing standalone Office and click-to-run versions breaks the connection. For more Excel troubleshooting tips, see the excel reference guide and the excel pivot tables walkthrough — both cover related data-prep issues that affect merge quality.

Mac, Power Automate, Excel-Only, and Workarounds

Mail merge on Mac works but feels older. Word for Mac has the same Mailings tab and the same six-step flow, but the dialogs are slightly different and the email merge sometimes fails silently if Outlook for Mac isn't fully configured with an active account. The fix: open Outlook for Mac once, send a test message to yourself, then retry the merge. Mac users also lose access to a few advanced rules — Skip Record If is reliable, but complex nested If…Then…Else sometimes renders blank in the output.

For Excel-only "mail merge" — no Word involved — you have two options. Power Automate can trigger a flow when a new row is added to a spreadsheet, pull the row data into a templated email, and send through Outlook 365 automatically. Setup takes 20 minutes the first time; recurring sends are zero-touch after that. The other route is VBA. A 30-line macro can loop through rows in a sheet and call Outlook.Application to send personalized emails. Search "send email from excel vba" for ready-made templates; paste, edit the columns and template, run.

Google Workspace users — Gmail and Sheets — can't use Word's mail merge at all. Best alternatives: the free "Yet Another Mail Merge" add-on for Sheets (sends up to 50 emails/day free, more with paid tiers), Mailchimp with a Google Sheets connector, or a Google Apps Script (free, unlimited, technical). Don't try to round-trip Sheets → Excel → Word — the formatting gymnastics aren't worth it.

If you need attachments per recipient (e.g., personalized PDF invoices), native mail merge can't do it. The Mail Merge Toolkit add-in ($24) adds this feature to Word. Alternatively, use Power Automate or a Python script with openpyxl and smtplib for full control. For sending hundreds of invoices monthly, the upfront tooling investment pays back in a week.

Last tip: for any recurring merge job, save the Word template (with all fields and rules inserted) as a .docx in a known folder. Next month, open the template, point Select Recipients at the updated Excel file, and you're ready to merge in 30 seconds. Reusing templates is the closest mail merge gets to true automation without a developer.