Share your knowledge at the LQ Wiki.
Go Back > Articles > Business Use
User Name


By solveig at 2006-08-26 16:01

If you've ever spent hours at work doing mailings, cursed your printer for printing outside the lines on your labels, or moaned “There has got to be a better way to do this,” here's the solution you've been looking for. Working smarter, not harder, with the OpenOffice label templates will save you time, effort, and (if you want) make really cool-looking labels.

Using the Right Tool for the Job

I believe in using tools. And if the tools are easy to use and free, so much the better. That's why I'm a big proponent of using templates. Templates are one of the best ways to save time, effort, and be sure that your documents are consistent when they need to be.

Templates make life easier when you use them for letters, documents, brochures, etc. but they really make life easier when you use them for labels. The spacing for your label documents has to be extraordinarily precise to make sure that the text is printed exactly where it needs to be—I've tried making my own and while it's possible, it's really not worth it. It's not worth it primarily because there are so many excellent pre-existing templates to use instead.

There might be a few sheets of labels somewhere without a corresponding label template, but they're rare. You can print on virtually any label sheets you want with the templates included in, and the templates available on the web, such as those from WorldLabel.

This article is about how to use the templates, in particular the WorldLabel templates, to print the labels you need. I'll talk about how to download them, install them, use them as they are, and how to customize them with graphics and other features.

I'll also touch on how to use the label wizard; you can use the label wizard each time, or save the template you create in the same template repository with your WorldLabel templates.

About WorldLabel

WorldLabel lets you download free templates in Word, PDF, and formats. For you can download label templates in .stw or .ott file format for 1.1x and 2.0 version for Writer. You can look them up by the number on your Avery label sheet box or read the description. There's a huge number of templates including those for CD and DVD, video, mailing, shipping, and diskettes, and with square or round corners. The templates are XML Open Document Format (ODF), Public Domain, licensed under GPL.

Go to the WorldLabel site.

Downloading WorldLabel Templates

The first step, of course, is to get the templates onto your computer. First, make a directory where you're going to put them. Create a directory at C:\labels or home/labels, for instance, though you can put them wherever you want.

Next, go to the URL for templates.

You can also just download one template at a time. You'll see a list of templates. Find the one you want, by its corresponding Avery number (this is printed on your box of Avery labels), by the dimensions, or by the name if you know the WorldLabel name.

Figure 1: WorldLabel Templates

To download the template, find the Download link, under the version you want. If you're using the current version of, use the Download link under the 2.0 version for .ott files. Then right-click on Download and choose Save Target As.

When the dialog box appears, specify your labels directory that already made, and click Save.

Repeat the downloading steps for any additional templates you want.

Installing the Templates in

Once you've got the WorldLabel templates, you should add them to the template repository and tell where they are. Strictly speaking, you don't have to do any of this, since you can simply choose File > Open and find the template file. However, has a specific way to organize templates which is easier to use once you've got it set up.

This applies to any template that you download, as well as any template that you create.

There are several ways to do this; I'll show you three.

Copying to a Directory

Copy your templates to the appropriate directory. The directory is \share\template\language

Just paste your directory of templates into that location.

Figure 2: Copying templates to the templates directory

Importing a Single Template

That other way was so easy, why bother with anything else? Good question. This approach is good if you want to just bring in a particular template and maybe put it in another category like “templates for the month-end reports.”

  1. Choose File > Templates > Organize.
  2. Select a category on the left. (If you need to create one, right-click on an existing category, choose New, and immediately type the name of the new category.)
  3. Right-click on the category and choose Import Template.

    Figure 3: Choosing to import the template

  4. Find the template and click Open.
  5. The template will appear in the category.

    Figure 4: The imported template appears

Pointing to a Directory of Templates Locally or on the Network

