How to Create Multiple Address Labels in Microsoft Word

To create multiple address labels in Word, set up a recipient list, choose the label stock you have, then use Mail Merge to place each address on its own label. You will need Word for desktop, your addresses in a list or spreadsheet, and the label package’s brand and product number. Preview the merged pages and print a test before using a full sheet.

What You’ll Need

Word for desktop: These directions are for Microsoft 365 on Windows. Word for Mac also has label and mail-merge tools, although some dialog layouts and options differ. Word for the web cannot complete a mail merge, so open the file in the desktop app.
A list of recipients: Use an Excel workbook or another supported recipient list. A simple spreadsheet is easiest to check and update.
Label sheets: Note the manufacturer and product number printed on the package. The number identifies the label dimensions and page layout.
A printer and plain paper: A plain-paper test helps you check alignment before using label stock.

Step-by-Step

Prepare the address list. In Excel, put one recipient on each row and use a separate column for each part of the address, such as First Name, Last Name, Street, City, State, and ZIP Code. Put clear headings in the first row; Word uses these column names when you insert merge fields. Remove fully blank rows and check for spelling, missing apartment numbers, and duplicate records. Format ZIP or postal code columns as text before entering codes if leading zeroes matter, so Excel does not remove them. Save the workbook somewhere you can find it, then close it before connecting Word to it.
Start a label mail merge. Open Word for desktop and create a blank document. On Windows, select Mailings > Start Mail Merge > Labels. In Word for Mac, use the Mailings tab and choose the Labels option under Start Mail Merge; the dialog appearance can vary by version. This tells Word that each record should occupy one label, rather than one page or one letter.
Choose the exact label stock. In the Label Options dialog, select the printer type if Word asks, then choose the label vendor and product number from the package. Check that the number of labels across and down, label size, and sheet size match the stock you will print on. If your product number is not listed, choose New Label and enter the measurements from the package or manufacturer’s specifications. Measure carefully; do not guess based on a similar-looking label.
Connect Word to the recipient list. Select Mailings > Select Recipients > Use an Existing List, browse to your Excel file, and select it. If Word asks which worksheet or table contains the data, choose the sheet with the headings and recipient rows, and confirm that the first row contains column headers. To choose only certain recipients, use Edit Recipient List and clear the check boxes beside records you do not want in this mailing.
Lay out the first label. Click in the first label cell on the page. On the Mailings tab, choose Insert Merge Field and add the fields in the order you want them to appear. Put the name on the first line, the street address on the next, and city, state, and postal code together on the last line if that suits your postal format. Press Enter between lines. Type commas or spaces where needed; Word does not automatically add punctuation between separate fields.
Check spacing and formatting. Select the address text in the first label and choose a readable font size and style from the Home tab. Keep the text inside the label’s printable area and avoid large margins, oversized type, or extra blank paragraphs. If a line looks crowded, reduce the font slightly or put the postal code on a separate line instead of shrinking it until it is hard to read.
Copy the layout to every label. On the Mailings tab, click Update Labels. Word copies the first label’s layout across the sheet and inserts the required next-record fields so that each label uses the following recipient. Do not copy and paste the first address manually into every cell: without the next-record behavior, the sheet can repeat the same person instead of advancing through the list.
Preview the recipients. Click Preview Results to see real addresses in place of the field names. Use the previous and next record arrows to inspect several labels, including the first and last records. Look for blank lines caused by missing fields, text that wraps beyond a label, missing leading zeroes, and addresses that appear out of order. If the preview is not right, turn Preview Results off, correct the first label or the source list, and click Update Labels again if you changed the layout.
Generate the merged labels. Choose Finish & Merge > Edit Individual Documents, select all records or the range you need, and confirm. Word creates a separate merged document containing the finished label pages. Review that document before printing; it is easier to fix a source or layout issue now than after labels have been printed.
Print a test and then the labels. Print one merged page on ordinary paper using the same paper size and orientation as the label sheet. Hold the test page over a label sheet against a light to check that the text falls within each label. In the print settings, use the correct paper size and avoid options such as Fit to Page or other scaling; scaling can shift the alignment. When the test lines up, load the label sheets as directed by the printer and label manufacturer, then print the required pages.

Common Mistakes

