[Solved] Printing lables

Creating tables and queries
Post Reply
profoundnovice
Posts: 5
Joined: Thu Oct 23, 2014 11:43 pm

[Solved] Printing lables

Post by profoundnovice »

I have created a mailing list in the Dadabase. Now want to print labels. Have followed instructions to print but having trouble with the Label tab in "print". I can pull up the name of the database but it does not seem to recognize any of the tables. It is just blank in the selection box. What am I doing wrong? Thanks.
Last edited by thomasjk on Wed Nov 05, 2014 6:32 am, edited 1 time in total.
Reason: Mark thread [Solved] and add green checkmark
OpenOffice 4.0.1
Windows 8
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Printing lables

Post by Nocton »

I do not understand where you have got to when you say ' but having trouble with the Label tab in "print"'.
You should:
- register your database
- from the database go to File/New -->Labels
- then select your database, the required table and the required fields
- format, etc. as required
- click on New Document to create your labels
- then File/Print when you data should show and be ready to print

Regards,

Nocton
OpenOffice 4.1.12 on Windows 10
profoundnovice
Posts: 5
Joined: Thu Oct 23, 2014 11:43 pm

Re: Printing lables

Post by profoundnovice »

Thanks Nocton. My problem starts with your 3rd bullet point. I select my database but no tables appear in the table field. It is as though I haven't any tables, which I do. Have I missed a step?
OpenOffice 4.0.1
Windows 8
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

Re: Printing lables

Post by F3K Total »

Nocton wrote: - register your database
has to be done via Tools/Options/OpenOffice Base/Databases -> New ... -> Browse ...
see picture
Register.png
HTH R
  • MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
  • my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
profoundnovice
Posts: 5
Joined: Thu Oct 23, 2014 11:43 pm

Re: Printing lables

Post by profoundnovice »

It is registered.
OpenOffice 4.0.1
Windows 8
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Printing lables

Post by thomasjk »

Open a Writer document. Press F4. Do you see your database in the listing at the top?.
Attachments
Capture.PNG
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
profoundnovice
Posts: 5
Joined: Thu Oct 23, 2014 11:43 pm

Re: Printing lables

Post by profoundnovice »

Pressed F4. It is there.
OpenOffice 4.0.1
Windows 8
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Printing lables

Post by Nocton »

So it is still a mystery why you cannot see your tables.

I am using OO 4.1. In Writer go to File/New -->Labels
Then the wizard should open and this is what you see.
LabelWizard.png
In this example I have selected the registered Base file MyLibrary
I have then selected a table - Locations
I have then chosen a field - Location
Please tell us what you see when you follow this procedure, which should be simple and straightforward. If still failing, please attach your database.

Regards,

Nocton
Last edited by Nocton on Tue Nov 04, 2014 9:15 pm, edited 1 time in total.
OpenOffice 4.1.12 on Windows 10
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Printing lables

Post by thomasjk »

profoundnovice wrote:Pressed F4. It is there.
Do you see any queries or tables if you click on the plus sign to expand the view. Post a screen shot of the view you see. See viewtopic.php?f=74&t=8289 for instructions.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
profoundnovice
Posts: 5
Joined: Thu Oct 23, 2014 11:43 pm

Re: Printing lables

Post by profoundnovice »

I think I've got it now. I changed the name of my database from ChristmasCard to ChristmasCards and it works now. Don't know why but grateful none the less. Thanks to all for you time and patience.
OpenOffice 4.0.1
Windows 8
halfaheart
Posts: 5
Joined: Mon Dec 04, 2017 9:37 pm

Printing lables from Table: [Solved] Printing lables

Post by halfaheart »

I have created a database, then a table. From File; New- Lables. From the Lables box, selected the database and the table, then selected the Fields I want printed then clicked New Document. All that I get is screen with the lables containing the Field Names that was selected. What have I missed?
halfaheart Windows 10 OpenOffice4.1.4
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: [Solved] Printing lables

Post by Nocton »

May I suggest that you start a new thread as this a completely new topic. And perhaps you could explain what you wish to do in a bit more detail.
(By the way it is 'labels' - if English were more logical it would be lable, like table! Or Tabel like Label - more Germanic)
OpenOffice 4.1.12 on Windows 10
Post Reply