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

creating address labels

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
thunderhead
Newbie
Newbie


Joined: 18 May 2008
Posts: 1

PostPosted: Sun May 18, 2008 11:14 am    Post subject: creating address labels Reply with quote

Can someone explain to me how to create and print address labels on Avery 8160 labels.
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


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

PostPosted: Mon May 19, 2008 11:39 am    Post subject: Reply with quote

Assumptions - your addresses are in a database and your database is registered as an OOo data source. Some addresses are 3 lines and some 4 lines.

File > New > Labels. On the Labels tab set the Brand to Avery Letter Size using the drop down menu and set Type to 8160. Use the Database drop down to select your DB, same with the Table drop down then use the Database Field drop down to select one field at a time and the arrow to move it into the Label Text window. You can do basic editing in this window.

Go to the Options tab, check Synchronize and click the New Document button.

Turn on View > Nonprinting Characters (Ctrl+F10 will toggle this). The last line of the address block will be followed by a paragraph break but the other lines will end with a line break. In the upper left label delete the line breaks and tap Enter to change to a paragraph break.

Now let's assume you have a field named Address2 which is only used in 4 line address blocks. Again In the upper left label click in the Address2 paragraph and do Crtl+F2 > Function tab, select Hidden Paragraph, set the Condition as Not Address2 and click insert. Click the Synchronize button to pass theses edits to all other labels.

To print your labels click the Print icon and answer 'yes' to the 'form letter' query. In dialog that follows All records is the default but you can select records with the gray boxes to their left.

If any of this doesn't work then please note your OOo version and your OS in any reply.
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 Writer All times are GMT - 8 Hours
Page 1 of 1

 
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