OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Using database file for labels
Goto page Previous  1, 2
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
HaggisForBrains
Newbie
Newbie


Joined: 09 Dec 2010
Posts: 3
Location: Scotland

PostPosted: Thu Dec 09, 2010 7:28 am    Post subject: Reply with quote

Thomas,

Thanks for the quick reply. Clicking on View>Field Names in the label page toggles between this:

<Title> <LastName>
<Address>
<City>
<StateOrProvince>
<PostalCode>

And this:

Addresses.Addresses.Title Addresses.Addresses.LastName
Addresses.Addresses.Address
Addresses.Addresses.City

And so on. In either case if I then go to Page Preview, this switches to the first format, above. I still don't get the actual addresses. Incidentally, the database I am using in this example is called Addresses.odb, and when I click on Data Sources, the correct database appears at the top.

Any more ideas?
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Thu Dec 09, 2010 9:09 am    Post subject: Reply with quote

OK. You want to see the first grouping in your document:
<Title> <LastName>
<Address>
<City>
<StateOrProvince>
<PostalCode>

I don't know how you are doing the preview but try File-->Print and say yes to the form letter prompt. You will then have the option to print all records (default) or selected records. You can also print to a file if you wish. If you open your writer document you can select your query or table and select some records. Then click the Data to Fields icon to see a preview. The Data to Fields icon will only give you one page which is why I suggested the File-->Print approach.
Back to top
View user's profile Send private message
HaggisForBrains
Newbie
Newbie


Joined: 09 Dec 2010
Posts: 3
Location: Scotland

PostPosted: Thu Dec 09, 2010 9:35 am    Post subject: Reply with quote

Thomas,

I was previewing using the Page Preview button. This technique works in MS Works, but clearly not in OOo.

Now I have tried File-->Print and yes to the form letter prompt (although that last step seemed wrong to me), and it worked Very Happy Very Happy ! I can't thank you enough - the Christmas cards will go out on time!

I have to say that OOo is the most counter-intuitive software I have ever used, and the help menu is useless. I bought a copy of Open Office for Dummies from Amazon, and it doesn't even have databases on it! Must be out of date.

Many thanks once again for your help.

Cheers,

Colin.
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Thu Dec 09, 2010 9:45 am    Post subject: Reply with quote

Glad you got it. Yes its not intuitive.
Back to top
View user's profile Send private message
argeeach
Newbie
Newbie


Joined: 18 Dec 2010
Posts: 2
Location: lincolnshire

PostPosted: Thu Dec 23, 2010 3:46 am    Post subject: Reply with quote

I've read these posts with interest as I'm having similar problems. I've set up my information using Base & registered it. am creating the labels OK. Things go wrong when I get to Mail Merge. When that window appears, the databse is shown to the left of a dialogue box. I click on the + sign next to the DB & 2 sublevels appear (+ Queries & + Tables). I click on + Tables & the actual file then appears & when clicking on that all the data shows in the dialogue box. I'm using the Standard filter to select only the fields I want, but when that's sent to the printer it appears as
<Title>
<First Name>
<Last Name>
<Address>
<City>
<Postal Code>
I'm missing something but can't figure out what. Can you help, please?
Richard
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Thu Dec 23, 2010 7:03 am    Post subject: Reply with quote

Make sure that View--->Field Names is turned off.
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Dec 23, 2010 7:46 am    Post subject: Reply with quote

Quote:
but when that's sent to the printer it appears as
<Title>
<First Name>
When you send it to the printer answer 'yes' to the 'form letter' query.
Back to top
View user's profile Send private message
argeeach
Newbie
Newbie


Joined: 18 Dec 2010
Posts: 2
Location: lincolnshire

PostPosted: Fri Dec 24, 2010 2:04 am    Post subject: Reply with quote

Thanks for replying, guys. Before going through the whole thing again, can I check the following?
- is there another way to turn View->Fields off besides not using that step?
- should I expect to see the information change from the Field headings to the actual information I want? (ie people's names & addresses)

Richard
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Fri Dec 24, 2010 8:29 am    Post subject: Reply with quote

Quote:
- is there another way to turn View->Fields off besides not using that step?
There is a keyboard toggle - Ctrl+F9.
Quote:
should I expect to see the information change from the Field headings to the actual information I want? (ie people's names & addresses)
No, but you can make it happen for one page only. Open your document, press F4, open your database, open the Tables item and click your table. Select one or more records with the boxes to their left and click the Data to Fields icon.

To see all your records you can do as I said in my prior post and print to a file.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group