Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Printing Address Labels

  1. Choose File - New - Labels to open the Labels dialogue box.

  2. On the Labels tab page, select the format of the label sheets that you want to print on.

  3. Choose the database and table from which to obtain the data.

  4. Select a database field of which you want to print the contents. Click the button that shows a left arrow to insert the database field into the Label Text box.

Continue to select and insert database fields if you want more fields on every label. You can press Enter to insert a new line, and you can type any character to insert fixed text.

  1. Optionally, if you want to type more text, apply formatting, or insert images and line art, you should enable Synchronise contents on the Options tab. If you enable this, once you leave the Labels dialogue box a small window opens with a Synchronise button. Now you only need to work on the first label on the labels document, then click the Synchronise button to copy your work to every label of the document.

  2. Click New Document.

  3. When you see the label document, you might want to temporarily enable View - Field Names. This displays the fields in a more visible manner, so that you can arrange and edit label contents more easily.

  4. You can save and/or print the label document.

When you choose to print the document, you will be asked if you want to print a form letter. Answer Yes to open the Mail Merge dialogue box. In the Mail Merge dialogue box, you can select the records for which you want to print labels.