How to Use Mail Merge to Print Address Labels in Word

Printing address labels one at a time is slow and error-prone. Word’s Mail Merge feature automates this task by pulling recipient data from a spreadsheet or contact list. This article explains how to set up a label document, connect it to your data source, and print a full sheet of labels in one batch. You will learn the exact steps from start to finish without trial and error.

What Mail Merge Does and What You Need Before Starting

Mail Merge connects a Word document to a data source so that each row in the source produces a separate printed page or label. For address labels, the data source is typically an Excel spreadsheet, an Outlook contacts folder, or a Word table. Each column in the source holds one piece of information such as First Name, Street Address, City, State, and ZIP Code.

Before you open Word, prepare your data source. The first row must contain column headers. Do not leave blank rows or columns in the data range. Save the file in a location you can find easily. You also need the product number of the label sheets you will use. This number is printed on the label package. Common examples are Avery 5160, 8160, or 5162. If you do not have the number, measure the label dimensions and use Word’s New Label dialog to create a custom size.

Supported Data Sources

Word can read data from Excel files (.xlsx, .xls), Access databases, Outlook Contacts, Word tables, text files, and SharePoint lists. Excel is the most common choice because it allows easy sorting and filtering. If you use Outlook Contacts, the field names are predefined and may differ from your spreadsheet headers. Check the field list after connecting.

Label Sheet Compatibility

Word includes templates for most major label brands. If your label sheet is not in the list, click New Label in the Label Options dialog. Enter the exact label height, width, number of labels across, and margins. Word saves this as a custom label definition that you can reuse later.

Steps to Set Up and Print Address Labels With Mail Merge

Follow these steps in order. Do not skip the Update Labels step or only the first label will contain data.

1. Open a new blank document in Word
   Go to the File tab and select New > Blank Document. Do not use an existing document for labels because the page layout must match the label sheet dimensions.
2. Start the Mail Merge wizard for labels
   Go to the Mailings tab. Click Start Mail Merge and select Labels. In the Label Options dialog, choose your label vendor from the Label vendors dropdown. Select the product number. Click OK. Word creates a table that matches the label grid on your sheet.
3. Select your recipient data source
   On the Mailings tab, click Select Recipients. Choose Use an Existing List. Browse to your Excel file or other data source. If you use an Excel file, select the worksheet that contains your data. Word shows a preview of the first rows. Click OK.
4. Insert merge fields on the first label
   Click inside the first label cell. On the Mailings tab, click Insert Merge Field. Choose the fields you want to appear on the label. For example, insert Address Block or individual fields such as First Name, Last Name, Street, City, State, and ZIP Code. Press Enter or Space to arrange them exactly as you want the printed label to look.
5. Copy the layout to all other labels
   On the Mailings tab, click Update Labels. Word copies the merge fields from the first label to every other label cell on the sheet. If you change the layout later, click Update Labels again to refresh the entire sheet.
6. Preview the merged labels
   On the Mailings tab, click Preview Results. Word replaces the merge fields with actual data from the first record. Use the arrow buttons in the Preview Results group to scroll through records. Check that addresses fit within the label area and that no fields are missing.
7. Print the labels
   On the Mailings tab, click Finish & Merge and select Print Documents. In the Merge to Printer dialog, choose whether to print all records, the current record, or a range. Click OK. In the Print dialog, select your printer, set the number of copies, and click OK. Word prints one sheet of labels for every set of records that fit on one sheet.

Alternative Method: Step-by-Step Mail Merge Wizard

If you prefer a guided walkthrough, use the built-in wizard. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard. The task pane on the right walks you through six steps: document type, starting document, recipients, address block, preview, and complete the merge. This method is slower but helpful for first-time users.

Common Mistakes and How to Avoid Them

Labels print with the same address on every label

This happens when you skip the Update Labels step. Without that step, only the first label contains merge fields. The rest of the labels show the same data because they are not linked to the data source. Go back to the Mailings tab and click Update Labels. Then preview the results again.

Address data appears on only one label

This is the same root cause as above. The merge fields must be copied to all label cells. Click Update Labels. If you manually typed merge fields into each cell, delete them and start from the first cell only. Then use Update Labels.

Labels do not align with the paper sheet

The label product number in Word must match the product number on the package. If the numbers match but alignment is off, your printer may shift the page. Go to File > Options > Advanced. Under Print, enable the setting Allow A4/Letter paper resizing. Also try printing one test sheet on plain paper first. Hold the printed sheet against the label sheet to check alignment.

Merge fields show as «FieldName» instead of real data

This is normal during the setup phase. Click Preview Results on the Mailings tab to see the actual data. If the fields still show as codes after clicking Preview Results, the data source may not be connected. Click Select Recipients and verify the file path. If the file was moved or renamed, browse to it again.

Excel data includes blank rows that create empty labels

Word reads all rows in the selected worksheet range, including blank ones. Remove blank rows from the Excel worksheet before connecting. Alternatively, name the exact range that contains data using Excel’s Define Name feature, then select that named range in Word’s Select Table dialog.

Mail Merge Labels vs Manual Label Printing

Item	Mail Merge Labels	Manual Label Printing
Setup time	10-15 minutes first time	1-2 minutes per sheet
Accuracy	No typing errors after data source is correct	Risk of mistyped addresses
Batch size	Unlimited records	Limited by patience and time
Data source reuse	Same file can be used for envelopes, letters, or emails	Not reusable
Label alignment	Automatic based on product number	Manual trial and error

Mail Merge saves time when you print more than a few sheets of labels. The initial setup takes longer than typing one address, but the investment pays off for batches of 20 or more labels. For a single label, manual typing is faster.

You can now print address labels using Mail Merge with your own data source. Next time you need labels, reuse the same Word document by clicking Select Recipients and choosing a different data file. For advanced control, sort your recipients before merging by clicking Edit Recipient List and using the Sort link. This lets you print labels in ZIP code order or alphabetically without rearranging the original spreadsheet.