[Solved] printing labels from a table

Creating tables and queries
Post Reply
halfaheart
Posts: 5
Joined: Mon Dec 04, 2017 9:37 pm

[Solved] printing labels from a table

Post by halfaheart »

I have tried to print labels from a table, I followed the directions: From the database created a table, then File; New; Labels. In the labels box, I selected the database, Table and selected the Fields that I want printed. Clicked of new document and I only get a page of labels containing the Field Names. I have repeated the process, while checking the directions to make sure that I didn't miss something. No luck, what am I missing or doing wrong?
Last edited by robleyd on Wed Dec 06, 2017 1:07 am, edited 1 time in total.
Reason: tagged [Solved] by robleyd
halfaheart Windows 10 OpenOffice4.1.4
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: printing labels from a table

Post by Villeroy »

Go ahead and print the labels.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
halfaheart
Posts: 5
Joined: Mon Dec 04, 2017 9:37 pm

Re: printing labels from a table

Post by halfaheart »

I printed the sheet and it's just Field Names?
halfaheart Windows 10 OpenOffice4.1.4
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: printing labels from a table

Post by UnklDonald418 »

From the document filled with Field Names press <Ctrl> P
You should get a dialog asking “Do You Want to Print a Form Letter”, answer Yes.
You should now see the Mail Merge dialog.
To test it select the File option and Save as single document and press OK
The Save As dialog allows you to chose a name for the merged file.
Now open the newly created merged file to see what your labels will look like.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
halfaheart
Posts: 5
Joined: Mon Dec 04, 2017 9:37 pm

Re: printing labels from a table

Post by halfaheart »

Nothing happens when I press <Ctrl>P. Another thing is the page with the label(Field Names) has only 20 labels and there are 47 records?
halfaheart Windows 10 OpenOffice4.1.4
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: printing labels from a table

Post by UnklDonald418 »

the page with the label(Field Names) has only 20 labels
is a template so if you only see 20 labels that means that you have chosen a predefined type of label that contains 20 labels per page.
I don't know why <Ctrl>P wouldn't work. Alternatively use File->Print to get the dialog asking “Do You Want to Print a Form Letter?”
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
halfaheart
Posts: 5
Joined: Mon Dec 04, 2017 9:37 pm

Re: printing labels from a table (SOLVED)

Post by halfaheart »

Thank you that worked.
halfaheart Windows 10 OpenOffice4.1.4
Post Reply