How to Merge Mail Labels in OpenOffice

Use your computer to merge label lists in OpenOffice.

Printing individual labels or a series of label lists can take large amounts of time. To save time, you can use OpenOffice to merge a series of labels and label lists into a larger list for a one-time printing. Merging labels in OpenOffice is quick and easy if you follow these basic steps.

Instructions

1. Click "File" and choose "New" and "Labels."

2. In the "Labels" tab, select the source your wish to use from the "Database" drop-down list.

3. Choose a table from the "Table" list or use "Sheet1" if you're working with a spreadsheet.

4. Choose the beginning field you wish to use from the "Database Field."

5. Click the arrow beside the text field and type a space after the field entry. Insert all other desired fields, placing a space behind each entry. This will merge all of the label groups of your choosing.

6. Select the brand name and size of your labels from the "Brand" drop-down list, such as "Avery Letter Size."

7. In the "Type" drop-down list, choose the type of label you are using. This type will be listed on your label sheet or box of labels, such as "8160 Inkjet Address."

8. Click the "Options" tab and select "Synchronize Contents."

9. Click the "Setup" icon and select the printer you wish to use.

10. Click the highlighted "New Document" icon and the labels will appear. Make all necessary changes and click "Synchronize." Choose "File" and "Print." A message will appear asking if you want to print a form letter. Click "Yes."

11. Click "Print All" to print the entire label list or hold down the "Ctrl" button and click individual labels.

12. Click "OK" to print the merged labels.

References

• OpenOffice.org: Mail Merge Labels in OpenOffice
• Writer Guide: Using Mail Merge