To create mailing labels in Word, open the Mailings tab, choose Start Mail Merge > Labels, select the label brand and product number, then connect a recipient list and insert its fields. Preview the results, choose Finish & Merge, and print a test page before loading label sheets.
Choose between a mail merge and a single label
Word can make labels in two different ways. Use a mail merge when you need a different name or address on each label, such as for invitations, customer mail, or holiday cards. Word combines a document layout with a list of recipients and creates a label for each record.
If every label should show the same address, you do not need a recipient list. On the desktop version of Word for Microsoft 365 on Windows, go to Mailings > Labels, enter the address, and open Options to select the label stock. Choose Full page of the same label to fill a sheet, or select a single label and specify its row and column if you are using a partly used sheet. The dialog wording can vary slightly by Word build.
For a bulk mailing, use the mail-merge route instead. It takes more setup, but it avoids typing each address separately and makes it easier to correct the contact list before printing. The steps below describe Word for Windows; Word for Mac has similar mail-merge concepts, though some dialog layouts and commands can differ. Word for the web does not provide the full desktop label mail-merge workflow, so use the Word desktop app for this task.
Prepare your recipient list
A recipient list is the data source Word uses to fill in each label. You can select an existing Excel workbook or create a new list from Word. A spreadsheet is convenient when you already maintain addresses in Excel, and it lets you sort, check, and update records before connecting them to the document.
For the cleanest merge, put one person or household on each row, with a separate column for each kind of information. Use clear headings such as FirstName, LastName, Address, City, State, and ZIP. Avoid merged cells, blank rows within the data, and multiple unrelated tables on the same worksheet. Keep each address component in its own column if you may want to change its order or leave out a field later.
- Check spelling, apartment or suite numbers, postal codes, and country names before printing.
- Make sure the first row contains column headings rather than a contact record.
- Keep postal codes as text if leading zeroes matter; spreadsheet formatting can otherwise remove them.
- Remove duplicate contacts or filter out recipients who should not receive this mailing.
Save and close the Excel file before connecting it to Word if the workbook is open or being edited. When Word asks which sheet or table to use, select the one containing the list and confirm that the first row contains column headings. You can also create a list from Word with Mailings > Select Recipients > Type a New List, then enter contacts in the data-entry window. That approach is suitable for a short list, while a spreadsheet is usually easier to maintain for recurring mailings.
Match the label stock to Word’s settings
Before creating the document, find the label product number on the package or backing sheet. Label sheets are not all the same size: they can have different label widths, heights, margins, gaps, and numbers of columns. In the label setup window, choose the manufacturer under Label vendors and the matching product number under Product number. Do not choose a product just because its labels look similar.
In Word for Windows, start with Mailings > Start Mail Merge > Labels. In Label Options, select the vendor and product, check the displayed label information, and choose OK. If the package number is not listed, check the manufacturer’s instructions for a compatible Word template or enter the dimensions using New Label when that option is available. A custom layout must match the sheet’s printable area and spacing; approximate measurements can cause text to drift onto the next label.
Look at the paper itself as well as the package. Confirm whether the sheets are intended for an inkjet or laser printer, and follow the printer and label maker’s guidance about paper type and feeding. Labels can peel or jam if the stock is incompatible with the printer, damaged, or fed in a way the printer does not support.
Create the mail-merge label document
After selecting the label product, Word opens a document arranged as a table of label cells. The first cell is the design template; the remaining cells may initially look blank. Connect the list and add fields to that first label before copying the layout across the sheet.
- Choose Mailings > Select Recipients, then select Use an Existing List to browse to an Excel workbook, or choose Type a New List to enter contacts in Word.
- For an Excel source, choose the correct worksheet or named range in the selection window. If prompted, confirm that the data has column headings.
- Click inside the first label. Use Mailings > Address Block to insert a standard address, or choose Insert Merge Field to place individual fields such as FirstName, Address, and City.
- If you use Address Block, review its preview and use Match Fields if Word has not matched a heading to the right address element. The headings in your source list may not use the same names Word expects.
- Arrange the fields and line breaks in the first label. For example, a simple layout might put FirstName and LastName on one line, Address on the next, and City, State, and ZIP on the last line.
- Choose Mailings > Update Labels to copy the first label’s layout to the other cells. Then select Preview Results and use the record navigation controls to inspect several addresses.
- Choose Finish & Merge. Select Edit Individual Documents to create a separate merged document you can inspect, or choose Print Documents to send the merge directly to the printer.
In Word for Mac, look for the Mailings tab and its recipient, merge-field, preview, and finish commands; the exact dialog arrangement can vary between releases. If the label vendor or product is not shown in the Mac version, use the label maker’s compatible template or create a custom label layout if your version offers that option. The key principle is the same: build one label, propagate it, preview records, and check alignment before using the label stock.
Format the labels and check the merged records
Keep the first label’s layout simple. Choose a readable font and size that fits the smallest address, and use line breaks to separate address lines. If an address may include a long street name, company, or apartment number, test that kind of record in the preview rather than designing only around the shortest entry. You can select text in the label cell and use Word’s normal font and paragraph controls to adjust its appearance.
Fields are placeholders, not the final addresses. Before merging, select Preview Results and move through more than the first record. Check that names appear in the intended order, that punctuation and spacing look right, and that blank fields do not leave awkward empty lines. For example, if some contacts have no company name or apartment number, an inserted line for that field may create a visible blank. Adjust the source list or layout to handle the records you actually have.
Update Labels matters because it copies the design and merge fields from the first cell into the rest of the page. If you edit the first label after updating, the other cells may not reflect the change. Make the correction in the first label and use Update Labels again, then preview the sheet. Avoid typing different fixed addresses into individual cells in a merge document: Word is meant to fill those cells from the selected records.
Print a test page and align the sheets
Do not begin with an expensive or limited label sheet. In the finish step, create an editable merged document or print one test page on ordinary paper. Hold the test page behind a label sheet against a light source to see whether the text sits within each label. This check can reveal a wrong product number, incorrect orientation, or printer scaling before adhesive stock is used.
When the layout looks right, load the label sheet according to the printer’s instructions and confirm that the printer settings use the correct paper size and a normal, actual-size scale. A setting such as “Fit to page” can shrink or enlarge the page and shift every label. Check which side of the paper prints and whether the sheet should be fed face up or face down; these details depend on the printer. Use the correct stock type setting if the printer provides one.
Print one sheet first, then inspect the top, middle, and bottom rows. If every row is shifted by the same amount, check scaling, margins, and the selected label product. If the alignment gradually gets worse down the page, the sheet dimensions, feed path, or printer handling may be involved. Change one setting at a time and test again. Do not run a sheet through repeatedly if labels have begun to peel or the printer maker advises against refeeding label stock.
Fix common label problems
- Every label repeats the first person: Confirm that the recipient list is connected, then use Update Labels in a mail merge. A repeated address is expected when you selected the single-label option for the same label.
- Some labels are blank or fields are missing: Check the selected worksheet and column headings. Use Match Fields for an address block, or insert the correct column through Insert Merge Field.
- Text is cut off: Reduce the font slightly, remove unnecessary wording, or revise line breaks. Check the longest real address, not just a short sample.
- Text prints between labels: Verify the manufacturer and product number, paper size, printer scaling, and sheet orientation. Do not assume that two products with the same number of labels per page have identical dimensions.
- Word cannot find the list: Browse to the saved workbook again, select the correct sheet, and make sure the file is accessible. Closing the workbook in Excel before linking it can also avoid file-access conflicts.
A frequent misconception is that choosing a label brand alone guarantees alignment. The product number and printer settings matter too. Even a correctly designed Word page can print incorrectly if the printer scales it or the sheet is loaded in the wrong direction. Treat the test print as part of setup, not as an optional finishing step.
When another method may be easier
Word is useful when you need a familiar layout, a quick one-off mailing, or a merge from an existing Excel contact list. For a very small number of labels, typing addresses into a document or using the Mailings > Labels dialog for repeated copies may take less setup than preparing a merge source. For a mailing that changes often, keeping a clean spreadsheet and reusing it as the data source can reduce repeated data entry.
Label manufacturers also provide templates for some products. A template can be useful when Word does not list the exact stock, but confirm that it is designed for the application and product you have and check its dimensions before printing. If you work in Word for the web and cannot find the full mail-merge commands, open the file in desktop Word rather than trying to recreate the merge with manually copied addresses.
Frequently Asked Questions
How do I print different addresses on each label?
Use Mailings > Start Mail Merge > Labels, connect a recipient list, insert address fields in the first label, and choose Update Labels. Preview the records and finish the merge to create or print the full set.
How do I print the same address on a whole sheet?
Open Mailings > Labels, enter the address, choose the matching label product under Options, and select Full page of the same label. Print a test page first to confirm alignment.
Can I use an Excel spreadsheet for Word labels?
Yes. Put one contact per row with address parts in separate columns, save the workbook, and choose it with Mailings > Select Recipients > Use an Existing List. Select the worksheet containing the data when Word asks.
Why are my Word labels not aligned?
The selected product number may not match the sheet, or the printer may be scaling the page. Check the package, paper size, feed orientation, and actual-size print setting, then compare a plain-paper test against the label sheet.
How do I create labels without a product number in Word?
Look for a compatible template from the label manufacturer or use Word’s New Label option, if available, to enter the sheet and label measurements. Measure carefully and test on plain paper because small dimension errors can affect the whole page.
Related
- Copy Excel Sheet to Word: Methods and Formatting
- Copy and Paste Word to Excel: Tables, Text, and Formatting
- Excel Inventory List: How to Build and Manage Stock
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create a Filter in Google Sheets: Steps and TipsTo create a filter in Google Sheets in a web browser, select the cells you want to filter,…
- How to Insert a Fillable Checkbox in Microsoft WordTo add a fillable checkbox in Word, turn on the Developer tab, place your cursor where the box…
- How to Change Folder View in OutlookTo change a folder’s message-list view in Outlook, select the folder, open the view controls, and choose a…
- Change PowerPoint Slide Size to A2 (Portrait or Landscape)To change a PowerPoint presentation to A2, open Design > Slide Size > Custom Slide Size on Windows,…
- Find Blank Cells in Excel and Fill Them With ZeroTo find blank cells in an Excel range and fill them with zero, select the range, choose Home…
- How to Edit a Mail Merge Document in WordTo edit a mail merge in Word, open the main merge document, change its text or merge fields,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.