Here's how to do labels.
First, get your data in a spreadsheet, text file, address book, and create a database. You can do this by choosing File > New > Database.
Then, once you've got the database set up in OpenOffice.org, you're ready to go.
1. Choose File > New > Labels. (To do Envelopes, open an OpenOffice.org Writer document, and choose Insert > Envelope.)
2. In the Labels tab of the Labels window, select the database you created in the Database dropdown list. You're looking for the name of the database you created by choosing File > New > Database, not the spreadheet, addressbook, or text file containing the data.
3. Select a table from the Table list. This will be Sheet1 or whatever the sheet name is, if you are using a spreadsheet to hold your data.
5. Click the arrow next to it to insert it in the Label Text field.
Type a space after the field and you can add the next field, such as LastName.
6. Use the Database Field list to insert any other fields you need. If you want fields on the second line, click after the last character of the last field you inserted, in the big text box, and just press Enter. If you need to change the arrangement later in the created label document, you can.
7. In the Brand dropdown list, select Avery Letter Size if you're not using A4.
9. This step and step 10 , and step 15, are optional but recommended. Click the Options tab.
11.Click the Setup button next to the printer display.
12. Select the printer you want to print to.
13. In the printer options (this will vary according to your operating system) specify the appropriate paper feed or tray. For now, select Manual Feed.
14. Click the New Document button at the bottom of the window. The labels will appear. This is how it's supposed to look. You won't see the data, you'll see the field names like first name. When you print, the correct data will appear.
15. OPTIONAL: IF YOU SELECTED THE SYNCHRONIZE CONTENTS CHECKBOX
If you need to make changes, like adding spaces, rearranging fields, or changing formatting, do so in the upper left label. Make the text an interesting font, or make it the size you need. You
can also right-click on the border of the upper right label, choose
Frame, go to the Border tab, and give it a background color.
Then click Synchronize to apply those changes to all labels.
16. Choose File > Print. A message will ask if you want to print a form letter. Click Yes.
17. If you want to print labels for only certain records, you can select them in the scrolling list of records. Select one, press Ctrl, select the next, and so on. Or you can select a range of records like 1-20.
18. If you want to just print all the labels, choose All.
19. When you're ready, just click OK. You'll be prompted again to choose your printer. Print normally.
Note: If you have any problems printing, check your printer setup using your operating system setup tools.
Note: You can save the label document and just go back to it again when you need to use it again.