Frequently asked questions - Writer

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Spende

• Start
• Entwicklung
• Gestaltung
• QA
• Events
• Dokumentation
• Webseite
• Lokalisierung
• Barrierefreiheit
• Marketing
• Diversität
• Wiki Hilfe

• Dokumentation Start
• Handbücher
• Andere Quellen
• FAQ
• HowTo
• Makros
• Doku Entwicklung

• Start-FAQ
• Allgemein
• Writer
• Calc
• Impress
• Draw
• Math
• Base

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.

Creation of the database

Assisted creation of the database

This is the best method.

Select File ▸ New ▸ Database 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:

1. select Edit ▸ Exchange database;
2. click the Browse button to select the Calc file;
3. click the + sign and select the sheet that contains the data;
4. click the Define button;

Note:

• Die Datenbank wird ohne jede Bestätigung angelegt.
• Die Datenbank aus diesem Vorgang ist im Default-Ordner .

• 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 Ctrl + ⇧ Shift + F4 or View ▸ Data sources;
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:
   • select one record
   • 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: