Mailing Address Labels in Word: How to Create Them

To create mailing address labels in Word, use Mail Merge: prepare an address list, choose the matching label product, connect the list, add address fields, preview the sheet, and print. Before starting, check the label package for its brand and product number, and make sure your printer can handle the label stock.

What You’ll Need

Microsoft Word for Microsoft 365 on Windows. The ribbon paths below use the current Windows desktop app. Word for Mac has similar mail-merge tools, though some buttons and dialog layouts may differ slightly.
Label sheets. Note the manufacturer and product number printed on the packaging. If the sheets are not a common brand, look for the equivalent product or measurements in the label options.
A printer and the correct paper settings. Check whether the sheets are intended for an inkjet or laser printer, and follow the package directions for loading them.
An address list, if you are making multiple labels. An Excel workbook is convenient, but Word can also use other supported data sources. For a small batch, you can enter addresses directly in a document instead.

Step-by-Step

Prepare and check your address list. Put each recipient on a separate row in Excel, with one type of information per column. Useful headings include FirstName, LastName, Company, Address1, Address2, City, State, PostalCode, and Country. Keep the headings in the first row and avoid blank rows above them, merged cells, and extra title text. Make sure postal codes are stored as text if they may begin with zero; otherwise Excel can remove the leading zero. Review spelling, apartment or suite numbers, and country names, then save the workbook and close it before connecting it to Word.
Start a label mail merge. In Word, open a blank document and choose Mailings > Start Mail Merge > Labels. In the Label Options dialog, select the label vendor printed on your package and then choose the product number. If the exact product is not listed, use the package measurements to find a compatible layout or create a custom label option if that choice is available. Confirm the selection with OK. Word displays a page divided into label-sized cells.
Connect your recipient list. Choose Mailings > Select Recipients > Use an Existing List, browse to the saved Excel workbook, and select it. If Word asks which table or worksheet to use, choose the sheet containing your headers and addresses, and confirm that the first row contains column headers. If the list is in another supported file, use the appropriate recipient-source option instead. For a one-off set of addresses, you can choose Type a New List and enter the records in Word’s dialog.
Filter or remove recipients if needed. Select Mailings > Edit Recipient List to review the records Word will use. Clear the check box beside anyone who should not receive a label. You can also sort or filter the list in this dialog, for example to print labels for one city or organization. Check the preview of the recipient rows before continuing; an accidental filter or unchecked record can make labels appear to be missing.
Build the first label. Click inside the first label cell, then choose Mailings > Address Block to insert a formatted group of address fields. In the dialog, choose the name and address format you want and inspect the preview. If a field does not match your column headings, use Match Fields to connect Word’s requested fields to the correct list columns. Click OK when the preview looks right. For full control over line breaks or a layout that does not fit Address Block, use Insert Merge Field to add individual fields, pressing Enter between address lines as needed.
Copy the layout to every label. After the first label is arranged, select Mailings > Update Labels. Word copies the design to the remaining cells and adds the next-record instruction so each label uses a different recipient. Do not copy and paste the first label manually into every cell: without the next-record field, the sheet may repeat the same address. If Update Labels is unavailable, confirm that you started a Labels mail merge rather than creating a regular table.
Preview the merge. Choose Mailings > Preview Results and use the arrow controls to move through several recipients. Check that names, company details, street lines, city, region, postal code, and country land on the intended lines. Look at both a short address and a long one, and inspect later records as well as the first. If a field appears blank or incorrect, turn off Preview Results, correct the address list or field mapping, and preview again.
Finish the merge before using label stock. Choose Mailings > Finish & Merge > Edit Individual Documents, select the records to include, and click OK. Word creates a new document containing the merged labels. Review the resulting pages, especially the final page and any partly filled sheet. Saving this merged document gives you a copy to check or reprint without repeating the merge setup.
Test the alignment on ordinary paper. Print one page on plain paper at actual size or 100% scaling. Hold it behind a label sheet against a light to see whether the text fits inside the label boundaries. Check the top and bottom rows, because small alignment differences can become more noticeable across a page. If the test is accurate, load the label sheet in the printer’s recommended orientation and print the merged document.
Print with the right settings. In the print dialog, confirm the correct printer, paper size, page range, and paper type. Avoid options such as Fit to Page or Scale to Fit, which can change the label dimensions; select actual size or 100% when available. Use the printer manufacturer’s instructions for loading and printing on label sheets. If you selected the wrong label product or paper setting, stop before feeding more sheets and correct the setup.
For one label rather than a full batch, choose its position. In the Labels setup dialog, select the option for a single label, then specify the row and column where the unused label is located. Enter the address in the available field and print a test on plain paper first. Printer feed paths vary, so verify which side of the sheet will print before using a partly used label page.