Picking a similar, but incorrect, product number: Two label sheets can look alike while having different margins or gaps. Match the number on the package, not just the brand or the number of labels per page.
Forgetting Update Labels: Inserting fields into the first cell alone does not reliably create a complete set of different addresses. Use Update Labels before previewing and merging.
Putting the whole address in one spreadsheet cell: This makes it harder to format names and address lines consistently. Separate fields give you control over line breaks and punctuation.
Letting Excel alter postal codes: Codes with leading zeroes can be changed if Excel treats them as numbers. Keep postal codes as text and check the Word preview for the original values.
Printing directly onto label stock before checking alignment: A slight mismatch can waste a sheet or put text on the edges. Print a plain-paper test first and confirm the printer is not scaling the page.
Editing only the merged document: Fixing a typo in one merged label may not fix the source list or the merge layout. Correct the spreadsheet or first-label design, then create a fresh merged document.

Tips

Keep the headings in the first row of the spreadsheet and avoid merged cells, subtotals, or notes above the recipient data. A clean table makes it easier to select the correct records.
Use a consistent address style. For example, decide whether states will be written in full or abbreviated, then apply that choice throughout the list.
Save the Word merge document and the Excel source file together in a clearly named folder. Word uses the source file to fill the fields, so moving or renaming it can require reconnecting the list.
Make a copy of your recipient list before sorting or filtering it. Sorting the whole table by a single column keeps names and their address details together; sorting only one column can scramble the records.
If you need another run later, keep the original merge document with its field layout instead of relying only on the finished output. Reconnect or update the recipient list as needed, then preview the new records.
For repeated labels of one address rather than a different address on each label, use Word’s Mailings > Create > Labels dialog, type the address, and select Full page of the same label. That is a different task from a recipient-by-recipient mail merge.

Troubleshooting

Word cannot find the Excel list: Confirm that the workbook is saved in a location you can access and that it is closed while you connect. In Word, repeat Mailings > Select Recipients > Use an Existing List and choose the correct workbook and worksheet. If the list still does not appear, make sure the first row has column names and that there is at least one recipient row beneath it.

Every label shows the same address: Return to the main merge document, make sure you used Update Labels, and check the later label cells for a Next Record field before the address fields. Then preview the results again. If you typed the address as ordinary text rather than inserting merge fields, Word has no instruction to move to the next recipient.

Some address lines are blank: Check the corresponding recipient row for empty cells or inconsistent column headings. If a field is optional, remove unnecessary blank paragraphs or adjust the address layout so missing apartment or company details do not leave awkward gaps. Preview multiple records, since one record may be complete while another is not.

Text runs off a label: Reduce the font size modestly, shorten unnecessary wording, or put part of the address on another line. Also check that the chosen product number matches the physical sheet. Do not solve an overflow problem by changing the whole page’s size, because that can misalign every label.

The test page is shifted: Confirm the correct label product, paper size, and orientation. In the print dialog, turn off scaling and select Actual Size or 100% if that option is available. Check that the paper is loaded in the correct direction and that the printer’s guides hold it straight. If Word’s measurements are correct but the printer still shifts the page, follow the printer manufacturer’s instructions for label stock and feed settings.

The label product is not listed: Use New Label in Label Options and enter the sheet dimensions and margins from the manufacturer. If you cannot confirm the measurements, download the vendor’s Word template or consult the product documentation rather than estimating them.

Frequently Asked Questions

Can Word print a different address on each label?
Yes. Start a label mail merge, connect a recipient list, insert merge fields in the first label, and select Update Labels. Each record then fills the next label when you preview and merge.

Can I make a full sheet of the same address?
Yes. Use Mailings > Create > Labels, enter the address in the dialog, and choose Full page of the same label. Use the mail-merge steps when the labels need different addresses.

Can I use an Excel list for Word labels?
Yes. Keep one person per row, use a heading for each address column, and connect the workbook through Mailings > Select Recipients > Use an Existing List. Check the preview to confirm the fields are mapped correctly.

Can I create address labels in Word for the web?
Word for the web does not provide the desktop mail-merge workflow for generating labels. Open the document in Word for Microsoft 365 on Windows or Mac to set up and complete the merge.

Why are my labels not aligned when printed?
The selected label product may not match the stock, or the print dialog may be scaling the page. Verify the package number, paper size, orientation, and Actual Size setting, then print a plain-paper test before using label sheets.

Do I need to save the merged document?
It is useful to save it if you want a fixed copy of the addresses as printed. Also keep the original merge document and recipient list, which you can update if you need to make corrections or run another batch.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.