Word mail merge · Update Labels

Update Labels greyed out (grayed out) or not working in mail merge

Updated

The fix in Word: Mailings > Start Mail Merge > Labels, then Select Recipients > Use an Existing List, then Update Labels (on a Mac the same menus sit under Mailings). The button stays greyed out (grayed out) until the document is a labels merge with a list connected. It then copies the first label to every other one with «Next Record» in front, and the names show after Preview Results. Other symptoms are below, or open the same list here and skip the button.

Another problem? All seven mail merge fixes

  • No Update Labels to click
  • Menus from Microsoft's help
  • Your list stays on this device
MAILINGS Insert Merge Field Update Labels Preview Results «First_Name» «Last_Name»«Address»«City», «State» «ZIP» 1 · Only the first label «First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP»«Next Record»«First_Name» «Last_Name»«Address»«City», «State» «ZIP» 2 · Update Labels Priya Raman88 Willow BendNaperville, IL 60540Marcus Bell1402 Elm St Apt 5Dayton, OH 45402Greta Lindqvist27 Harbor View RdBellingham, WA 98225Tobias Okonkwo510 Magnolia AveSavannah, GA 31401Rosa Delgado9 Mesa Verde CtTucson, AZ 85704Wen Zhao3317 Laurel DrPlano, TX 75093Helen Brightwater46 Quarry LnIthaca, NY 14850Samuel Ortiz120 Pine Knoll WayAsheville, NC 28803Priya Raman88 Willow BendNaperville, IL 60540Marcus Bell1402 Elm St Apt 5Dayton, OH 45402Greta Lindqvist27 Harbor View RdBellingham, WA 98225Tobias Okonkwo510 Magnolia AveSavannah, GA 31401Rosa Delgado9 Mesa Verde CtTucson, AZ 85704Wen Zhao3317 Laurel DrPlano, TX 75093Helen Brightwater46 Quarry LnIthaca, NY 14850Samuel Ortiz120 Pine Knoll WayAsheville, NC 28803Priya Raman88 Willow BendNaperville, IL 60540Marcus Bell1402 Elm St Apt 5Dayton, OH 45402Greta Lindqvist27 Harbor View RdBellingham, WA 98225Tobias Okonkwo510 Magnolia AveSavannah, GA 31401Rosa Delgado9 Mesa Verde CtTucson, AZ 85704Wen Zhao3317 Laurel DrPlano, TX 75093Helen Brightwater46 Quarry LnIthaca, NY 14850Samuel Ortiz120 Pine Knoll WayAsheville, NC 28803Priya Raman88 Willow BendNaperville, IL 60540Marcus Bell1402 Elm St Apt 5Dayton, OH 45402Greta Lindqvist27 Harbor View RdBellingham, WA 98225Tobias Okonkwo510 Magnolia AveSavannah, GA 31401Rosa Delgado9 Mesa Verde CtTucson, AZ 85704Wen Zhao3317 Laurel DrPlano, TX 75093 3 · Preview Results

Six reasons Update Labels leaves the rest blank.

