Documentation/OOoAuthors User Manual/Writer Guide/Printing mailing labels

OpenOffice.org 2.x Writer Guide

Chapter 11: Using Mail Merge

< Previous Section

Next Section >

• Creating the data source
• Registering a data source
• Creating a form letter
• Printing mailing labels
• Printing envelopes
• Using the Mail Merge Wizard to create a form letter

[[{{{PrevPage}}}|< Previous Page ]]

[[{{{NextPage}}}|Next Page >]]

Printing mailing labels

Before beginning this process, check to see what brand and type of labels you have.

To print mailing labels:

1. Click File > New > Labels.
2. On the Labels dialog, go to the Options tab and uncheck Synchronize contents if it is checked.

Uncheck Synchronize contents
Uncheck Synchronize contents.

Note: If you need to suppress blank lines in some of your labels, read Removing blank lines in labels.

3. On the Labels tab, select the Database and Table. Select the Brand of labels to be used, and then select the Type of label.


Select Database, Table, label Brand, and label Type.

4. Click the dropdown arrow under Database field. Select the first field to be used in the label (in this example, First name). Click the left arrow button to move this field to the Label text area.


Move fields from Database field list to Label text area.

5. Continue adding fields and inserting desired punctuation, spaces, and line breaks until the label is composed. The figure below shows the completed label.


The completed label.

6. Click New Document.
7. Click File > Print. The following dialog appears. Click Yes. Do not select the checkbox.



8. In the Mail Merge dialog, you can choose to print all records or selected records. To select records to be printed, use Ctrl+click to select non-contiguous records. To select a contiguous block of records, select the first record in the block, scroll to the last record in the block, and Shift+click on the last record.


Mail Merge dialog.

9. Click OK to send the letters direct to the printer. If you wish to check the labels before printing, see Saving as a file rather than printing for instructions.