topic Re: challenges using Mail() to auto mailling report in Discussions

challenges using Mail() to auto mailling report

dadawasozo — Sat, 03 Jun 2023 12:54:07 GMT

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)

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.

Re: challenges using Mail() to auto mailling report

jthi — Sat, 03 Jun 2023 14:58:41 GMT

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.

Re: challenges using Mail() to auto mailling report

dadawasozo — Sat, 03 Jun 2023 17:10:23 GMT

Hi Jarmo,

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

Re: challenges using Mail() to auto mailling report

vvm — Sat, 08 Feb 2025 04:55:25 GMT

Hello Jarmo or dadawasozo,

I am looking for the same and do you guys have a solution for this?

thank you

Re: challenges using Mail() to auto mailling report

jthi — Sat, 08 Feb 2025 06:28:27 GMT

I cannot share the script which I use but if I remember correctly the idea is something like this https://stackoverflow.com/questions/52837468/embed-images-in-email-and-send-via-powershell . I would guess you could also use VB Script but I haven't looked into that option.