Text

If you select the Text option in the Insert Database Columns dialog, the content of the data selected in the data source browser is inserted into the document as text. In the dialog, you can decide which database fields or columns are transferred, and how the text is formatted.

If several records are selected when you choose the Data to Text function, the mail merge fields will be inserted according to the number of records.

Text

In the Text area, use the arrow button to select the database table columns into which you want to insert field contents.

Database columns

Lists all columns of the database table, which can be accepted in the selection list box to insert them into the document. Select the database columns that you want to insert it in the document.

>

Moves the fields that you selected in the Database columns list box into the selection field. You can also double-click the entry to select it.

Select

Lists the database columns that you selected to be inserted into the document. You can also enter text here. This text will be also inserted into the document. The entries' order in the selection field corresponds to the data order in the document.

Format

Specifies the format for inserting the database fields into the document.

From database

Accepts the database formats.

Select

Specifies a format from the list, if the format information of certain data fields is not accepted. The formats supplied here are only available for certain database fields, such as numeric or Boolean fields. If you select a database field in text format, you will not be able to select any format from the selection list, since the text format will be automatically maintained.

If the format you want is not listed, select "Other Formats..." and define the desired format in the Number Format dialog.

The number format assigned using the selection list always refers to the database field selected in the Database columns list box.

Paragraph Style

By default, the inserted paragraphs are formatted with the current Paragraph Styles. This format corresponds to the "none" entry in the Paragraph Style list box. This is where you can select other Paragraph Styles to apply to the paragraph you want to insert into the document. The list box displays the available Paragraph Styles defined in LibreOffice and managed in the Style Catalog.

Please support us!