A crude, ad hoc table with some mailing addresses. The “set” of “data” I’m dealing with is very, very basic. I’ve only ever used the Firebird embedded database with my Libre Office. I tried to correct that, but found the information offered wouldn’t fit in a comment.) ANYWAY… Initially, that was a new-user-of-this-forum mistake. (and apologies… (again- I did an edit, but it disappeared!) for putting this in the “Answers” section. Experienced OPEN Office user… moving to LO. I’ve been having exactly the same problem. This started as just some quick observations… please don’t “shoot me” for lack of detail, even now… but… How Do I Create Labels from a SpreadsheetĪs well as the LO documentation which I downloaded. I also confirmed that the database table has sixty records in it. I confirmed that my spreadsheet has sixty rows of data (61, including the column headings row). 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.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.At this point I had a blank sheet with properly formatted labels with all the fields highlighted.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.

Opened Writer, went to File -> New -> Labels in order to generate a sheet of labels.

Steps I took (after creating a “holidaylabels” database in Base from the “holidaylabels” spreadsheet the spreadsheet had 60 items in it): 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.Īnyone have any idea as to what I am doing wrong?

For example, John Smith’s address label is repeated over an entire page, then Jane Doe’s on a separate page, and so on. 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. I’ve created a mailing list database using instructions listed on this site (by registering the spreadsheet as a database, etc.).

Libreoffice writer labels