How to Do a Mail Merge for Labels From Excel

Mail merge is one of those features that sounds technical but saves enormous amounts of time once you understand what's actually happening. If you've got a spreadsheet full of names and addresses in Excel and need to print labels — for holiday cards, shipping, event invites, or anything else — this process is built exactly for that job.

What Mail Merge for Labels Actually Does

At its core, mail merge pulls data from a structured source (your Excel file) and automatically populates a template (your label document in Word) with that data. Instead of manually typing 200 addresses, you set up the template once and Word fills it in for every row in your spreadsheet.

The three components involved:

• The data source — your Excel spreadsheet with columns like First Name, Last Name, Address, City, State, ZIP
• The template — a Word document formatted to match your label sheet dimensions
• The merge fields — placeholders in the template that tell Word where to insert each piece of data

Preparing Your Excel Spreadsheet

Before you touch Word, your Excel file needs to be structured correctly. This step is where most problems start.

Key requirements for your spreadsheet:

• Row 1 must be a header row — column names like FirstName, LastName, Address1, City, State, ZipCode. No blank cells in the header row.
• Each subsequent row is one label — one person or address per row, no merged cells, no blank rows between records.
• Consistent data formatting — ZIP codes stored as text if they start with a zero (e.g., 07001), otherwise Excel may drop the leading zero.
• One sheet of data — the data should ideally be on the first sheet, or at minimum on a clearly named sheet.

If your ZIP codes are being stripped of leading zeros, format that column as Text before entering data, or prefix entries with an apostrophe.

Setting Up Labels in Word

Once your spreadsheet is ready, open a blank Word document. The mail merge wizard walks you through this, but doing it manually gives you more control.

Step 1: Start the Mail Merge

Go to Mailings → Start Mail Merge → Labels.

A dialog box will ask you to select your label vendor and product number. This is where you match the template to the physical label sheets you're using — Avery 5160, for example, is a common 1" × 2⅝" address label. Check the packaging of your label sheets for the product number.

Step 2: Connect to Your Excel File

Go to Mailings → Select Recipients → Use an Existing List.

Navigate to your Excel file and select it. Word will ask which sheet to use — select the sheet containing your data and confirm that the first row contains column headers.

Step 3: Insert Merge Fields

Your label template now shows one label cell (the rest display «Next Record»). Click inside the first label cell and go to Mailings → Insert Merge Field to add your fields one at a time.

A typical address label layout looks like:

«FirstName» «LastName» «Address1» «City», «State» «ZipCode» 

You're manually typing spaces, commas, and line breaks between fields — Word only inserts the data, not the formatting around it.

Step 4: Propagate to All Labels

Once your first label is formatted correctly, click Mailings → Update Labels. This copies your layout (including merge fields and formatting) to every label on the page.

Step 5: Preview and Finish

Use Mailings → Preview Results to see real data from your spreadsheet populate the labels. Scroll through a few records to catch formatting issues — names running too long, missing spaces, ZIP codes showing incorrectly.

When everything looks right, go to Mailings → Finish & Merge → Edit Individual Documents (or Print Documents). "Edit Individual Documents" creates a new Word file with every label already filled in, which lets you review or make manual edits before printing.

Common Issues and What Causes Them 🔍

Factors That Affect How This Goes for You

The process above covers the standard path, but real-world results vary based on a few things:

• Office version — The Mailings tab looks slightly different across Microsoft 365, Office 2019, Office 2016, and earlier versions. The workflow is the same but menu labels and dialog boxes shift.
• Mac vs. Windows — Word for Mac has the Mailings tab but some sub-options are arranged differently. A small number of features available on Windows aren't present in the Mac version.
• Label brand and size — If your label product number isn't in Word's built-in list, you'll need to create a custom label size by entering the exact dimensions manually.
• Data complexity — Simple name/address merges are straightforward. If your spreadsheet has conditional data (some records have a second address line, others don't), you'll need to use IF field rules to handle blank lines cleanly — otherwise empty lines appear in the middle of some labels.
• Volume — Merging 50 labels and merging 5,000 labels both work the same way, but large files can slow down the preview step depending on your machine.

What "Finish & Merge" Actually Produces 📄

It's worth understanding that the merged output is a standard Word document — every label is just text in a table. This means you can still make manual corrections to individual labels after merging, or adjust spacing before sending to the printer.

The original template document (with merge fields) stays separate and reusable. Next time you need labels from the same or updated spreadsheet, you reconnect the data source and run the merge again.

Whether this process fits neatly into your workflow — or whether you hit friction at the label sizing step, the data formatting stage, or somewhere in between — depends almost entirely on how your spreadsheet is currently structured and which version of Office you're working with.