From the button you can't click to the page that won't print. Word's menus for Windows and for a Mac, from Microsoft's help, read on October 9, 2026.

  1. Cause 1 · you see

    Update Labels is greyed out

    Word's merge commands stay dimmed until the document has a list to merge, and Update Labels only belongs to a label merge.

    Windows
    Mailings > Start Mail Merge > Labels, then Select Recipients > Use an Existing List
    Mac
    Mailings > Start Mail Merge > Labels, then Mailings > Select Recipients
    Step by step
    1. Start from Mailings > Start Mail Merge > Labels and pick the number on your box in Label Options. A letter or a blank document has no labels to update.
    2. Connect the list with Select Recipients: the dimmed commands come on once Word has one.
    3. Keep the workbook on your computer, with the column names in its first row and every change made before you connect it.

    Microsoft: dimmed merge commands · Microsoft: label merge steps · Microsoft: data sources

  2. Cause 2 · you see

    Nothing happens when I click it

    Update Labels copies the first label as it is. Clicked before any field went into it, it copies an empty label.

    Windows
    Mailings > Insert Merge Field, in the top-left label
    Mac
    Mailings > Insert Merge Field, in the top-left label
    Step by step
    1. Click inside the top-left label, the first cell of the table.
    2. Insert each field with Insert Merge Field, and set the label up as every label should look.
    3. Then choose Update Labels: the other labels take the same fields.

    Microsoft: format the first label, then Update Labels

  3. Cause 3 · you see

    Every label says «Next Record», or {NEXT}

    That's what Update Labels writes: «Next Record» in front of every label after the first. The names show only in a preview, and {NEXT} is the same field with its code showing.

    Windows
    Mailings > Preview Results
    Mac
    Mailings > Preview Results
    Step by step
    1. Choose Preview Results to see the rows of your list in place of the fields.
    2. If you see {NEXT} or { MERGEFIELD … }, right-click it and choose Toggle Field Codes, or switch every code back with Alt+F9 on Windows and Option+F9 on a Mac.
    3. Don't type «Next Record» or a field yourself: Word only reads the ones it inserts.

    Microsoft: Toggle Field Codes · Microsoft: Alt+F9 and Option+F9 · Microsoft: fields can't be typed

  4. Cause 4 · you see

    A change to the first label doesn't reach the others

    Update Labels copies once. A field added, a font changed or a line deleted later stays on the first label until you copy it again.

    Windows
    Mailings > Update Labels, after every change
    Mac
    Mailings > Update Labels, after every change
    Step by step
    1. Make the change on the first label only.
    2. Choose Update Labels again, then Preview Results.
    3. Editing the other labels by hand is undone the next time you update.

    Microsoft: select Update labels if you changed anything

  5. Cause 5 · you see

    The wizard has no Update Labels button

    In Word's step-by-step wizard on Windows, the same command is a link in the task pane, under Arrange your labels.

    Windows
    Arrange your labels > Update all labels
    Mac
    No wizard: Mailings > Update Labels
    Step by step
    1. In the wizard's step Arrange your labels, set up the first label with Address block.
    2. Click Update all labels in the task pane.
    3. Go on to Preview your labels, where Microsoft suggests adjusting details such as paragraph spacing.

    Microsoft: the wizard's Update all labels

  6. Cause 6 · you see

    The labels fill, but only one page prints

    Rows unticked in the recipient list are left out, and merging the Current record prints only the one on screen.

    Windows
    Finish & Merge > Edit Individual Documents > All
    Mac
    Mailings > Filter Recipients, then Finish & Merge
    Step by step
    1. Tick every row you want in Edit Recipient List, and clear any filter.
    2. Finish with Finish & Merge > Edit Individual Documents: Word opens the whole run as a document you can check and print.
    3. On Windows, choose All rather than Current record.
    4. Every way a merge comes out a page short, and how to print one page again.

    Microsoft: edit recipients · Microsoft: All or Current record

Do it here

Every label at once, no button.

Paste the list you were merging, or open its workbook. Each row prints on its own label, so there's no first label to copy and nothing to update.

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: an 8-member club list. Paste your list or open a file, and it shows yours.

Your list stays on this device. Nothing is uploaded.

Priya Raman88 Willow BendNaperville, IL 60540Marcus Bell1402 Elm St Apt 5Dayton, OH 45402Greta Lindqvist27 Harbor View RdBellingham, WA 98225Tobias Okonkwo510 Magnolia AveSavannah, GA 31401Rosa Delgado9 Mesa Verde CtTucson, AZ 85704Wen Zhao3317 Laurel DrPlano, TX 75093Helen Brightwater46 Quarry LnIthaca, NY 14850Samuel Ortiz120 Pine Knoll WayAsheville, NC 28803
Sample list · 8 labels on 5160

Worked example

The rows, one label each.

What Update Labels does in Word, row by row, happens here as the list is read.

In your spreadsheet

members.xlsx

