Word mail merge · alignment

Mail merge labels misaligned? Read how they miss the sheet

Updated

How the print misses tells you why. Off by the same amount on every label is the printer; worse down the page is the product number, the scale or the paper size; text in the next label is too much text. Match your sheet below, or print the list here at the size of the sheet and correct the printer once.

Off the same everywhere? Calibrate the printer

  • Sized to the sheet, to the point
  • A printer correction you keep
  • Menus from Microsoft's help
1 · Off the same everywhere 2 · Worse down the page 3 · Text in the next label 4 · Columns spread apart

Four ways a merge lands off, and what each means.

The way the print misses tells the cause. On 8663 and 5163, for instance, the second column of one sits 1/32 in from where the other puts it, from the same 2 × 4 in labels.

  1. Pattern 1 · you see

    Every label off by the same amount

    The document is right and the printer places the page a little off: every printer feeds the sheet its own way.

    Windows
    Nothing to change in Word: print a test sheet
    Mac
    Nothing to change in Word: print a test sheet
    Step by step
    1. Print one page on plain paper and hold it over a label sheet against a window.
    2. Measure how far off it is, or print the calibration test sheet: its rulers read the offset in 1/32 in steps.
    3. Here, save that correction once: every PDF this site makes for that printer carries it.

    Microsoft: print the labels

  2. Pattern 2 · you see

    Fine at the top, worse down the page

    The rows in Word aren't the rows of your sheet: another product number, a page scaled to fit, or paper that isn't US Letter.

    Windows
    Mailings > Start Mail Merge > Labels: Label vendors, then the product number
    Mac
    Mailings > Start Mail Merge > Labels: Label products, then the product number
    Step by step
    1. In Label Options, pick Avery US Letter and the exact number on your box (Microsoft's Avery steps for Windows and Mac).
    2. Print at 100% (Actual size), not Fit to page or Shrink.
    3. On Windows, check that Page Setup's Paper tab says Letter, the size of the label sheet (Microsoft's Paper tab).

    Microsoft: Avery US Letter · Microsoft: Word for Mac · Microsoft: Paper tab

  3. Pattern 3 · you see

    One label's text runs into the next

    More lines than the label holds, a larger font or extra paragraph spacing push the text past its cell.

    Windows
    The wizard's Preview your labels: font size and paragraph spacing
    Mac
    Mailings > Preview Results, then the first label and Update Labels
    Step by step
    1. Preview the labels and find the longest address.
    2. Shorten it, make the font smaller or take out the space after each paragraph, on the first label.
    3. Choose Update Labels again so every label takes the change.

    Microsoft: adjust paragraph spacing in the preview

  4. Pattern 4 · you see

    The columns spread apart, or squeeze together

    Two sheets can have the same label size in different places: 8663 and 5163 are both 2 × 4 in, and their columns don't line up.

    Windows
    Label Options: the exact product number, not one of the same size
    Mac
    Label Options: the exact product number, not one of the same size
    Step by step
    1. Read the number on the box, not the label size, and pick that number in Label Options.
    2. If it isn't listed, choose New Label and type the margins and pitch from the template page here.
    3. Print one page on plain paper before the labels.

    Microsoft: New Label

Do it here

Or print it at the sheet's own size.

Paste the orders you were merging, or open the file. Every label is placed where Avery's template puts it, and a long address shrinks before it spills.

Cells copied from Excel, Google Sheets or Numbers, header row included, or addresses with a blank line between them.

The number on your box

Open the full editor

The sheet shows the sample: six orders with companies and suites. Paste your list or open a file, and it shows yours.

Your list stays on this device. Nothing is uploaded.

Imani BrooksBrooks Ceramics2200 Industrial Pkwy, Unit 14Sacramento, CA 95815Felix Navarro73 Copper Ridge RdFlagstaff, AZ 86001Mara JensenNorthwind Yarn Co.1188 Lake Shore Dr, Building C Suite 300Madison, WI 53703Owen Pike5 Tidewater LnBeaufort, SC 29902Lucia FerraroFerraro Family Bakery640 Market StLancaster, PA 17603Dev Kapoor2901 Prairie View Blvd, Apt 1207Omaha, NE 68132
Sample list · 6 labels on 5163

Worked example

The longest addresses, inside their labels.

Company, street and suite on their own lines, the city line whole, on 5163's 2 × 4 in labels.

In your spreadsheet

orders.csv

