Ask Your Question

Labels are repeated across page

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

underpope gravatar image

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

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):

  1. 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.
  2. At this point I had a blank sheet with properly formatted labels with all the fields highlighted. I went to Tools -> Mail Merge Wizard.
  3. 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.
  4. 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

2 Answers

Sort by » oldest newest most voted

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

SKelem gravatar image

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

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 more


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 gravatar imageRatslinger ( 2020-01-06 02:02:25 +0200 )edit

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

Ratslinger gravatar image


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 more


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

underpope gravatar imageunderpope ( 2019-01-05 02:27:26 +0200 )edit

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

Ratslinger gravatar imageRatslinger ( 2019-01-05 02:31:20 +0200 )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 gravatar imageRatslinger ( 2019-01-05 03:04:18 +0200 )edit

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

underpope gravatar imageunderpope ( 2019-01-05 16:27:53 +0200 )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 gravatar imageRatslinger ( 2019-01-05 18:03:34 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-03 23:21:38 +0200

Seen: 526 times

Last updated: Jan 06