Script to send email

[#1]

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

[sarvesh]

Please refer below mentioned link:

Send mail and Export in Qlikview

Hope it helps..

Regard's

Sarvesh Srivastava

[#3]

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.

[andrespa]

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

Hope it helps,

Andrés

[stabben23]

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

[#6]

Okay thanks everyone.

[PastusheniA]

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";