CihanAnkara

Sending SQL Query Result as Email in HTML format with CSV/Excel Attachment

Discussion created by CihanAnkara on Feb 12, 2019
Latest reply on Mar 6, 2019 by CihanAnkara

Hi,

 

We have extended the "Email" action in Javelin which can now get the "outDataTable (DataTable)" as Input and sends its contents via email in HTML format with EXCEL/CSV attachment. HTML is dynamicli generated according the configuration in new action. I thought that might me helpful and cover someones needs. Here you may find some screen shots.

 

 

You may define your DataTable output as Input variable to new action and set the column names that you want have in email.

 

 

These columns in email and attach excel file created  dynamically according to configuration provided in "ColumnNames".

 

Best,

 

Cihan

Outcomes