Why would you need yet a third way to point at your templates? If you're a system administrator, you want to make things easy on yourself. Therefore you might want to put all the templates on the network and just point each user to them. Here's how.

  1. Put the directory of templates on the server.
  2. Important: Create at least one subdirectory and put the templates there. It's odd, but recognizes the subdirectories when you do it this way, but not the main directory. You'd have something like this:

    Figure 5: Your template directory

  3. Choose Tools > Options.
  4. Go to > Paths and select the Templates line.
  5. Click Edit. In the window that appears, click Add. Specify the path on the network. Note that you can have several paths to templates.

    Figure 6: Pointing to the shared templates

  6. Click OK, then click OK twice more to save changes and close the window.

Note: There's another way to add a template to the repository, but it's more useful when it's a template you create yourself, or create based on one of the wizard templates. I'll talk about that approach later.

Using WorldLabel Templates

Now that you've installed the templates, the rest is easy. Just choose File > New > Templates and Documents. You'll see the templates window and your templates; if you don't, select the Templates icon at the left.

Figure 7: OpenOffice Templates window

Double-click the templates category you want, then select the template you want. Any information about the template will be displayed.

Figure 8: Selecting the template

Double-click the template; it will template will open, as shown.

Figure 9: A new document based on the template

To add information, just click in the area where you want label information, and start typing. Press Return to go to a new line, then press Tab twice to go to the next label area.

Figure 10: Moving between labels

To format text, just select one or more labels. To select all of the labels, click in the text for one, then press Ctrl A. Apply formatting as you would normally, either with the toolbar, or by choosing Format > Character or Format > Paragraph.

Figure 11: Formatting labels

When you're finished, just print and insert the correct sheet of labels in your printer.

Customizing a WorldLabel Template

You might be wondering how the WorldLabel templates are created, especially if you've used the wizard templates, which are based on Frames. The WorldLabel templates are created with tables; you don't see the borders since they've simply been formatted that way. If you take a close look, though, when you click in the template, you can see the table toolbar.

Figure 11: Labels and the table formatting toolbar

This means you have all the formatting capabilities that you normally get with a table, including the following.

  • Alignment to the top, middle, or bottom (you might want to align your labels all the top)
  • Background formatting; you can apply a color to the background of each cell
  • Easier cutting and pasting than with frames
  • Easier selection of all the content of a row, column, or the whole table
  • Easier copying and pasting; you can easily select the whole table and copy it onto the next page, to make multi-page sheets of labels

To apply values to the table, like backgrounds, choose Table > Table Properties and choose the appropriate tab.

Figure 12: Formatting labels using the Table window

To do things to the table, choose View > Toolbars > Table.

Figure 13: The Tables toolbar

Showing and Hiding Table Borders

I find that it's easier to work with, when you're doing any extensive customization, if the borders are visible. To see the borders of the table, select the whole table. You can simply click in the upper right cell and drag down to the lower right cell, or click in one of the cells and press Ctrl A. Then click and hold down on the indicated borders icon in the Tables toolbar, and choose the lower right option for borders on all cells.

Figure 14: Adding visible borders to the labels

The table borders appear. As you can see there are actually five columns, including the two spacer columns.

Figure 15: Labels with visible borders

To take the borders off later, just repeat those steps but choose the upper left option for no borders on any cells.

Pasting into Label Cells

