mail macro not working on scheduling. - Qlik Community

Report Inappropriate Content · ‎2013-09-16

Hi all,

I have written macro for mailing. When i reload manually or do test it works and send mail.

but when i schedule, its not able to sned mail.Because it opens document in safe mode.

I have set module security and local security both to "Allow system acess" but still it resets to "safe mode".

What could be the prob?

amars · ‎2013-09-16

Hi Monica,

If you are scheduling it on Qlikview Server, it won't work since post Qlikview 10 the macro's on reload doesn't work on Qlikview Server. You can try scheduling a batch file.

Thanks..

vikasmahajan · ‎2013-09-16

PFA for Scheduling and running Macros.

Hope this helps you a lot

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2013-09-16

Also find screens for scheduling jobs.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-09-16

Hi Michael,

i am scheduling batch file only.

Do i have to check "macro override secuirty" in secuirty tab ?

amars · ‎2013-09-16

Yes Monica, you can enable that option.

Also try enabling User Preferences -> Security -> Module (Allow Createobject and File Access)

Report Inappropriate Content · ‎2013-09-17

Hi Vikas,

I have done everything but still facing same prob. when i reload manually ,am getting mails but in case of sheduled batch file ,mails are not coming.

Need help..

vikasmahajan · ‎2013-09-17

Please check whether log file is generated after scheduled. Also check following setting in your documents

Requested Module Security -> System Access

Curr. Local Security -> Allow Sys access

also Setting -> Document Properties -> untick macro override Security option

also setting -> user Pref. -> Save After Reload

Hope this helps you

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-09-17

Hi Monica,

Plz use this code for schedule this Macro Application.

"C:\Program Files\QlikView\qv.exe " /l /NoSecurity "D:\New Folder\Pending_Summary.qvw"

use /l instead of /r ....then macro will run automatically & Mail too......try it

Thanks & Regards,

Parag Patil

Report Inappropriate Content · ‎2013-09-17

thnx parag..will try this..