topic Re: Send Email by Macro in QlikView

Send Email by Macro

nihhalmca — Sun, 21 Feb 2016 14:44:28 GMT

Hi All,

I can able to send a email by macro at Desktop level, however i could not do same at QMC level.

--> I am getting mail when i reload application by Desktop

--> I am not getting mail when i reload application by QMC

Can you help on this.

Thanks,

Nihhal.

Re: Send Email by Macro

Anonymous — Sun, 21 Feb 2016 15:56:38 GMT

Hi Nihhal,

In QMC if you set up System-->Distribution Service-->Alert Email, you will receive email message for any failure.

But if you want to receive "ok" email unfortunately the only way i know is to put yourself in the recipients lists.

Best,

Maurice

Re: Send Email by Macro

marcus_sommer — Sun, 21 Feb 2016 19:21:36 GMT

QMC tasks didn't execute macros. You will need to trigger batches with the desktop client maybe per command-line:

"C:\Program Files\QlikView\qv.exe" /r "D:\GMApps\Qlikview\example.qvw"

"C:\Program Files\QlikView\qv.exe" /l "D:\GMApps\Qlikview\example.qvw"

or per vbs:

Re: Copy and Reload a qvw using Command Line or VBS in background

Further this: Re: Sending mails macro vbs and this Re: Batch file QV reloads - are they reliable? might be helpful.

- Marcus

Re: Send Email by Macro

petter — Sun, 21 Feb 2016 21:52:31 GMT

When the QMC runs your script it is with different credentials from when you are logged in as yourself with your Desktop. How do you send the email in the first place?