Table-based label templates are much easier to paste content into. Let's say you've just got a table somewhere else and you want to make labels out of it. Don't worry about the dimensions of the original table. You will have to do some formatting once you've pasted, though, so this should be done if the time for reformatting is less than the time for retyping.

  1. Select one column of content (two columns won't work since the separator column is in the template) and copy it.

    Figure 16: Selecting content to copy

  2. Go to the label template, click in one cell, and paste. The pasted content will fit into the label template, taking on the correct dimensions.

    Figure 17: Pasting content into the labels template

  3. To apply the correct formatting (you can do this after you've pasted all the content), select the pasted content and from the styles dropdown list, select Default.

    Figure 18: Applying the Default style

  4. With the pasted content still selected, choose Format > Paragraph, click the Indents & Spacing tab, and specify .07 inch in the first two fields.

    Figure 19: Applying the correct indent

  5. Click OK.

Note: You could also update the Default style to be indented .07 from each side.

Pasting One Cell Into Multiple Label Cells

Let's say you're making moving labels, or business cards, or something else where you need exactly the same information in every cell. Rather than pasting into each cell individually, you can copy the text once, then paste into every cell.

  1. Select the content to paste, as plain text. You don't need it to be a table cell.
  2. Go to the labels and select all the cells where you want that text to show up.
  3. Paste. The content will appear in every selected cell.

Again, you'll need to apply the Default style as before, and as before, only paste a column at a time because of the separator columns.

Copying the First Page to Make Additional Pages

If you're creating labels, you often need more than just a page. Here's how to make a multi-page sheet of labels. You essentially just select the whole table and paste it onto the next page.

  1. Select the whole table. You can simply click in the upper right cell and drag down to the lower right cell, or click in one of the cells and press Ctrl A.
  2. Copy the table.
  3. Click below the table.

    Figure 20: Clicking in the next available line, to paste another page

  4. Paste. The table will appear on the next page. Repeat these steps to add additional pages.

Using Label Wizard Templates

There are two basic types of label templates in documents that already exist, and templates that are created for you based on selections you make in the label wizard. Using the wizard labels is a bit different. It's definitely a good idea to learn to use them, however; they provide two key features, mail merge and the ability to automatically update all labels in the sheet to match the first label. I won't talk about mail merge, since that's a big topic on its own, but I will go through how to do the automatic update, also known as synchronizing.

Creating a Label Using the Label Wizard

  1. Select the page size and Avery number that you want.

    Figure 21: Selecting the label to use

  2. If you want the same content to appear in every label, fill in that text in the blank field. (You can change and format it later.)

    Note: If you want to make slight adjustments to the label, click the Format tab and change the measurements. However, this is an advanced task and you shouldn't have to do this.

  3. Click the Options tab. If you want the text or formatting to be the same in all the labels, select the Synchronize option.

    Figure 22: Selecting the Synchronize option

  4. Click New Document. The label document will appear, and if you selected Synchronize, the Synchronize button will appear, as well.

    Figure 23: The new untitled label document

  5. You're now ready to format, print, edit, or otherwise change the template.

Updating Labels Using the Synchronize Feature

Here's how the Synchronize feature works. It's very handy—you can use it to update the text or the formatting (or the graphics) in the first label so that all other labels match.

  1. Make the changes you want in the first cell. Change the formatting as you would normally in a text document, change the content, or (as in the next procedure) add a graphic.

    Figure 24: Updating one label

  2. Click the Synchronize Labels button.
  3. All the labels will be updated to match the first one.

    Figure 25: The updated labels

    Handling Frames in a Wizard Template

    Frames are the boxes that the wizard templates use to subdivide text into labels. (If you want to play around with them in other documents, just choose Insert > Frame.)

    Figure 26: Frames in a Wizard label template

    Frames are a little odd to work with. If you didn't click the Synchronize option, you'll be able to, and want to, go from one frame. I'll give you a few tips on how to do this.

    • One of the issues is that you might want to click on the frame border, to change the width of the border or other options, or you might want to click inside to type. It's not clear how to tell which you want. If you're having problems clicking in a frame to type, just press Esc. Likewise, if you are typing in the frame and want to select the frame border, you can also press Esc.
    • If you want to quickly move from one frame to another using the keyboard, type Esc Tab Enter.

    Saving a Wizard Template as a Standard Template

    Going through the Wizard to create labels each time is a bit more work than just opening an existing template. However, there is that handy Synchronize feature. What do you do to reduce the labor associated with the wizard labels? Just save the template the wizard creates in the same location as your other templates.

    1. Create a template as you would normally, through the wizard.
    2. Do any additional formatting once you have created the template.
    3. Choose File > Templates > Save.
    4. In the Templates window that appears, type a name for the template, and a category.

      Figure 27: Identifying the template

      Note: To create a new category, click Organizer. In the left-hand list, right-click on an existing category and select New. Immediately type the name of the new category. Click Close to go back to the Templates window.

    5. Click OK.

    You can now use the template the same way you use any other template. Choose File > New > Templates and Documents, select the Templates category, and just double-click the template you want.

    Adding Graphics to Any Template

    A major feature of templates is the ability to add graphics. You can add them in the corner, or in the background as a watermark.

    Inserting a Graphic

    1. Just click in the cell where you want the graphic.
    2. Choose Insert > Picture > From File.
    3. Find the graphic on your computer and select it.
    4. The graphic will appear.

      Figure 28: A graphic added to a label

    5. To resize it, hold down Shift and drag one of the corner handles in or out.

      Figure 29: Resizing a graphic

    Wrapping Text Around a Graphic

    At this point, you've got a graphic but it probably doesn't look that good with the text.

    Figure 30: A graphic without wrapping

    To wrap the text nicely around the text, right-click on the graphic and choose Page Wrap.

    Figure 31: Specifying Page Wrap

    Now you can move the graphic and the text will get out of its way. If necessary, delete any new carriage returns that were created.

    Figure 32: A graphic with wrapping

    Note: To specify a little more room around the graphic, right-click and choose Picture. In the Wrap tab, specify spacing.

    Adding a Background Graphic

    You can add a graphic to the background of each label, too. I'll use this lightened watermark logo as an example.

    Figure 33: A watermark graphic

    1. First, format the text the way you want it, since with a background graphic the text will be harder to select.
    2. Insert the graphic in the label the same way you do with other graphics, by choosing Insert > Picture > From File.

      Figure 34: Inserting a watermark graphic

    3. Then right-click on the graphic and choose In Background.

      Figure 35: Sending the watermark graphic to the background

    4. You'll see the graphic in the background.

      Figure 36: The watermark graphic in the background of the label


    No templates article would be complete without mentioning styles. Styles can make formatting templates even faster. Styles are a far bigger topic than templates, but I hope you'll google for information, use the online help, or refer to the styles section of my blog.

    I hope you'll use templates, either the WorldLabel templates or the wizard templates or both, to make your job easier. It's easy to fall into the habit of doing things manually, and I do that myself. But the difference when you take a little time to set up templates is amazing. It's particularly helpful when you have a large team of people—the time you save yourself might not be that much but the time that five or 500 people save is tremendous. If you have new people on your team regularly, if consistency is a goal or a challenge for your organization, or if you have a distributed team, templates can be tremendously helpful. They're the right tool for the job.

    About the Author
    Solveig Haugland has been an instructor, author, and technical writer for fifteen years, and got started with StarOffice and while working at Sun Educational Services. She likes making things easy through providing training, books, and consulting to users of and StarOffice. See her blog at to learn more about the programs, or see her consulting and training site at to learn about products and services. Her OpenOffice 2.0 book is coming this fall from Prentice Hall.

by stress_junkie on Sun, 2006-08-27 15:41
I like the article. I has just enough information to be useful. I've spent twenty one years setting computers up but I've never learned how to use the application software. Since I started my own business I find that I have got to learn to use an office productivity suite. OOo seems like a good one. I experimented with KOffice. I didn't like it.

So I need to learn just enough to be useful but I don't want to learn enough to replace a good secretary. Your article is just what I needed.

I looked at your web site. It seems that the instructive stuff is mixed in with a diary. That makes it difficult to read. I couldn't find any kind of table of contents on your web site.

by terryxela on Mon, 2007-09-10 22:54

Great article.
I am running OO 2.2.1 and I want try to use the Label Wizard for the Avery 5931. The wizard has instead of letters "user" with a 1.5 x 11 inches page. Changing format/page to letter solves the problem. Here is the question: How can I save the modify templates so the Wizard the next time comes with the correct template?. I know how to save the template, I just want to modify the wizard template. Is that possible.



All times are GMT -5. The time now is 02:32 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration