How to Print Address Labels Using OpenOffice

If you have an address book in a spreadsheet or a database, you may want to use them for printing labels. This article will tell you how.

Steps

  1. Image titled Print Address Labels Using OpenOffice Step 1
    1
    Click on File >> New >> Labels. This will bring you to the Labels dialog screen.
  2. Image titled Print Address Labels Using OpenOffice Step 2
    2
    Click on the Options tab.
    Advertisement
  3. Image titled Print Address Labels Using OpenOffice Step 3
    3
    Be sure that the Synchronize Contents box is unchecked.
  4. Image titled Print Address Labels Using OpenOffice Step 4
    4
    Select the Labels tab.
  5. Image titled Print Address Labels Using OpenOffice Step 5
    5
    In the Database pull down menu, select Addresses.
  6. Image titled Print Address Labels Using OpenOffice Step 6
    6
    In the Tables pull down menu, select Sheet 1 (unless you renamed it).
  7. Image titled Print Address Labels Using OpenOffice Step 7
    7
    In the Brand pull down menu, select the correct brand name for your labels. In the US, the standard is Avery.
  8. Image titled Print Address Labels Using OpenOffice Step 8
    8
    In the Type pull down menu, select the type of label that you will be using. A popular one is Avery 5260.
  9. Image titled Print Address Labels Using OpenOffice Step 9
    9
    In the Database Field pull down menu, select the field you want. For an address, you would start off with the first name.
  10. Image titled Print Address Labels Using OpenOffice Step 10
    10
    Click the left pointing arrow indicated above in the screenshot.
    • This puts the appropriate field in the correct place in the label.
  11. Image titled Print Address Labels Using OpenOffice Step 11
    11
    Press the space bar to create a space in the 'Label text' block.
  12. Image titled Print Address Labels Using OpenOffice Step 12
    12
    Using the Database Field pull down menu, select the last name.
  13. Image titled Print Address Labels Using OpenOffice Step 13
    13
    Hit Enter. This takes you to the second line.
  14. Image titled Print Address Labels Using OpenOffice Step 14
    14
    Using the same process, continue.
  15. Image titled Print Address Labels Using OpenOffice Step 15
    15
    Add the Street field.
    • Add the name of the city
    • Type in a comma (,).
    • Hit the space bar and then add the State Field.
    • Hit the space bar and then add the Zip code field.
  16. Image titled Print Address Labels Using OpenOffice Step 16
    16
    Click on New Document to create your sheet of labels. This is what it should look like now (the new document).
  17. Image titled Print Address Labels Using OpenOffice Step 17
    17
    Click File >> Print (Ctrl P). A box will come up and ask if you want to print a form letter.
  18. Image titled Print Address Labels Using OpenOffice Step 18
    18
    Select Print.
  19. Image titled Print Address Labels Using OpenOffice Step 19
    19
    Be sure that Printer and the records that you want to print are selected and print.
    Advertisement

Community Q&A

  • Question
    How do I print from a template?
    Selvesh
    Selvesh
    Community Answer
    1.Click on the Mailings tab in the Microsoft word menu bar. 2.Choose Labels. 3.In the dialogue box that opens, select Option. 4.Click on the labels vendors drop down and select OnlineLabels.com and the product number of the label you`re printing. 5.Click OK.
  • Question
    How can I find my spreadsheets on OpenOffice?
    Community Answer
    Community Answer
    Produce them in openoffice calc, then find them where you filed them, probably in files---documents.

You Might Also Like

Make Labels Using Open Office Writer
How to
Make Labels Using Open Office Writer
Use OpenOffice Writer
How to
Use OpenOffice Writer
Create a Check Register with OpenOffice Calc
How to
Create a Check Register with OpenOffice Calc
Create an OpenOffice.org Database
How to
Create an OpenOffice.org Database
Create a PDF File with OpenOffice
How to
Create a PDF File with OpenOffice
Remove Duplicates in Open Office Calc
How to
Remove Duplicates in Open Office Calc
Change Margins in OpenOffice
How to
Change Margins in OpenOffice
Create an OpenOffice Macro
How to
Create an OpenOffice Macro
Create an Address Book Using Open Office Calc
How to
Create an Address Book Using Open Office Calc
Learn Spreadsheet Basics with OpenOffice Calc
How to
Learn Spreadsheet Basics with OpenOffice Calc
Draw an Arrow in Open Office Draw
How to
Draw an Arrow in Open Office Draw
Draw Basic Shapes Using Open Office Draw
How to
Draw Basic Shapes Using Open Office Draw
Install Apache OpenOffice in Linux
How to
Install Apache OpenOffice in Linux
Create a Flyer in Open Office Writer
How to
Create a Flyer in Open Office Writer
Advertisement

References

  1. Original information comes from TutorialsForOpenOffice

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 77,834 times.
How helpful is this?
Co-authors: 2
Updated: June 3, 2021
Views: 77,834
Categories: OpenOffice.org
Advertisement