How to Print Address Labels Using OpenOffice

Last Updated: April 19, 2023

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.

1

Go to the New Labels screen.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3d\/Print-Address-Labels-Using-OpenOffice-Step-1-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/3d\/Print-Address-Labels-Using-OpenOffice-Step-1-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

This will bring you to the Labels dialog screen.

2

Click the "Options" tab.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a9\/Print-Address-Labels-Using-OpenOffice-Step-2-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a9\/Print-Address-Labels-Using-OpenOffice-Step-2-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

3

Remove the checkmark from "Synchronize contents" box.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Print-Address-Labels-Using-OpenOffice-Step-3-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/e\/ef\/Print-Address-Labels-Using-OpenOffice-Step-3-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

It might be checked by default.

4

Click the "Labels" tab.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/db\/Print-Address-Labels-Using-OpenOffice-Step-4-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-4-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/db\/Print-Address-Labels-Using-OpenOffice-Step-4-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

5

Select "Addresses" from the "Database" menu.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Print-Address-Labels-Using-OpenOffice-Step-5-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/3\/39\/Print-Address-Labels-Using-OpenOffice-Step-5-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

6

Select your sheet from the "Table" menu.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Print-Address-Labels-Using-OpenOffice-Step-6-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-6-Version-2.jpg","bigUrl":"\/images\/thumb\/8\/87\/Print-Address-Labels-Using-OpenOffice-Step-6-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

If you renamed it, choose the name of your sheet.

7

Select your label brand.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/78\/Print-Address-Labels-Using-OpenOffice-Step-7-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-7-Version-2.jpg","bigUrl":"\/images\/thumb\/7\/78\/Print-Address-Labels-Using-OpenOffice-Step-7-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

In the US, the standard is Avery.

8

Choose a label type.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fd\/Print-Address-Labels-Using-OpenOffice-Step-8-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-8-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/fd\/Print-Address-Labels-Using-OpenOffice-Step-8-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

A popular one is Avery 5260.

9

Select the database field that contains the first name.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Print-Address-Labels-Using-OpenOffice-Step-9-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a7\/Print-Address-Labels-Using-OpenOffice-Step-9-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

For an address, you would start off with the first name.

10

Click the left-pointing arrow.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a1\/Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a1\/Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
You'll see the arrow at the middle of the window. This adds the selected field to the correct place in the label.
- This puts the appropriate field in the correct place in the label.

11

Press the space bar.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Print-Address-Labels-Using-OpenOffice-Step-11-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/4c\/Print-Address-Labels-Using-OpenOffice-Step-11-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

You'll need to do this so there will be a space between the first and lasts names.

12

Insert the last name.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2a\/Print-Address-Labels-Using-OpenOffice-Step-12-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-12-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/2a\/Print-Address-Labels-Using-OpenOffice-Step-12-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

This prepares the last name to be entered after the space.

13

Click the left-pointing arrow.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a1\/Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/a\/a1\/Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
As it did last time, this adds the field to the preview.
- This puts the appropriate field in the correct place in the label.

14

Go to the next line.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d9\/Print-Address-Labels-Using-OpenOffice-Step-13-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-13-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/d9\/Print-Address-Labels-Using-OpenOffice-Step-13-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

This creates a new line for the street address.

15

Add the street field.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/03\/Print-Address-Labels-Using-OpenOffice-Step-15-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-15-Version-2.jpg","bigUrl":"\/images\/thumb\/0\/03\/Print-Address-Labels-Using-OpenOffice-Step-15-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
Now you can add the rest of the address using the same process.
- 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

Click "New Document" to create your label sheet.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Print-Address-Labels-Using-OpenOffice-Step-16-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-16-Version-2.jpg","bigUrl":"\/images\/thumb\/e\/ef\/Print-Address-Labels-Using-OpenOffice-Step-16-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

You'll see a preview.

17

Open the print dialog.

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Print-Address-Labels-Using-OpenOffice-Step-17-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-17-Version-2.jpg","bigUrl":"\/images\/thumb\/4\/4c\/Print-Address-Labels-Using-OpenOffice-Step-17-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

A box will come up and ask if you want to print a form letter.

18

Select a printer and click "Print."

Download Article

{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c5\/Print-Address-Labels-Using-OpenOffice-Step-18-Version-2.jpg\/v4-460px-Print-Address-Labels-Using-OpenOffice-Step-18-Version-2.jpg","bigUrl":"\/images\/thumb\/c\/c5\/Print-Address-Labels-Using-OpenOffice-Step-18-Version-2.jpg\/aid1941019-v4-728px-Print-Address-Labels-Using-OpenOffice-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}

This sends the labels to your printer.

Community Q&A

Search

Add New Question

Question

How do I print from a template?

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

How can I find my spreadsheets on OpenOffice?

Community Answer

Produce them in openoffice calc, then find them where you filed them, probably in files---documents.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 0

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Video

Tips

Submit a Tip

All tip submissions are carefully reviewed before being published

Submit

Thanks for submitting a tip for review!

Log in

How to Print Address Labels Using OpenOffice

Steps

Go to the New Labels screen.

Click the "Options" tab.

Remove the checkmark from "Synchronize contents" box.

Click the "Labels" tab.

Select "Addresses" from the "Database" menu.

Select your sheet from the "Table" menu.

Select your label brand.

Choose a label type.

Select the database field that contains the first name.

Click the left-pointing arrow.

Press the space bar.

Insert the last name.

Click the left-pointing arrow.

Go to the next line.

Add the street field.

Click "New Document" to create your label sheet.

Open the print dialog.

Select a printer and click "Print."

Community Q&A

Video

Tips

You Might Also Like

References

About This Article

Is this article up to date?

About This Article

Quizzes

You Might Also Like

Featured Articles

Trending Articles

Featured Articles

Featured Articles

Watch Articles

Trending Articles

Explore Categories