4 rows of the sample list
RowFirstLastAddressCityStateZIP
2PriyaRaman88 Willow BendNapervilleIL60540
3MarcusBell1402 Elm St Apt 5DaytonOH45402
4GretaLindqvist27 Harbor View RdBellinghamWA98225
8HelenBrightwater46 Quarry LnIthacaNY14850
On the 5160 sheet, as listed
  1. Priya Raman88 Willow BendNaperville, IL 60540
  2. Marcus Bell1402 Elm St Apt 5Dayton, OH 45402
  3. Greta Lindqvist27 Harbor View RdBellingham, WA 98225
  4. Helen Brightwater46 Quarry LnIthaca, NY 14850
  • 4 rows, 4 labels: no first label to copy, no Update Labels.
  • Priya Raman starts the sheet, as the first row starts the list.
  • Change the lines once in the editor and every label follows.

The same labels in three steps, without Word.

  1. Open the list you merged

    The workbook or CSV file as it is, with its header row. The column names tell the editor the name, street, city, state and ZIP.

  2. Pick the sheet

    The number you chose in Word's Label Options, the one on your box. Start at any label of a sheet already used.

  3. Download and print at 100%

    Every row is on its label in the PDF. Print one page on plain paper first and hold it over a sheet.

Numbers to pick in Label Options

The same number in Word and here, the one on the box. Each has a template page with its measurements from Avery's own files.

Numbers to pick in Label Options: size, labels per sheet and the numbers that share each layout
SheetLabel sizePer sheetSame layoutGood for
Avery® 5160 1 × 2-5/8 in 30 8160 · 9160 · 18160 +56 Three lines of a member list, 30 to a sheet.
Avery® 5162 1-1/3 × 4 in 14 8162 · 5262 · 5522 +8 A fourth line for a company or a title, 1-1/3 in tall.
Avery® 5163 2 × 4 in 10 8163 · 18163 · 48163 +29 A ship-to address with a line or two to spare.

Alt+F9 · Option+F9

What Update Labels writes into each label.

A label sheet in Word is a table, a label a cell. Show the field codes and you can see why a label repeats a name or stays empty: the row moves on only where a NEXT field is.

The field codes of the first labels of a merge, and what each prints
LabelIts field codesWhat it prints
Top-left label{ MERGEFIELD First_Name } { MERGEFIELD Last_Name }Priya Raman, from row 2 of the list
Second label{ NEXT }{ MERGEFIELD First_Name } { MERGEFIELD Last_Name }Marcus Bell: NEXT moves on to row 3 first
Third label{ NEXT }{ MERGEFIELD First_Name } { MERGEFIELD Last_Name }and so on, one row a label
A label with no NEXT{ MERGEFIELD First_Name } { MERGEFIELD Last_Name }Marcus Bell again: the row doesn't change
  • Word adds NEXT for you with Update Labels; Rules > Next Record adds one by hand (Microsoft's rule).
  • Here there are no fields: each row of the list is its own label, so nothing has to move on to the next row.

Three things that keep 5160 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 5160 sheet against a window. If it sits off, calibrate once and save the correction for that printer.

Questions people ask

Why is Update Labels greyed out?

The document isn't connected to a list, or it isn't a label merge. Start with Mailings > Start Mail Merge > Labels, then Select Recipients; Word's merge commands come on once it has a list (cause 1).

How do I update all labels in a mail merge?

Set up the top-left label with its fields, then Mailings > Update Labels; in the Windows wizard the link is Update all labels, under Arrange your labels (Microsoft's steps).

Why does only the first label fill in my mail merge?

The others are empty until Update Labels copies the first one to them. If it did and they show «Next Record», choose Preview Results to see the names (cause 3).

What does «Next Record» do in a label merge?

It moves the merge on to the next row of your list. Every label after the first needs one; a label without it repeats the previous row's name (what each label holds).

Do I have to click Update Labels again after a change?

Yes. It copies the first label once; change a field or a font on it and choose Update Labels again (cause 4).

Can I make labels from Excel without Update Labels?

Yes: open the list above. Each row becomes its own label and the PDF is made in your browser, at the size of the sheet.

Rather never click Update Labels again?

The editor fills every label from your rows: change the lines once, leave out duplicates, sort by last name or ZIP code.

Three sheets of Avery 5160 labels in a Word mail merge: the first label set up alone, every label with Next Record after Update Labels, and the names after Preview Results