Ask Your Question
0

How to create labels with different data on one sheet

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

Jaryn gravatar image Jaryn
1 1

updated 2013-02-19 02:34:33 +0200

qubit gravatar image qubit flag of United States
5693 3 48 41

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 ended with same value 72 times on one sheet. Thank you in advance. Jaryn

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted
1

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

JohnD gravatar image JohnD
390 1 4 9

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.

link delete flag offensive edit

Comments

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

qubit ( 2013-03-13 09:35:23 +0200 )edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

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

Seen: 226 times

Last updated: Jun 10 '12