Labels are repeated across page

asked 2019-01-03 23:21:38 +0100

underpope
1 ●1 ●1 ●2

updated 2019-01-05 02:29:07 +0100

I've created a mailing list database using instructions listed on this site (by registering the spreadsheet as a database, etc.). I've created my labels by using File -> New -> Labels but when I go to use the mail merge wizard, it generates whole pages of repeated labels for each address in the list. For example, John Smith's address label is repeated over an entire page, then Jane Doe's on a separate page, and so on. Ideally I'd get a label for John Smith, then a label for Jane Doe, and so on, and not entire sheets of labels for each.

Anyone have any idea as to what I am doing wrong?

EDITED to add details

OS: Kubuntu Linux 18.10 LO Version: 16.1

Steps I took (after creating a "holidaylabels" database in Base from the "holidaylabels" spreadsheet; the spreadsheet had 60 items in it):

Opened Writer, went to File -> New -> Labels in order to generate a sheet of labels. I selected the "holidaylabels" database, added the fields to the template, selected a label format, then under the Options tab I made sure "Synchronize Contents" was selected.
At this point I had a blank sheet with properly formatted labels with all the fields highlighted. I went to Tools -> Mail Merge Wizard.
In the Mail Merge wizard, I clicked on "Next" on the first screen, then "Finish" because I knew I did not need all of the options.
Then when I clicked on "Edit Individual Documents", it generated sixty pages, each with a full sheet of labels for each address in my database.

I confirmed that my spreadsheet has sixty rows of data (61, including the column headings row). I also confirmed that the database table has sixty records in it.

I got my instructions from:

How Do I Create Labels from a Spreadsheet

as well as the LO documentation which I downloaded.

Hope that clears things up!

edit retag flag offensive close merge delete

Comments

Hello, I found your post looking for answers to the same issue (new to LO, using version 6.4 on a mac). In reading through the Writer Guide I happened upon some information that I think will solve the problem -- it did for me! I won't post under 'Answers' since I am new to the site and not sure this will solve the problem for everyone, but if it helps I thought it worth sharing. From Writer Guide Pg15, section 5.4 on Mail Merge (https://wiki.documentfoundation.org/i...):

"The last paragraph of the label address block ends with a special field, Next record:Database.Table (Next record:Points.Sheet1 in our example) "

This field is 'hidden' in the standard label view for editing layout/font/etc before you print (it's represented by a shaded space), until you activate View->Field Names from the menu. In modifying the ...(more)

jmopo ( 2021-01-20 04:41:28 +0100 )edit

add a comment

3 Answers

Sort by » oldest newest most voted

answered 2021-01-11 13:39:20 +0100

MSPhobe
3 ●2 ●3 ●6

updated 2021-01-12 02:28:00 +0100

Ratslinger
25761 ●9 ●35 ●134

This started as just some quick observations... please don't "shoot me" for lack of detail, even now... but...

I've been having exactly the same problem. LO with embedded Firebird on Win10. Experienced OPEN Office user... moving to LO.

(and apologies... (again- I did an edit, but it disappeared!) for putting this in the "Answers" section. Initially, that was a new-user-of-this-forum mistake. I tried to correct that, but found the information offered wouldn't fit in a comment.) ANYWAY...

I've only ever used the Firebird embedded database with my Libre Office.

The "set" of "data" I'm dealing with is very, very basic. A crude, ad hoc table with some mailing addresses. All fields of type "text [var char]".

I'm trying to have the system print the results of a query which filters which records are included, and sorts the records.

Ah... 90 minutes later...

I've done the "same thing" several times now... sometimes getting the RIGHT answer (one copy of each label, with many different labels on each sheet)... and sometimes again getting the SHEETS, each filled with multiple copies of one of labels I'm trying to print.

Sigh.

Can't figure out what I do differently in the different cases... but the original poster is not alone. For the next people on this quest...

a) You don't have to send the output to a file to save printing endless "bad" sets while struggling. The "ordinary", "print to printer" process has a preview stage that is sufficient to see what the result of your latest experiment would be. Just "cancel", after you've seen, and you can eat your cake (see what would happen) without having to eat it (use paper and ink.)

b) I've done a little bit of "re-arranging" of the positions of the fields on the labels after they are "dropped" there by the label spec process. That's about the only "clever" thing I've done, and that doesn't seem to be where the problem lies.

c) Not(?) related... but along the way, I've learned that if you want to put more than about 3(!) fields on the label, you can skip doing it via the tedious mechanism present in the "start a sheet of labels" wizard. Put at least one field on the spec during the wizard. Then, once the thing is up on your screen, while in design mode, use Insert/Fields/More Fields, and that will take you to a better place.

