Frequently asked questions - Writer
TDF LibreOffice Projekti për Çlirimin e Dokumenteve Blogjet e komunitetit Weblate Nextcloud Redmine Pyet LibreOffice Dhuro
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 ▸ ▸ to open the Database wizard.
- choose Connect to an existing database, select Spreadsheet in the list, then click Next.
- click Browse to select the spreadsheet, then Next
- choose Yes, I want the wizard to register the database[1] but uncheck Open database for editing. Click Finish.
- 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;
Shënim:
- Databaza krijohet pa ndonjë mesazh konfirmimi.
- Databaza e krijuar me këtë metodë do ruhet në skedarin default [2].
- 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[1] is automatic.
Use of the database
- Display the database sources by pressing Ctrl + ⇧ Shift + F4 or ▸ ;
- choose the table[3], or check that the selected table is the one that you want;
- drag/drop the field headers in the text;
- 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: