topic Re: Script to send email in QlikView

Script to send email

Wed, 25 Nov 2020 16:16:04 GMT

Hello QV community,

I'm actually trying to send an email with an attached file stored in my local computer. Let's assume that the file is called audit.csv.

Could anyone show me how to proceed ?

Note : I don't want to use the GUI (only scripting).

Many thanks

Re: Script to send email

sarvesh — Wed, 22 Mar 2017 09:24:27 GMT

Please refer below mentioned link:

Send mail and Export in Qlikview

Hope it helps..

Regard's

Sarvesh Srivastava

Re: Script to send email

Wed, 22 Mar 2017 13:43:47 GMT

Thanks for replying but all of the solutions are using macro. Is there any way to use the editor script and NOT the module scripts editor ?

example :

STORE vTable into audit.csv;

after that i need to send this file (audit.csv) attached in an email.

Re: Script to send email

andrespa — Wed, 22 Mar 2017 14:33:11 GMT

Hi, as far as I understand the only possible way is using macros.

Hope it helps,

Andrés

Re: Script to send email

stabben23 — Wed, 22 Mar 2017 14:58:46 GMT

I would look for another tool to fetch Your file and send it by mail, qlikview does not support this from script editor.

Re: Script to send email

Wed, 22 Mar 2017 15:00:16 GMT

Okay thanks everyone.

Re: Script to send email

PastusheniA — Thu, 11 Feb 2021 12:32:21 GMT

I did it with PowerShell, write in your Load Script :

EXECUTE powershell.exe "Send-MailMessage -From send@mail.by -To user@mail.by -Subject "TEST Message" -Body "It is email body" -Attachments TestAtt.txt –SmtpServer 172.30.0.100";