/text/shared/02/12070200.xhp Sun Microsystems, Inc. Fields database contents; inserting as fieldsInserts data selected from the data source browser into the document as fields. In the Insert Database Columns dialog, select the Fields to insert the selected data into the document as fields. These database fields work as wildcards for the individual database columns and can be used for form letters. Click the Data to Fields icon to match the contents of the fields to the currently selected record. 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. Also, a field command such as "Next record" will be inserted automatically between individual field command blocks. The Insert Database Columns dialog lets you define which database fields to insert into the document and how to format the paragraphs. Fields In the Fields 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. 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 %PRODUCTNAME and managed in the Style Catalog.