How to create labels with consecutive values on all labels on each sheet?

How can I create labels with different data on one sheet, e.g. 72 labels on one sheet and first sheet starts with “1”, ends with 72, second sheet starts with “73”, …?

I always end up with the same value 72 times on one sheet.

Thank you in advance.

@Jaryn, did I rewrite your question correctly? Do you get “1” on all labels on the same sheet, and then “2” on all labels on the second sheet, or “1” on all labels on all sheets?

Sounds like you are missing the “Next record” field.

Select your labels with the “Synchronize contents” (on the Options tab).

In your label document:
Insert - Fields - Other
On the Database tab select Mail merge fields, if your Database (or spreadsheet) is not already “registered”, select Browse to add your database file. Insert the appropriate field(s) for your label, then select the Type “Next record” and insert it one time.

When you have completed formatting that first label, click the Synchronize Labels button to populate the whole form.

Now when you print, each label should contain the data from each database record.

@Jaryn – Did @JohnD’s answer work for you? Are you still looking for a solution?

Great answer! I’ve been frustrated by this for a long time. The problem goes away temporary when using the wizard but comes back again after making any changes outside of the wizard, or is it the first print works but the second doesn’t, or not after reopening the document? I never quite worked out exactly what made it work correctly or stop working correctly, but this seems to have finally fixed a document I use for this type of task every few months.

What I have been trying to do, more not than often is: I am getting ready to set up my old corporation again; I used to make my own return mail labels due to cost; hence, I need the same label on the entire sheet of labels ??? Also, is there a way to do color on labels.