Follow-On Topics

Related Topics

# About the Formatting Tab

The Formatting tab is used to create the HTML document. For ease of use, an existing HTML document can be imported into the design area (Import button), acting as a template for the task data from the Task Browser. Note that any HTML constructs typed into the design area are treated as plain text. Instead, click the Edit button to open the HTML document in Notepad — if you see a warning advising the HTML editor cannot be found or opened, go to Control Panel > Internet Options > Programs tab and select Notepad as the HTML Editor. The Format as HTML tool recognises that changes have been to the HTML document and asks whether to reload. To display recordset data as a table, click Design in the Table pane — see About the HTML Table Designer. The Format as HTML tool can generate single or multiple documents based on the consumed recordset: | Click the image to view full size.

|  | One document — A single HTML document is generated for each task run.

|  | New document when column changes — Multiple documents are generated from the recordset, tied to a specific recordset column. When the column value changes, a new HTML document is generated. For example, if a column name `companyname` is specified which contains values of `Quadrant Software B.V.` and `Quadrant Software B.V.`, one document is generated for all records where `companyname="Quadrant Software B.V."` and another where `companyname="Quadrant Software B.V."`.

NOTE:

In order for the grouping to work in this manner the column selected must be included as a primary sort key in the consumed Database Query (ODBC), Database Query (OLEDB), or Call Stored Procedure (OLEDB) step.

|  | New document for each row — A new document is generated for each row in the consumed recordset. This option does not allow a table to be used. It is most appropriate for generating single documents where the columns from the recordset are used as merge fields, for example, an automated mail shot.

Copyright © 2018 Quadrant Software B.V. All rights reserved.