3 rows of the sample list
RowNameCompanyAddress 1Address 2CityStateZIP
2Imani BrooksBrooks Ceramics2200 Industrial PkwyUnit 14SacramentoCA95815
4Mara JensenNorthwind Yarn Co.1188 Lake Shore DrBuilding C Suite 300MadisonWI53703
7Dev Kapoor2901 Prairie View BlvdApt 1207OmahaNE68132
On the 5163 sheet, as listed
  1. Imani BrooksBrooks Ceramics2200 Industrial Pkwy, Unit 14Sacramento, CA 95815
  2. Mara JensenNorthwind Yarn Co.1188 Lake Shore Dr, Building C Suite 300Madison, WI 53703
  3. Dev Kapoor2901 Prairie View Blvd, Apt 1207Omaha, NE 68132
  • The longest, Mara Jensen, stays inside its label: the text shrinks before it spills.
  • Every label sits where Avery's own template puts it, to a thousandth of a point.
  • Off the same on every label? Save a printer correction and print again.

Line it up in three steps.

  1. Print a test page

    Plain paper, at 100%. Or the calibration test sheet, with rulers in 1/32 in steps.

  2. Hold it over a sheet

    Against a window. Note which way the print sits, and whether it gets worse down the page.

  3. Fix the cause

    The same everywhere: save a printer correction. Worse down the page: the product number, the scale or the paper size.

Same size, different sheets

Labels of one size can sit in different places on the sheet. Pick by the number on the box, never by the size alone.

Same size, different sheets: size, labels per sheet and the numbers that share each layout
SheetLabel sizePer sheetSame layoutGood for
Avery® 5163 2 × 4 in 10 8163 · 18163 · 48163 +29 2 × 4 in, columns 4-3/16 in apart.
Avery® 8663 2 × 4 in 10 5663 · 7663 · 15663 +2 2 × 4 in clear labels, columns 4-1/8 in apart.
Avery® 5160 1 × 2-5/8 in 30 8160 · 9160 · 18160 +56 Address labels, 30 to a sheet, the rows touching.

Before the text spills

How many lines each sheet holds.

Lines of Helvetica a label holds inside its padding, as this site's PDF sets them, at the size each sheet starts at and two points smaller. Word sets its own line and paragraph spacing, so read these as the most a label holds.

Lines and characters a label holds on common mail merge sheets
SheetLabelLinesCharacters a line
51601 in tall5 at 10 pt · 6 at 8 pt36 at 10 pt
51611 in tall4 at 12 pt · 5 at 10 pt48 at 12 pt
51621-1/3 in tall6 at 12 pt · 7 at 10 pt48 at 12 pt
51632 in tall8 at 14 pt · 9 at 12 pt41 at 14 pt
51643-1/3 in tall12 at 16 pt · 13 at 14 pt36 at 16 pt
51671/2 in tall3 at 7 pt · 4 at 5 pt31 at 7 pt
82573/4 in tall4 at 9 pt · 5 at 7 pt34 at 9 pt
68711-1/4 in tall6 at 10 pt · 8 at 8 pt31 at 10 pt
  • Here, a long line shrinks to fit, then is shortened as a last resort, and the status says which labels; a city line keeps its state and ZIP code.
  • A company line? 5161 and 5162 are 4 in wide: room for it without a smaller font.

Three things that keep 5163 labels straight.

Print at actual size

"Fit to page" can resize the sheet, and then the lower rows drift off their labels. The PDF opens at 100%; keep it there.

Feed the right side up

Printers differ: some print on the side facing up in the tray, others on the side facing down. Mark an X on a plain sheet, print once and look before you load labels.

Test on plain paper

Hold a plain-paper print over a 5163 sheet against a window. If it sits off, calibrate once and save the correction for that printer.

Questions people ask

Why are my mail merge labels shifting down the page?

The rows in Word don't match your sheet: another product number in Label Options, a page scaled to fit, or paper that isn't Letter (pattern 2).

Why is every label off by the same amount?

That's the printer, not the document: each feeds the sheet a little differently. Print the test sheet, measure, and save the correction for that printer (pattern 1).

Why does the text run onto the next label?

The label holds fewer lines than the address has, at that size. Shorten it, use a smaller font, or remove paragraph spacing on the first label, then Update Labels (how many lines each sheet holds).

Are Avery 5163 and 8663 the same template?

No. Both are 2 × 4 in, ten to a sheet, but 8663's columns start 1/32 in further right and sit 1/16 in closer: 8663 and 5163 each have their own.

Should I print labels at Fit to page?

No: Fit to page can shrink the sheet, and the rows drift further off the lower they are. Print at 100%, Actual size.

How do I line labels up on my printer for good?

Print the calibration test sheet once, read the offset on its rulers and save it: every PDF this site makes for that printer carries the correction (calibration).

Labels where the sheet has them

The editor places every label to a thousandth of a point, carries your printer's correction and starts on any label of a used sheet.

Four sheets of labels printed off their labels: shifted the same everywhere, drifting down the page, one label's text in the label below, and columns spreading apart