How to Print Address Labels Using OpenOffice

2025 Author: Samantha Chapman | [email protected]. Last modified: 2025-01-24 13:28

If you have a list of addresses contained in a spreadsheet or database, you will be able to use it to print labels. Read on to find out what all the steps are to take.

Steps

Print Address Labels Using OpenOffice Step 1

Step 1. From the 'File' menu, select the 'New' item and then 'Labels'

The dialog box for creating labels will appear.

Print Address Labels Using OpenOffice Step 2

Step 2. Select the 'Extras' tab

Print Address Labels Using OpenOffice Step 3

Step 3. Make sure the 'Synchronize content' checkbox is not checked '

Print Address Labels Using OpenOffice Step 4

Step 4. Select the 'Labels' tab

Print Address Labels Using OpenOffice Step 5

Step 5. In the 'Database' drop-down menu, select the data source that contains the address list, in the example 'Addresses'

Print Address Labels Using OpenOffice Step 6

Step 6. In the 'Table' drop-down menu, select the name of the sheet containing the data, by default 'Sheet1'

Print Address Labels Using OpenOffice Step 7

Step 7. In the 'Brand' drop-down menu, select the brand of labels you want to use

In the United States the standard is 'Avery'.

Print Address Labels Using OpenOffice Step 8

Step 8. In the 'Type' drop-down menu, select the label template you will use

Print Address Labels Using OpenOffice Step 9

Step 9. From the 'Database Field' menu, select all the fields you want to insert into your label

As this is a shipping label, the first field will be the 'name' field.

Print Address Labels Using OpenOffice Step 10

Step 10. Select the arrow button located to the left of the 'Database Field' menu, indicated in the image

This will insert the appropriate field in the correct position within the label

Print Address Labels Using OpenOffice Step 11

Step 11. Press the 'spacebar' on your keyboard to separate the fields inside the 'Label text' box

Print Address Labels Using OpenOffice Step 12

Step 12. Use the 'Database Field' drop-down menu again to select the 'Last Name' field

Print Address Labels Using OpenOffice Step 13

Step 13. Press the 'Enter' key

This will move you to the second line of the 'Label text' box.

Print Address Labels Using OpenOffice Step 14

Step 14. Use the same procedure to enter the following fields:

Print Address Labels Using OpenOffice Step 15

Step 15. Add the 'address' field

Add the 'city' field.
Enter the character ','.
Press the 'space bar' and enter the 'Status' field.
Press the 'space bar' and enter the 'postal code' field.

Print Address Labels Using OpenOffice Step 16

Step 16. At the end of the label structure creation procedure, press the 'New document' button

This will create a new sheet with the filled labels. In the photo you can see an example of what you should see on screen (in a new document).

Print Address Labels Using OpenOffice Step 17

Step 17. From the 'File' menu, select the 'Print' item (or use the 'Ctrl + P' hotkey)

OpenOffice will automatically detect the presence of labels and ask you to do a batch print.

Print Address Labels Using OpenOffice Step 18

Step 18. Press the 'Yes' button

Print Address Labels Using OpenOffice Step 19

Step 19. In the 'Batch Print' window that appears, be sure to select all the addresses you want to print the label for

Select the desired printer and print settings, then press the 'Print' button.

Recommended:

How to understand the symbols on clothing labels

At first glance, clothes cleaning labels can confuse you. While each country has different systems for these labels, many are adapting to the use of an international standard. If you learn the meaning of each symbol, you will be able to recognize them right away the next time you decide whether to machine, bleach, dry, iron or dry clean a garment.

How to Print Multiple Images on a Single Page Using a PC or Mac

This article explains how to print multiple images on a single page using a PC or Mac. Make sure the printer is turned on and the paper tray is loaded. Also, check that the printing device is properly connected to your computer before continuing.

How to Print on an Envelope Using Microsoft Word

Not all of us have perfect writing, especially when we are dealing with an entirely white sheet of paper, devoid of any guidelines. This tutorial shows you how to perfectly print an address on an envelope. Steps Step 1. Turn on your printer Step 2.

How to Print on Avery Labels Using Microsoft Word on PC and Mac

This article explains how to print labels using adhesive labels manufactured by Avery and the Microsoft Word program on both Windows and Mac computers. Avery no longer distributes its own Word add-in which provided a wizard for creating and printing labels.

How to find the GPS coordinates of an address using Google Maps

Have you ever entered an address into your GPS navigation system, only to find that it cannot be found? If you don't update your GPS often, new streets and changed addresses cannot be included. Upgrading can be expensive though, so you can use the Google Maps trick to find the GPS coordinates of an address.