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

Mail Merge Wizard - Addresses

Specify the recipients for the mail merge document as well as the layout of the address block.

The Mail Merge wizard opens to this page if you start the wizard in a text document that already contains address database fields. If the wizard opens directly to this page, the Select Address List button is called Select Different Address List.

The title of this page is Insert address block for letters and Select address list for email messages.

Select Address List

Opens the Select Address List dialogue box, in which you can choose a data source for the addresses, add new addresses, or type in a new address list.

When you edit some records in a Calc spreadsheet data source that is currently in use for a mail merge, those changes are not visible in the mail merge.

This document shall contain an address block

Adds an address block to the mail merge document.

Select the address block layout that you want to use.

If you select This document shall contain an address block, the third and fourth sub-steps become enabled on this page. Then you have to match the address block elements and the field names used in the mail.

Suppress lines with just empty fields

Enable to leave empty lines out of the address.

More

Opens the Select Address Block dialogue box.

Match fields

Opens the Match Fields dialogue box.

Unless all address elements are matched with a column header, you cannot finish the Mail Merge wizard with the Finish button or continue to the fourth step of the wizard.

(Browse buttons)

Use the browse buttons to preview the information from the previous or next data record.

Next step: Mail Merge Wizard - Create salutation

Alternatively you can press the Finish button and use the Mail Merge Toolbar to finish the mail merge process.