Labels are repeated across page
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!
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)