Faq/Writer/129

How to use a Calc file as a data source to execute a mailing
The spreadsheet has to be specified as a data source for the mailing. This registration can be realized explicitly using either a wizard or the corresponding menus. This FAQ illustrates the creation and the registration of the database and presents its use.

Assisted creation of the database
This is the best method.

Select  to open the 'Database wizard.
 * 1) choose Connect to an existing database, select Spreadsheet in the list, then click Next.
 * 2) click Browse to select the spreadsheet, then Next


 * 1) choose Yes, I want the wizard to register the database but uncheck Open database for editing. Click Finish.
 * 2) Choose a location for your database file and give it a name.

Creation of the database
Open the text document that will serve for the mailing:   select ;  click the Browse button to select the Calc file;  click the + sign and select the sheet that contains the data;  click the Define button; 

Note  :
 * The database is created without any message of confirmation.
 * The database created using this method will be in the default folder.


 * It will take the spreadsheet name followed by 0 (zero) if the folder does not contain any other documents with the same name; otherwise the number will be automatically incremented.
 * The registration is automatic.

Use of the database

 * 1) Display the database sources by pressing ' or ';
 * 2) choose the table, or check that the selected table is the one that you want;
 * 3) drag/drop the field headers in the text;


 * 1) to check the page layout:
 * 2) * select one record
 * 3) * click the icon "Data in fields" (the button icon will be different but the tooltip will be the same)



To execute the mailing, display the print dialog, LibreOffice will recognize that this is a form containing mailing fields.

Notes: