To create mailing labels in Word, open the Mailings tab, choose Start Mail Merge > Labels, select the label product that matches your sheets, and either enter one address repeatedly or merge a recipient list. Preview the layout and test-print it on plain paper before loading label stock. You will need the desktop version of Word for the full label and mail-merge tools.
What You’ll Need
- A computer with the desktop version of Microsoft Word. The steps below are for Word for Microsoft 365 on Windows. Word for Mac has similar mail-merge tools, though some dialog layouts differ. Word for the web does not provide the full desktop label mail-merge workflow.
- Label sheets, or the manufacturer and product number for the label stock you plan to use. The product number is usually printed on the package. If you are using custom-sized labels, measure a sheet before setting up a custom layout.
- For different addresses on the labels, a recipient list in Excel or another supported data source. An Excel list should have one recipient per row, with clear column headings such as FirstName, LastName, Street, City, State, and ZIP.
- A printer that can handle your label stock, plus plain paper for a test print. Check your printer instructions for how to feed label sheets.
Step-by-Step
- Decide whether you need repeated or different addresses. If every label should show the same return address, use Word’s single-sheet label setup and type the address once. If each label is for a different person or household, use a mail merge connected to a recipient list. Decide this first because the setup diverges after you choose the label dimensions.
- Prepare and check an address list for a merge. In Excel, put each field in its own column and give every column a heading in the first row. Put one recipient on each subsequent row; do not leave completely blank rows within the list. Check spelling, postal codes, and address line breaks. If a ZIP or postal code begins with zero, format that Excel column as Text before entering or importing the codes so Excel does not remove the leading zero. Save and close the workbook before connecting it to Word.
- Choose the label sheet in Word. Open a blank document, select Mailings > Start Mail Merge > Labels, and open the Label Options dialog. Choose the label vendor listed on the package, then select the matching product number and click OK. The document will display a grid of label cells. Confirm the number of labels across and down matches your physical sheet. If the package’s product is not listed, use New Label in the Label Options dialog and enter the dimensions and spacing from the label manufacturer’s specifications. Take care to distinguish label width from horizontal pitch, which includes the gap between labels.
- Connect your recipient list if each label needs a different address. Choose Mailings > Select Recipients > Use an Existing List, locate the Excel workbook, and select the sheet or table containing the data. If prompted, indicate that the first row contains column headers. If the workbook has several sheets, choose the one with the actual address table. Use Edit Recipient List on the Mailings tab to exclude rows you do not want to print or to sort and filter the recipients.
- Insert the address fields into the first label. Click in the first cell of the label grid. For a standard postal address, select Mailings > Address Block, review the preview, and adjust the address format as needed. If Word does not recognize a column, use Match Fields in the Insert Address Block dialog to pair your headings with the expected fields. You can also build the label manually with Insert Merge Field, adding fields in the order you want. Add line breaks between street, city, and region as appropriate; do not insert commas or spaces that make the final address look awkward.
- Copy the layout to the rest of the labels. After setting up the first cell, select Mailings > Update Labels. Word copies the first label’s layout to the other cells and inserts a Next Record rule so each label uses the next recipient. This step is essential for a full sheet of different addresses. If you typed a label manually and are not doing a merge, Word’s label dialog may offer a full-page option that repeats the same text across the sheet; choose that option if available, rather than expecting a mail-merge field to repeat automatically.
- Preview and correct the merge before printing. Select Mailings > Preview Results and move through several records with the previous and next record controls. Check that each label shows the right person’s details, that long names and addresses fit, and that the first and last labels are in the expected positions. If you see the same address on every label, revisit the merge setup and use Update Labels. If fields show as codes rather than values, turn on Preview Results or complete the merge to view the actual data.
- Complete the merge, then print a test. Choose Mailings > Finish & Merge > Edit Individual Documents to create a separate document containing the finished labels. This gives you a chance to inspect the whole sheet and correct any records before printing. You can instead choose Print Documents to send the merge directly to the printer. For the first attempt, print on plain paper at actual size, with scaling such as Fit to Page turned off. Hold the test page over a label sheet against a light to compare alignment. When it matches, load one label sheet in the printer’s recommended orientation and print the final document. In Word for Mac, the Mailings tab also supports label mail merges, but the dialog and printer options may be arranged differently; use the matching vendor and product number, then verify paper size and scaling in the Mac print dialog.
Common Mistakes
Choosing a similar but incorrect product number: Label products can look alike while using different margins, gaps, or label counts. Select the exact number on the package, not just a product with the same number of labels per page.
Skipping Update Labels: In a recipient merge, the first label can look correct while every other cell remains blank or repeats the first person’s details. Click Update Labels after designing the first cell, then preview several records.
Printing on label stock before testing: A small alignment error can waste a whole sheet. Test on plain paper and check both the top and bottom rows. Also verify the printer’s feed direction; printers do not all load face up or face down in the same way.
Using inconsistent list headings or blank rows: Missing headings, merged cells, and empty rows can make Word select the wrong fields or include blank records. Keep the source as a simple rectangular table with one heading row and one record per row.
Letting print scaling change the layout: Options such as Fit, Shrink to printable area, or borderless enlargement can shift the label grid. Print at 100 percent or actual size unless the label maker’s instructions specify otherwise.
Tips
- Keep a clean master copy of the address list. Make corrections there rather than typing over merge results in the completed document; re-run the merge after you update the source.
- Use consistent address conventions. For example, keep apartment or unit information in a separate column or consistently include it on the street address line. Consistency makes it easier to format the whole batch.
- Choose a readable font and a size that fits the smallest label. A long company name or international address may need a slightly smaller font. Preview an unusually long record as well as a typical one.
- Save the merged output as a separate Word document if you need a record of exactly what was printed. The merged document contains the finished label text, while the original mail-merge document remains connected to the source list.
- If you expect to use the same stock again, note the label brand, product number, printer feed orientation, and any print settings that worked. This avoids guessing the next time you prepare a batch.
- For a single return address on a whole sheet, use the label creation route rather than building a table from scratch. The built-in layout accounts for the sheet’s label spacing and is easier to adjust if you switch products.
Troubleshooting
The labels are shifted up, down, or sideways. First confirm that the selected product number exactly matches the stock. Then print a plain-paper test and check that print scaling is set to actual size. Confirm that the document paper size matches the label sheet, and load the stock in the correct direction. If the product is correct but the offset remains, check the printer’s paper guides and feed instructions. For unlisted stock, create a New Label definition using the manufacturer’s measurements rather than adjusting random margins.
Word cannot find the Excel data or asks which table to use. Save and close the workbook, then reconnect through Mailings > Select Recipients > Use an Existing List. Pick the correct sheet or named table and confirm the first row contains headings. If the list is on a worksheet with notes or extra content above it, move the address table to a clean sheet with a single header row.
Names or address parts are missing or in the wrong order. Open Mailings > Address Block and use Match Fields to connect Word’s address components to your actual column headings. If the automatic block does not suit your data, remove it from the first label and insert the individual merge fields in the intended order. Preview more than one recipient to make sure the correction applies across the batch.
Every label shows the same person, or later labels are blank. Select the first label and choose Update Labels again. Then turn on Preview Results and step through the records. If only one recipient is selected, open Edit Recipient List and clear unintended filters or check marks. If you intended to repeat one address, use the repeated-label setup instead of a recipient merge.
The address is clipped or spills into another label. Reduce the font slightly, shorten optional text, or adjust paragraph spacing in the first label, then use Update Labels again. Check long address lines and organization names. Avoid shrinking text so far that it becomes difficult to read; for a large batch, consider splitting unusually long addresses into a separate print run with a different layout.
Frequently Asked Questions
Can I make a full sheet of the same address in Word?
Yes. Use Mailings > Start Mail Merge > Labels, select the exact stock, and enter the address in the first label. Use the repeated-label or full-page option in the label setup when available. This is different from a recipient mail merge, which advances to a new address on each label.
Can I make labels from an Excel spreadsheet?
Yes. Put each recipient on a row with a heading for each address field, then connect the workbook through Mailings > Select Recipients > Use an Existing List. Insert an Address Block or individual merge fields, choose Update Labels, and preview before printing.
Can I print labels without buying a label template?
You can define unlisted stock using New Label in the Label Options dialog. You will need accurate measurements for page size, top and side margins, label width and height, and the horizontal and vertical spacing. A plain-paper test is especially important for a custom definition.
Why does Word show merge-field names instead of addresses?
The document may be showing field codes or may not yet have completed the merge. Turn on Mailings > Preview Results to display sample recipient data. To create a document with all final addresses, choose Finish & Merge > Edit Individual Documents.
Can I create mailing labels in Word for the web?
Word for the web can open and edit many documents, but it does not provide the full desktop label mail-merge workflow. Open the document in the Word desktop app to choose label stock, connect a recipient list, and complete the merge.
How do I stop wasting label sheets while adjusting alignment?
Print the merged page on plain paper first, at actual size. Place it over a label sheet and hold both up to a light to compare the borders. Change the product selection, printer feed, or scaling only after identifying the cause of the offset, then test again before using label stock.
Related
- How to Clear Cache Files in Outlook Safely
- Clear Cache and Cookies in Outlook: Step-by-Step
- How to Clear Cache Data in Outlook
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Break Dotted Lines: How to Show Them AgainTo show page-break dotted lines in Excel for Microsoft 365 on Windows, choose File > Options > Advanced,…
- Excel Find and Replace Opens File Explorer? Why It HappensNo: in Excel for Microsoft 365 on Windows, Ctrl+H opens the Find and Replace dialog, not File Explorer.…
- Google Sheets: Find Unique Values in a Range EasilyTo find unique values in Google Sheets, enter =UNIQUE(A2:A) in an empty cell, replacing A2:A with your range.…
- How to Make a Poster in Word or PowerPoint That Prints WellTo make a poster in Word or PowerPoint, set the page or slide to the finished poster size…
- Inventory Spreadsheet Template for Google Sheets: GuideYes. You can make an inventory spreadsheet template in Google Sheets by creating columns for each item’s identifier,…
- Excel Time Format Over 24 Hours: Display Elapsed Time CorrectlyTo display a duration longer than 24 hours in Excel, select the cells, open Format Cells, choose Custom,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.