Fill a whole sheet of Avery 5160 labels

Make10 minutes

The problem

Only the first label has a name. The rest of the sheet is empty.

A sheet of Word labels with Ava Reed on the first label and the others empty. A hand-drawn arrow points to the empty labels, with the words the rest stay empty.

Why it happens

You set up the first label only. The other labels stay empty until Word copies that layout to them.

Fix it

  1. On the Mailings tab, click Start Mail Merge, then Labels....

  2. Set Label vendors to Avery US Letter. In Product number, pick 5160 Address Labels, then click OK.

  3. Click Select Recipients, then Use an Existing List..., and choose your list.

  4. Click in the first label. Add your fields with Insert Merge Field.

  5. Click Update Labels, then Preview Results.

Update Labels filled all 30 labels on the sheet. Each label after the first got a «Next Record» field, so it shows the next person.

Word's Label Options box with 5160 Address Labels selected. After Update Labels, each label has a name.

Watch for

Don't copy the first label and paste it over the whole sheet. Pasting over the whole table also puts text in the thin gaps between labels, and Update Labels won't clear it. Undo the paste, then use Update Labels.

Is 8160 different? In Word's Label Options, 8160 Address Labels has the same size as 5160: 1" by 2.63", 30 per sheet.

For: Word for Windows

Microsoft's help: Print labels for your mailing list