How to Do a Label Mail Merge in Word: Step-by-Step Guide

To do a label mail merge in Word, open a blank document, choose Mailings > Start Mail Merge > Labels, select the label brand and product number, connect your address list, arrange the fields, preview the results, and finish the merge to print. You will need a compatible sheet of labels and a recipient list, such as an Excel workbook, with one person or destination per row. The steps below are for Word for Microsoft 365 on Windows; Mac menus are similar, with a few interface differences.

What You’ll Need

Microsoft Word: Use the desktop version of Word for Microsoft 365. Word for the web has limited mail-merge support and may not provide the full label workflow.
Label sheets: Note the manufacturer and product number printed on the package. Word uses that information to set the label dimensions and page layout.
A recipient list: An Excel workbook is a common choice. Put column headings such as First Name, Last Name, Street, City, State, and ZIP in the first row, then put one recipient in each following row. You can also enter recipients directly in Word.
A printer and a test sheet: Plain paper is useful for checking alignment before you use an actual label sheet.

Step-by-Step

Prepare and save your recipient list. If you are using Excel, make the first row clear column headers and avoid blank rows or merged cells in the data. Keep each piece of information in its own column: for example, use separate columns for Street, City, State, and ZIP rather than putting the whole address into one cell. Remove recipients you do not want included and check for duplicate entries. Save the workbook, then close it before connecting it to Word. Closing it helps avoid file-locking or update issues.
Start a label document. In Word for Microsoft 365 on Windows, create a blank document and select Mailings > Start Mail Merge > Labels. The Label Options dialog opens. If you already have a document open, this command changes its page setup to the label layout you choose, so start with a blank document when possible.
Choose the label product. In Label Options, select the label supplier from the Label vendors list, then choose the product number that matches the package. Check the product number carefully; two sheets from the same brand can have different label sizes or numbers of labels per page. Select a printer type if Word asks, then choose OK. Word displays a table-like grid representing the labels on the sheet. If your exact product is not listed, select New Label and enter the measurements from the package or manufacturer’s specifications. Do not guess: a small size error can shift every row or column.
Connect your recipients. Select Mailings > Select Recipients. Choose Use an Existing List to use an Excel file, browse to the workbook, and open it. In the dialog that follows, select the worksheet or table containing the recipient data and confirm that the first row contains column headers if Word asks. If you do not have a list, choose Type a New List and enter the recipients in Word’s data-entry window. You can also choose an available Outlook contacts list, depending on your Word and Outlook setup.
Check which records are included. Choose Mailings > Edit Recipient List to review the linked names. You can sort or filter the list and clear the check box beside a recipient to exclude that person from this merge. This is a useful place to confirm that Word has read the correct worksheet and that the first and last records appear as expected. If the list looks wrong, cancel and reconnect to the correct workbook or sheet before placing fields.
Build the first label. Click inside the first cell of the label grid. Select Mailings > Address Block to insert a formatted address, then use the dialog to choose the layout and preview how names and address components will appear. If Address Block does not match your data, choose Mailings > Insert Merge Field and add individual fields in the desired order. For example, insert First Name, a space, Last Name, press Enter, then insert Street, and use another line for City, State, and ZIP. Add punctuation and spaces between fields yourself. Use the preview in the dialog or the field list to make sure the names in your spreadsheet correspond to the fields you insert.
Format the first label. Select the inserted text and set a readable font, size, alignment, and line spacing from the Home tab. Keep text inside the label boundaries and leave enough margin for the printer. A font that looks fine on screen may be too large once printed on a small address label. Do not type a real recipient’s address as fixed text unless it should appear on every label; fixed text is repeated, while merge fields change for each record.
Copy the layout across the sheet. When the first label is ready, select Mailings > Update Labels. Word copies the layout and merge fields to the other label cells and adds the necessary next-record instructions so each label uses a different recipient. Do this after arranging the first label, not before. If you change the first label later, select Update Labels again so the change is applied throughout the sheet.
Preview the merged labels. Select Mailings > Preview Results. Use the left and right record arrows on the Mailings tab to inspect several recipients, including the first, one in the middle, and the last. Look for missing names, blank lines, cramped text, incorrect ZIP codes, and fields that appear as labels such as «City» instead of actual data. Turn Preview Results off and adjust the first label if needed, then choose Update Labels again and preview once more.
Finish the merge before printing. Select Mailings > Finish & Merge > Edit Individual Documents, choose which records to include, and confirm. Word creates a new document containing the completed labels, which you can inspect, save, or print. This is often safer than printing directly because it gives you one more chance to check the whole output. To print without creating a separate document, use Finish & Merge > Print Documents and select the records you need.
Test alignment, then print the label stock. First print the merged document on plain paper using the printer’s normal-size or 100% scaling setting. Hold the page against a label sheet or a bright light and check that the text sits within the label boundaries. If it lines up, load the label stock in the direction shown by your printer and print the merged document. Check the printer’s paper type and feed instructions, and avoid settings such as Fit to Page if they resize the label grid.

