Frequently asked questions - Writer

    From The Document Foundation Wiki
    < Faq‎ | Writer

    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
    3. choose Yes, I want the wizard to register the database[1] but uncheck Open database for editing. Click Finish.
    4. 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; FR.FAQ Writer 129a.PNG
    4. 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 [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

    1. Display the database sources by pressing Ctrl + ⇧ Shift + F4 or View ▸ Data sources;
    2. choose the table[3], or check that the selected table is the one that you want;
    3. drag/drop the field headers in the text;
    4. 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)

    FR.FAQ Writer 129b.PNG

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

    Notes:

    1. 1.0 1.1 registering a database can be done later via Tools ▸ Options ▸ LibreOffice Base ▸ Database: click New then select the file .odb
    2. the default path is defined with Tools ▸ Options ▸ LibreOffice ▸ Paths ▸ My documents.
    3. When the data source is a spreadsheet, Tables are the Sheets of the spreadsheet