Page 1 of 1

[Solved] Creating labels from spreadsheet database

PostPosted: Thu Aug 13, 2020 11:32 pm
by gianfrancs
Hi. I am having some difficulty creating mailing labels from a spreadsheet of my clients. I have successfully made a database of the spreadsheet, and I input the information to create the labels. The problem is they are not printing the individual information for each client in the spreadsheet. All I am getting in both the print preview or the printed version is:

<FName> <LName>
<address>
<city><state><zip>

It prints out exactly as seen on every single label. What am I missing?

:crazy:

Re: Creating Labels from spreadsheet database

PostPosted: Fri Aug 14, 2020 9:01 am
by Villeroy
Open the attached document. It is connected to the "Bibliography" database which is shipped with your office suite.
When you are going to print the document, you will be asked if you want to print a serial letter. Answer Yes.
Then you can decide if you want to print all records, filtered or selected records and if you want to print to a file or to a physical printer.
---------------
How I created this:
Hit F4 to open the data source window.
Select table "biblio" of database "Bibliography".
Drag grey column headers into the document.
Save as Open Document Text (*.odt).
----------------
Same thing with labels created by the label wizard: http://forum.openoffice.org/en/forum/do ... hp?id=8714

Re: Creating Labels from spreadsheet database

PostPosted: Fri Aug 14, 2020 2:08 pm
by gianfrancs
I thank you, that worked beautifully. I had completed every step except the save and print. I was going straight to print which gave me only the blank pages.