Create Labels in Word With Mail Merge: Step-by-Step

To create a sheet of address labels in Word, open the Mailings tab, choose Start Mail Merge > Labels, select the label product number, connect your recipient list, insert the address fields, and choose Finish & Merge. You’ll need the label packaging or product number and a prepared list of recipients; preview the result and test-print it before loading label stock.

What You’ll Need

Microsoft Word for Microsoft 365 on Windows. The Mac version has similar mail-merge features, though some dialog layouts and commands may differ slightly.
A recipient list, such as an Excel workbook, with one person or destination per row and a separate column for each detail, such as first name, last name, street, city, state, and postal code.
Label sheets compatible with your printer. Find the label vendor and product number on the package; if you use a different brand, look for a product number listed as compatible with your label template.
A printer and plain paper for a test print. A test sheet helps you check alignment before using your labels.

Step-by-Step

Prepare the recipient list. In Excel, put column headings in the first row, such as First Name, Last Name, Address, City, State, and ZIP Code. Put each recipient on a separate row beneath the headings, with one piece of information per column. Remove blank rows within the list, check spelling and postal codes, and make sure the headings are unique and descriptive. Save the workbook, then close it before connecting it to Word. Closing it can help prevent file-access problems.
Start a label mail merge. In Word, create a blank document and select Mailings > Start Mail Merge > Labels. This opens the Label Options dialog. If you already have a document open, make sure it does not contain content you want to keep: choosing a label layout changes the document into a grid of label cells.
Choose the label product. In Label Options, choose the printer type that matches how your printer handles sheets. Most home and office printers use Page printers. Under Label vendors, choose the manufacturer shown on your label package, then select the matching product number. Check the package carefully: similar-looking sheets may have different numbers, dimensions, or numbers of labels per page. Select OK. Word creates a page laid out as a table of label-sized cells.
Choose the recipient list. Select Mailings > Select Recipients > Use an Existing List, browse to your Excel workbook, and open it. If Word asks you to choose a table or worksheet, select the sheet or named range containing the list and confirm that the first row contains column headings. If your data is in another supported source, choose the matching recipient option instead. Use Edit Recipient List on the Mailings tab to exclude people, sort records, or filter the list before making the labels.
Insert the address in the first label. Click inside the top-left label cell. For a standard mailing address, select Mailings > Address Block. Review the preview, choose the address format and name-inclusion options you want, and select OK. If the preview does not put the right information in the right places, choose Match Fields in the dialog and match Word’s address elements to the column headings in your list. For more control, use Mailings > Insert Merge Field to insert fields one by one, adding spaces, punctuation, and line breaks where needed.
Check the first label’s formatting. Select the address text in the first cell and use the Home tab to adjust the font, size, alignment, and paragraph spacing. Keep the text within the printable area of the label; large fonts, long organization names, and extra blank lines can cause overflow. If you need a line break between fields, place the cursor where it belongs and press Enter. Keep the layout simple until you have confirmed that it fits.
Copy the layout to the rest of the sheet. Select Mailings > Update Labels. Word copies the first label’s layout to the other cells and adds the necessary Next Record fields so each label uses the next recipient. This step is essential for a full sheet of different addresses. If you change the first label after updating, choose Update Labels again to carry those changes across the page.
Preview the merged labels. Select Mailings > Preview Results. Use the previous and next record arrows on the ribbon to check several entries, including the first and last recipients and any records with unusually long names or addresses. Confirm that each label has a different recipient, line breaks look right, and no fields show as blank or as field codes. Turn Preview Results off and on if you need to return to the merge fields and edit the layout.
Complete the merge. Select Mailings > Finish & Merge. Choose Edit Individual Documents to create a separate document containing the merged labels; select All or a record range, then review the resulting pages. This is a useful option if you want to inspect or correct the output before printing. Choose Print Documents if you are ready to send the merge directly to the printer, then select the records and printer options in the dialogs that appear.
Test the print and print on label stock. First print one merged page on plain paper using the same paper size and printer settings you intend to use for the labels. Hold the paper over a label sheet against a light to check that text sits inside each label. In the print dialog, use the correct paper size and avoid options such as Fit to Page or scaling that could shrink or enlarge the layout. If the test aligns, load the label sheet according to your printer’s instructions and print the final batch.

Common Mistakes

