Sending HTML tables in email

You can send query results as HTML tables in the email when you work with scheduled tasks.

Before you begin

Make sure that the selected format of a letter is HTML and the table you want to add is saved in the HTML format too.

The inserted tables appear in the body of the letter in HTML format.

Adding an HTML table is available only for the following tasks of the scheduler:

Exporting query to mail task. As a result of this task you get query result set in HTML format, which can be sent in the email.
Sending mail resource manipulation task. In this task you can insert the necessary HTML tables created when performing other tasks.

To insert an HTML table in the body of an HTML letter:

In the Operation Wizard window, click an ellipsis button (…) in the Message field. The Formula editor opens.
From the list of the functions expand the Scheduler and select insertHTMLTable or type the name of this function in the Filter field.
Double-click the function and specify its parameters.
Click OK to add the function. The specified table is added to the letter.

You can add grid.html table to the letter with the following parameters:

When you work with export task, just add the function without any parameters
```
=insertHTMLTable()
```
When you work with resource manipulation task, you can specify only one parameter, in case the exported HTML file has UTF-8 encoding.
```
=insertHTMLTable("grid.html")
```
You must specify both parameters if the encoding of the exported HTML file differs from UTF-8.
```
=insertHTMLTable("grid.html", "UTF-16")
```