is it possible to embed the HTML code into the Groovy Script ?

Hi,

Requirement : I have to send an email to the approvers with Prices fetched from the Database

Used SQL Connector and retrieved the information and I stored the values in X variable (Datatype : java.sql.Resultset) and created the HTML table with the data retrieved in variable "X" and stored in the variable called "htmlTable"(DataType : String).

Currently I have a groovy script configured in the message textbox in the Email connector , but I am not able to add the variable "HtmlTable" in the Groovy script.

Can any one help me in answering this ?

Bonita Version : 6.5.4