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 -> Labelsin 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!
