how to use labels in openoffice 3.2

Tony Pursell suggests this article as an answer to your question:
FAQ #1433: “How do I print Labels from data in a spreadsheet?”.

Hi

I have given you a link to a FAQ I did a while ago because it contains some general ideas on producing labels. I realise it may not answer your question.

I will need a better description of what you are trying to print. Are these tabs arranged as parts of a larger sheet, n tabs across and m tabs down? Or are the single pieces in a continuous roll, or something. A more complete description with sizes and shapes would be useful.

Also, for completeness, please tell us which versions of OpenOffice.org and Ubuntu you are using.

Tony

These are Avery "Big Tab" inserts. The document to be printed appears in the center of an 8.5 by 11 page..bordered by printing tips on each of the two outer columns. The two column tabs are in horizontal side by side and each pair is par of the total of the tabs that run the 11' length.
They two columns of blank tabs serve as inserts for plastic subject dividers[which extend outside of the normal 8.5 by 11 page. for three ring notebooks.
Thanks for the help thus far.. I will study the FAQ #1433

Hi

Are they like this:

http://www.avery.com/avery/en_us/Products/Dividers/Insertable-Dividers/WorkSaver-5-.5in-x-8-.5in-Insertable-Tab-Dividers-with-Buff-Paper_11102.htm?N=4294967277&Ns=&refchannel=dcc91828c503a110VgnVCM1000002118140aRCRD

In which case you may find them listed under Format on the Labels dialogue as a Type with Brand changed to Avery Letter Size. If not, you will have to put the data from the printing tips (Para 4 in the example in the link above) into the label dimensions on the Format tab and Save them as a user defined format.

To follow the FAQ I quoted, you will first need to list the tab contents in a Calc spreadsheet. You will probably only need one column of data with a heading in row 1 (say, 'Tab Text') with each cell below it containing the text for one of the tabs. Does your format have 2 columns of 26 rows of tabs? Then you will have to repeat the tabs as many time as you need to fill the page. For the example from the link above, which only has 5 tabs, you would need them repeated 10 times and 2 tabs will be unused.

Just one tip - always print on plain paper first to check that the printing is correctly lined up.

Let me know how you get on and do get back to me if you need more help.

Tony

PS If this answers your question, please mark it as Solved