Creating the data source

OpenOffice.org 3 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

< Previous Page

Next Page >

A data source is a database containing the name and address records (and optionally other information) from which a mailing list may be derived. Although you can create and print mailing labels and envelopes without using a data source, in most cases using one is the best approach. This chapter assumes that you are using a data source.

OOo can access a wide variety of data sources, including spreadsheets, text files and databases such as MySQL, Adabas, and ODBC. If the information to be used in the mail merge is currently in a format that OOo cannot access directly, you need to convert it, for example by exporting it to a comma-separated values (CSV) file.

For the following example we use a spreadsheet with the following column (field) headers: Title, First name, Last name, Address, State/County, Country, Post Code, Sex, Points. A sample data source is shown below.

Spreadsheet data source.