cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
dadawasozo
Level IV

challenges using Mail() to auto mailling report

 

Hi,

I need to automated sending a graph in email body and attach a table daily. I'm having 3 issues now and hope someone can help.
issue 1) : Not able to get graph into mail body. How I can do that? I simply tried below and no graph in body and it complains that character is needed, which indicating not allow picture?

graph << Get As Report();
mail("XXX@XXX", "test", "Visualization " ||"\!n"|| Eval(graph << Get Text), "test.csv")


issue 2): on above it able to get the title in the graph added to mail body but not the graph. The test.csv is not attached.


issue 3): can JSL auto select the "Allow" when it appears without human interaction? (see below)

dadawasozo_0-1685795918641.png


Note: I able to get both the table and graph as attachment, but that dont meet customer requirement and the issue 3 still remain. Really appreciate if someone can help me.

 

2 REPLIES 2
jthi
Super User

Re: challenges using Mail() to auto mailling report

You could send the email by using vbscript or powershell and call those with JSL. For example with Powershell you can send email with HTML body and in there you can embed images of graphs and embed tables.

-Jarmo
dadawasozo
Level IV

Re: challenges using Mail() to auto mailling report

Hi Jarmo,

 

Do you by chance has any example using html?
Will that solve also the issue of my issue3)?