d) Seeming at random(!) a dialog pops up saying "The document contains embedded HSQL data, which is deprecated. Would you like to migrate to Firebird now?" That puzzles me, as I don't believe I've used HSQL at any point in this exercise. I usually say "later", as the few times I've tried "migrate" (here) either I got nowhere, or ran into some wall or other. (I may have misread the screen, but I'm pretty sure that when ... (plus)

edit flag offensive delete link

Comments

Abbreviated or not, Please refrain from unacceptable language.

You dialogs are not unusual. When accessing the data sources the system is getting all registered Base files. This could involve some with HSQLDB and if Enable experimental features is on (or an older version of LO) a conversion message pops up. This as well for other registered databases requiring a log in.

Ratslinger ( 2021-01-12 02:35:15 +0100 )edit

add a comment

answered 2019-01-03 23:53:34 +0100

Ratslinger
25761 ●9 ●35 ●134

Hello,

For label processing instructions you can use the LO documentation found here -> LibreOffice Writer Guide. See Chapter 14 - Mail Merge.

You have not provided the steps you used or even a link to the directions you followed. You also have not provided the LO version you are using or your OS. But possibly this will help.

Once you have gone through the initial 'Label' dialog (where you select label format & fields) you select the New Document button. Once on this new document you can set any formatting you choose and apply to all labels provided Synchronize contents was set on the Other tab in the dialog (see documentation for more information).

Now the labels are ready for the next step. Select print. A message appears:

Your document contains address database fields. Do you want to print a form letter?

Select Yes. This presents the Mail Merge dialog where you select some or all records to print. Once selected the OK button will take you to actually printing the labels.

edit flag offensive delete link

Comments

I edited my question to include the information you asked for. Sorry for the confusion.

underpope ( 2019-01-05 02:27:26 +0100 )edit

Did you try my instructions or at least look at the pointed to documentation?

Ratslinger ( 2019-01-05 02:31:20 +0100 )edit

Just retested using your instructions. Cannot duplicate. Get individual records all on one page of labels. Must be more to what you have. Ran on Mint 18.3 with LO v6.1.4.2

Ratslinger ( 2019-01-05 03:04:18 +0100 )edit

Yes, I tried your instructions and read the documentation. Nothing helped.

underpope ( 2019-01-05 16:27:53 +0100 )edit

Based on your comment and after having done this numerous times without this type of problem, I can only further suggest you first trying to run in Safe Mode. This is available under the Help menu as Restart in Safe Mode. A further description is found here -> LibreOffice user profile.

If after this it is still is not working, file a bug report here -> Bugzilla.

Ratslinger ( 2019-01-05 18:03:34 +0100 )edit

I have the same issue using version 6.3 and 7.0 when creating labels. I've even tried Safe Mode. But to be honest I don't have any custom settings or configs setup. So as expected it did not help either.

I've inserted Next Fields in all the ways I know how. But in the end Libre-Office either prints one label per page or if synchronized prints a page of each record. Both options are wasteful if you only need one label of a heap records.

What I've done. I've read through all the forum posts I could get my hands on. I've read the official documentation - but this does not specify how to print one or several of each record.

Codes9 ( 2020-09-21 11:50:19 +0100 )edit

add a comment

answered 2020-01-06 01:48:49 +0100

SKelem
1 ●1

updated 2020-01-06 01:51:02 +0100

Safe Mode? I'm experiencing the same problem on Ubuntu Linux. There's no such thing as Safe Mode in Linux.

The issue is whether each database entry populates a single label or all the labels on a page. There's a need for both:

When I'm making my return address labels, I want the same return address on every label. When I'm printing directly onto an envelope, I want one address per envelope.

When I'm making my outgoing address labels, I want only one label for each address, packing as many individual labels onto a sheet as are provided by the label maker.

edit flag offensive delete link

Comments

Please only post as an answer when actually answering the original question. It should actually be posted as a comment or a new question (nothing in this posted question about envelopes).

Yes there is a Safe Mode. In the comment it states it is under the Help menu - this is for LibreOffice menu whether on Linux or other OS'es. There is also a link in the comment with further explanation on Safe Mode (User Profile).

Ratslinger ( 2020-01-06 02:02:25 +0100 )edit

add a comment

Labels are repeated across page

Comments

3 Answers

Comments

Comments

Comments

Question Tools

Stats

Related questions

Labels are repeated across page edit

Comments

3 Answers

Comments

Comments

Comments

Question Tools

Stats

Related questions

Labels are repeated across page