issues with a "send email by script "

[brunobertels]

Hi Qlikers 

I need help with a scenario where a need to send every day a simple table with some result from previous day. ( let's say it is a call handled level ratio  and the volume of received  and  handled calls . )

I read some post and webpage and tried to reproduced the same but without succes. I am not professional scripter 🙂 

I  followed this tutorial from Steve Dark : 

https://www.quickintelligence.co.uk/send-data-from-qlik-load-script/ 

I'am able to create the html table 

I'am able to get en email sending wilh the object i want but i'am not able to populate  the body of the mail with my html table.  I missed somthink but not able to identify where i did bad. 

Help will be very appreciate 

Regards 

Bruno

Ps I upload the qvf with the script and the resulting html table i generate from script ( convert to zip file for upload) 

[JeromeS]

Hello,

So if i understand well, you need to put the html body inside your API call

I think you need to first create a variable and use it inside your call, like this:

Message:
Load
concat([<!--EMailOutput-->] & chr(10)) as Message
resident EMailOutput;

let vMessage = peek('Message',-1);

and use $(vMessage) as message parameter

if it doesn't work, maybe watch out for the single and double quotes

Jérôme