Choosing a similar but incorrect product number: Labels with the same brand can have different layouts. Confirm the exact number on the package rather than picking a template based only on appearance.
Forgetting Update Labels: Without it, the first address may be repeated or the other cells may remain empty. Update Labels after building the first cell, and preview the whole sheet.
Using confusing or incomplete column headings: Word may not match fields such as ZIP or Address Line 1 to its standard address elements automatically. Use clear headings and check Match Fields before accepting an address block.
Leaving blank rows or incomplete records in the list: Blank entries can produce empty labels, and missing address parts can make an otherwise valid label look broken. Clean or filter the list before merging.
Printing on label stock before checking alignment: Scaling, the wrong paper size, or an incorrect label template can waste a sheet. Test on plain paper first and compare it with the label sheet.
Editing only one label after copying the layout: Changes made in a later cell may not carry across the sheet. Make formatting changes in the first label and select Update Labels again.

Tips

Save the Word merge document and the recipient workbook in a location you can find again. Word may need to reconnect to the workbook if you move or rename it.
Use a consistent address format in your source list. For example, keep apartment or suite details in a dedicated column or include them consistently in the street-address column.
Use Preview Results to check a range of records, not just the first one. Longer addresses and international postal formats can reveal layout problems that a short sample will not show.
If you want a custom design, insert individual merge fields and format them in the first label. For example, you might put a company name on the first line and the contact’s name on the second, then update the other labels.
Save a copy of the merged output before printing if you expect to make manual corrections. The merged document contains the actual text, so it is easier to review than the field-based template.
On Word for Mac, look for the Mailings tab and the same general mail-merge commands, such as starting a Labels merge, selecting recipients, previewing, and finishing. The dialogs can be arranged differently from Windows; if a command is not in the same place, use Word’s ribbon search or help to locate it.

Troubleshooting

Word does not show the label product I have. Confirm that you selected the right printer type in Label Options, then check the vendor list and package for an exact product number. If the number is not available, use a compatible template from the label maker or select a custom label size only if you know the sheet’s dimensions and label spacing. An approximate size can cause every row or column to drift.

Every label contains the same person. Return to the merge document and check that you selected Update Labels after setting up the first cell. The later cells need Next Record fields to advance through the list. Use Preview Results and click through several records; if you still see the same person, rebuild the label layout or check that the recipient list contains multiple records.

Fields are missing, blank, or in the wrong order. Check that Word connected to the correct worksheet and that the headings are in its first row. Open Address Block and use Match Fields to connect the correct source columns. If a field is absent from the address block, insert it manually with Insert Merge Field. Also verify that the source cells actually contain data; a merge cannot fill in information that is missing from the list.

The text does not line up with the labels. Verify the product number and paper size, then check the printer’s paper-feed instructions. Print a plain-paper test and compare it with a blank label sheet. In the print settings, use the correct paper size and print at actual size rather than scaling to fit. If the entire page is shifted, investigate printer feed or template settings; if the misalignment grows down the page, the label dimensions or vertical spacing may be wrong.

The address runs outside its label. Reduce the font size, remove extra paragraph spacing, or shorten unnecessary content. Check long records in Preview Results and use a line break to control where the city and postal details appear. If only certain records overflow, adjust the source data or use a smaller font that still remains readable across the full list.

The printer will not feed label sheets reliably. Check the printer manual for supported label thickness and loading direction. Do not use curled, damp, or previously fed sheets unless the label maker says they are safe to reuse; a loose label can jam a printer. Try feeding one sheet at a time if the printer supports that method.

Frequently Asked Questions

Can I make labels from an Excel spreadsheet?
Yes. Arrange the recipients in columns with headings in the first row, save the workbook, then select it through Mailings > Select Recipients > Use an Existing List. Choose the correct worksheet when Word asks.

Do I need a separate page for each address?
No. A label merge normally places multiple recipients on one sheet. Word advances to the next record for each label after you choose Update Labels. A short list may fill only part of the final sheet.

Can I print one label instead of a full sheet?
Yes, but the available method depends on your label layout and printer. You can merge selected records or print a particular page or position after creating the merged document. Check the printer and label manufacturer’s instructions before reusing a partly used sheet.

Can I edit the labels after finishing the merge?
Yes. If you choose Edit Individual Documents, Word creates a new document with the merged text. You can edit that output without changing the original recipient list, though corrections made there will not update the source data.

Why does Word show «First Name» instead of a person’s name?
Those angle-bracketed items are merge fields, not errors. Turn on Mailings > Preview Results to see the data for each recipient. The fields appear again when previewing is turned off so you can edit the template.

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.