Skip to content
Tutorials Center
My learning

Topics

Lesson 33 of 42 Β· Mail Merge, Macros and Automation

Envelopes and Labels in Word

Print envelopes and address labels in Word, choose label products and sizes, merge a whole address list onto label sheets, and fix alignment problems.

Printing an address on an envelope or a sheet of sticky labels is a classic office task, and Word has dedicated dialogs for it. For one item, use the single-address dialogs. For a whole list, combine them with Mail Merge.

Single envelope

  1. Choose Mailings > Envelopes.
  2. On the Envelopes tab, type the Delivery address (or click the small book icon to pick from Outlook contacts). If your document already has an address selected before you open the dialog, Word fills it in.
  3. Type or leave the Return address (Word can remember a default, found in File > Options > Advanced > General > Mailing address). Tick Omit for pre-printed envelopes.
  4. Click Options... to choose the Envelope size (Size 10, DL, C5, C6 and more), fonts for each address, and Printing Options (face up or down, the feed method and Clockwise rotation). The preview boxes show the feed.
  5. Click Print, or Add to Document to put the envelope at the top of your document as its own section, which lets you edit and format it further.

If the printout is misaligned, adjust Printing Options > Feed method and test with plain paper first, and check your printer's own envelope settings and tray type. Each printer has its own way of feeding envelopes, so keep one successful layout as a saved template.

Single label or a full sheet

  1. Choose Mailings > Labels.
  2. Type the Address. Tick Use return address to print your own address.
  3. Under Print, choose Full page of the same label or Single label with a Row and Column number (useful for a partly used sheet).
  4. Click Options..., set Printer information (continuous feed or page printers with a tray), pick the Label vendors (Avery US Letter, Avery A4/A5, Herma, and so on), and the Product number that is printed on your label package.
  5. Click OK, then Print, or New Document to see the sheet as a table you can adjust.

If your product is not listed, click New Label... and enter the measurements: Top margin, Side margin, Vertical pitch (distance between the tops of two labels), Horizontal pitch, Label height and width, and Number across and Number down.

How the label sheet is laid out

Word creates a table, with each label as a cell, and invisible spacer columns between labels. Turn on View Gridlines (Layout tab) to see it. This is why changing the table's row height or page margins breaks alignment. Do not resize it by hand unless you know the numbers.

The positions of labels follow simple arithmetic. This stand-in works out the top-left corner of each label for a 3-column by 10-row sheet in inches. The measurements are typical but check your own product's data.

Python Where does each label go? (stand-in)

Press Run (or Ctrl + Enter) to see the result here.

Program input Β· what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Labels from a list (merge)

To print a different address on every label:

  1. Start a new blank document.
  2. Mailings > Start Mail Merge > Labels..., choose the vendor and product number, click OK.
  3. Select Recipients > Use an Existing List... (the Excel file of names and addresses).
  4. Click Address Block (or insert fields one by one) for the first label. Word adds Β«Next RecordΒ» to every other cell.
  5. Click Update Labels to copy the layout to all labels (older builds need this; it may happen automatically).
  6. Preview Results, then Finish & Merge > Edit Individual Documents... to review, or Print Documents....

For envelopes from a list the process is the same, with Start Mail Merge > Envelopes... and an Envelope Options dialog.

Formatting labels

  • Format the first label; Update Labels repeats it.
  • Use a font of 10 to 12 points, left-aligned.
  • Remove extra paragraph spacing: select the table, set Spacing After to 0 (Layout > Paragraph).
  • Put a company logo in the first cell as a picture or a small text box, then update.
  • For different content types on one sheet (for example name badges), use a Directory or a table, not a label wizard.

A visual check

Before printing on expensive label paper, print on plain paper and hold it against a sheet of labels in front of a light. The HTML below draws a label grid, which is a way to think of the table that Word builds. Change the numbers to see the result.

A 3 by 4 label grid
  • Barcodes and postal codes: some countries use special barcodes. Check the postal service's guidance, as Word's built-in features differ by region.
  • Return-address labels: choose Full page of the same label after typing your address.
  • Shipping labels from a table: the merge can also use a Word table as the data source. Put the headings in the first row.
  • Name tags and CD labels: Word includes many products. Use the same Labels dialog.
  • Cards: for business cards, see Project: A Flyer and a Business Card.

Check your understanding

Quick check Β· 4 questions

of 4 answered You scored / 4 Β· perfect!

  1. 1. Where do you find the Envelopes and Labels commands?

    Envelopes, Labels and Start Mail Merge are in the Mailings tab.
  2. 2. What does the Product number in the Label Options dialog refer to?

    Word stores layouts for each product number so margins and label sizes match the sheet.
  3. 3. How is a sheet of labels built in Word?

    The label sheet is a table with spacer columns, which is why resizing it by hand breaks alignment.
  4. 4. What is a sensible first print test?

    A plain paper test shows the alignment without wasting labels.

Summary

  • Mailings > Envelopes prints or adds an envelope; Mailings > Labels does labels.
  • Choose the vendor and product number to match your label sheet.
  • Labels are table cells; do not resize the table by hand.
  • Merge a list onto labels with Start Mail Merge > Labels.
  • Test on plain paper first.

Next: Macros and VBA