Ask Your Question

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

asked 2012-06-10 18:22:00 +0100

Jaryn gravatar image

updated 2014-07-06 16:14:43 +0100

bencomp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-28 20:31:59.760178


@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?

bencomp gravatar imagebencomp ( 2014-07-06 16:17:22 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-06-10 23:49:34 +0100

JohnD gravatar image

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.

edit flag offensive delete link more


@Jaryn -- Did @JohnD's answer work for you? Are you still looking for a solution?

qubit gravatar imagequbit ( 2013-03-13 09:35:23 +0100 )edit

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.

Stillwit gravatar imageStillwit ( 2014-03-11 14:45:47 +0100 )edit

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.

Crazy Horse 34 gravatar imageCrazy Horse 34 ( 2015-09-20 16:41:24 +0100 )edit

Question Tools

1 follower


Asked: 2012-06-10 18:22:00 +0100

Seen: 2,893 times

Last updated: Jul 06 '14