Mac note: In Word for Mac, use the Mailings tab and the same basic sequence: start a label merge, choose the label product, select recipients, insert fields, update labels, preview, and finish the merge. The dialog layout and exact options can differ from Windows. If a command is not visible on the ribbon, widen the Word window or look for it in the Mailings tab’s menus. Word for the web may not expose these desktop mail-merge controls, so open the file in the desktop app.

Common Mistakes

Choosing a similar but incorrect product number: A brand name alone is not enough. Match the exact product number and sheet format. If the package number is missing, use the manufacturer’s dimensions rather than a visually similar template.

Forgetting Update Labels: Inserting fields in the first cell does not necessarily populate the remaining cells with the correct merge instructions. Use Update Labels after you design the first label, and repeat it after significant layout edits.

Using an unsuitable spreadsheet layout: Word needs a straightforward list with one header row and one recipient per row. A title above the headers, blank rows inside the list, merged cells, or several separate address lines in one cell can make the recipient-selection step confusing or lead to incomplete fields.

Leaving unwanted spaces or blank lines: If an optional field is empty, such as an apartment number or a middle name, the label may show an awkward gap or empty line. Inspect records with missing details during preview, and adjust the layout or data to avoid unnecessary blank lines.

Printing before checking scale: Printer settings can shrink or enlarge the page. Print a plain-paper test first and check that scaling is 100% or actual size. Also verify the feed direction before loading label stock; printers differ in which side they print on.

Tips

Use descriptive column headings. Headers such as First Name and Postal Code are easier to match than generic headings like Column1. Avoid punctuation or unusual symbols in headers where possible.
Keep ZIP and postal codes as text when needed. Spreadsheet software may remove a leading zero from a numeric ZIP code. Format that column as text before entering or importing values, and check the preview for any lost zeros.
Make a copy of the recipient workbook. A separate, cleaned merge list helps protect the original data and makes it easier to spot which recipients are included.
Use a readable type size and simple layout. Small labels have limited room. Avoid squeezing in optional information if it makes the address hard to read, and check the longest address rather than only the first one.
Save the merged document. Save the completed labels as a separate Word file if you may need to reprint them. The merged output contains the actual recipient details, while the original merge document holds the fields and layout.

Troubleshooting

The label grid is not the right size. Return to Mailings > Start Mail Merge > Labels and verify the vendor and product number. If you need to change products, choose the correct one and review the new grid. For an unlisted product, select New Label and confirm every measurement, including page size, label width and height, top and side margins, and horizontal and vertical pitch. A pitch is the distance from one label’s starting point to the next, not just the label’s width or height.

Word cannot find the workbook or shows the wrong records. Make sure the workbook is saved in a location you can access and is closed, then reconnect through Select Recipients > Use an Existing List. In the workbook-selection dialog, choose the sheet or table with the actual headers and data. If the first row is not recognized as headers, correct the spreadsheet layout and reconnect.

Merge fields show instead of recipient details. Turn on Mailings > Preview Results. If field names remain visible, confirm that Word is connected to the intended recipient list and that the fields in your label match the spreadsheet headings. If the preview is correct but the completed document still shows fields, return to the merge document and choose Finish & Merge again.

Every label repeats the same address. Confirm you used Update Labels to copy the first label correctly. If you copied and pasted the first label manually, the next-record instructions may be missing. Rebuild the first label, select Update Labels, and preview the next few records.

Labels print too high, low, or to one side. Check the product number, page size, printer feed direction, and print scaling. Print to plain paper and compare it with an unused label sheet. If Word’s grid matches the package but the test is still offset, check the printer’s paper-handling settings and whether the stock is loaded squarely. Avoid changing several measurements at once; adjust only after identifying whether the error is a consistent offset or increasing drift across the page.

Frequently Asked Questions

Can I use an Excel spreadsheet for a Word label mail merge?
Yes. Put headers in the first row and one recipient per row, save and close the workbook, then connect it with Mailings > Select Recipients > Use an Existing List. Choose the worksheet or table containing your addresses.

How do I make each label show a different address?
Design the first label with merge fields, then choose Mailings > Update Labels. Word copies the design and adds the record-advance instructions used to place a different address on each label. Check the result with Preview Results.

Can I make labels without an Excel list?
Yes. In Select Recipients, choose Type a New List and enter the names and addresses in Word. You can also use a supported contacts list if it is available in your setup.

Why are my labels misaligned even though I chose the right product?
The printer may be scaling the page, the stock may be loaded in the wrong direction, or the selected product number may not match the exact sheet. Print a plain-paper test at actual size, compare it with the label sheet, and check printer feed settings before using labels.

Can I print only some of the addresses?
Yes. Choose Edit Recipient List to uncheck recipients or filter the list, or use the record options when you select Finish & Merge. Preview the included records before printing to avoid wasting label stock.

Can I reuse the label document next time?
Yes. Save the original merge document with its label layout and fields. When you reuse it, reconnect or update the recipient source as needed, confirm the records, preview the labels, and create a fresh merged document before printing.

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.