Common Mistakes

Choosing a similar-looking product number. A small difference in label height, width, or spacing can shift every row. Match the exact product number on the package whenever possible; do not rely only on the number of labels per sheet.

Forgetting to update the labels. If only the first cell has address fields, or every cell shows the same person, the layout was not propagated correctly. Use Update Labels and check that the other cells contain next-record instructions before previewing.

Printing directly on expensive stock. A printer may scale the page, feed it in the opposite direction, or use a different printable margin than expected. A plain-paper alignment test can prevent a whole sheet from being wasted.

Leaving out important line breaks or list fields. A long company name or address line can wrap into an awkward position. Inspect longer records and adjust the field order, line breaks, or font size in the first label, then update labels and preview again.

Assuming a postal code is ordinary numeric data. Codes with leading zeros can lose those zeros in Excel. Format that column as text and verify the merged preview against the original list.

Tips

Keep a clean master address list and make a copy before sorting, filtering, or editing records for a particular mailing.
Use consistent headings and avoid combining several pieces of information in one cell. Separate columns make it easier to match fields and change the layout.
Set up the design in the first label before choosing Update Labels. Use a readable font and leave enough space around the edges; text too close to a cut line may print unevenly.
Consider including the country as the final address line for international mail, and use the recipient’s preferred postal format when you know it.
Save both the original recipient list and the merged label document with descriptive file names. The merged document preserves the printed results, while the list lets you update addresses for a future mailing.
On Word for Mac, use the Mailings tab to start a label merge and select recipients. Dialog names and placement can vary by Word version, so if a command is not where it is on Windows, look in the Mailings ribbon or Word Help for that command.

Troubleshooting

All labels show the same address: Return to the merge layout and choose Mailings > Update Labels. Then preview the results and step through several recipients. If the next-record instructions are missing, recreate the label merge or update the label layout again.

The address list or worksheet does not appear: Save the workbook in a supported format such as .xlsx, close it, and try Select Recipients > Use an Existing List again. Select the correct worksheet and confirm that the header row is recognized. Remove blank rows above the headers and check that the workbook is not protected or stored somewhere Word cannot access.

Fields are blank or mapped to the wrong columns: Check the column headings in Excel, then use Mailings > Match Fields in the Address Block dialog. Confirm that names and address components are in separate columns and that the selected worksheet contains the actual records.

Text is cut off or wraps badly: Reduce the font size slightly, use fewer lines, or adjust the address block in the first label. Make the same changes before updating the labels, then preview the longest address. If a column is too narrow, check that the chosen product number is correct rather than trying to force text into an incompatible layout.

Printing is shifted or the dimensions look wrong: Confirm the label product number, paper size, printer tray, feed orientation, and 100% scaling. Print a plain-paper test and compare it with the label sheet. If the shift is consistent, check the printer’s paper guides and label-stock instructions; if the Word layout itself is the wrong size, select the correct product and recreate the merge.

Only part of the sheet prints: Check the selected record range in Finish & Merge, the print page range, and any filters in Edit Recipient List. A final page with blank cells is normal when the recipient count is not a multiple of the sheet capacity.

Frequently Asked Questions

Can Word make address labels from an Excel list?
Yes. Use Mailings > Select Recipients > Use an Existing List, choose the workbook and worksheet, then insert and preview the address fields. Clear, consistent column headings make the connection easier.

Can I print just one address label?
Yes. In the Labels setup dialog, choose the single-label option and specify the row and column of an unused label. Test the feed direction on plain paper before printing on a partly used sheet.

Why does Word repeat the same address on every label?
The layout may not include a next-record instruction for later cells. Click Update Labels in the Mailings tab, then use Preview Results to confirm that different recipients appear across the sheet.

Can I make labels without an Excel spreadsheet?
Yes. For a small batch, select Mailings > Start Mail Merge > Labels, then use Select Recipients > Type a New List to enter addresses. You can also type addresses directly into a regular document when you do not need a mail merge.

Will the steps work in Word for Mac?
Word for Mac includes label mail merge tools under the Mailings tab, and the overall process is similar. Dialogs and command placement can differ by version, so check Word Help if a Windows menu path does not match your screen.

How can I avoid wasting label sheets?
Verify the package product number, preview several records, and print a 100%-scale test on plain paper. Check alignment against the label sheet before loading the actual stock.

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.