Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
bindu_apte
Contributor III

Qlikview macro issue(Auto Mails)

Hi,

I have a dashboard having macro written for sending auto mail. From Qlikview desktop mail will going but through accesspoint its not working.

It will work only when after clicking on button.

Hence please help me if any settings needs to be done?

Regards,

Bindu Apte

11 Replies
zhadrakas
Valued Contributor

Re: Qlikview macro issue(Auto Mails)

Hi Bindu

make sure that you set the Settings in macro Editor to "System Access".

and check the Macro Settings in Access Point. Press CTRL + SHIFT + M in Access Point and set the Settings like the Image below.

Hope this helps

bindu_apte
Contributor III

Re: Qlikview macro issue(Auto Mails)

Hey Thanks Tim.

I already made this settings.

Still its not working.:(

Regards,

Bindu Apte

kaveri_bhar123
New Contributor II

Re: Qlikview macro issue(Auto Mails)

Hi Bindu,

Once access point is open, please once again press CTRL + SHIFT + M even if it is set in script and give the required access. This should work.

Best regards,

Kaveri

bindu_apte
Contributor III

Re: Qlikview macro issue(Auto Mails)

Hi,

Thanks for the guidence. It is working finr after settings made in accesspoint. But everytime, every user has to set the settings? or in server accesspoint we can just made the settings??

Regards,

Bindu Apte

bindu_apte
Contributor III

Re: Qlikview macro issue(Auto Mails)

Hi,

I went to server and checked the settings in accesspoint. From there am able to send mails but from my local machine its not working. If I press CTRL + SHIFT + M nothing is coming. Is there any other settings needs to be done?

I got error like this, from local machine.

macro issue 1.jpg

Re: Qlikview macro issue(Auto Mails)

Bindu, Did you try this.. Goto --> Settings --> User Preferences --> Security Tab -> Please check the Third and Fifth Boxes. And then Run.. Thanks

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP & Luminary
MVP & Luminary

Re: Qlikview macro issue(Auto Mails)

Those security-settings regarding to the macro-execution are user-settings and needs to be set on a user-level within the settings.ini, see: Re: Macro & security level whereby also a script-solution is possible: QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documen....

- Marcus

bindu_apte
Contributor III

Re: Qlikview macro issue(Auto Mails)

Hi,

I made all these settings. But still the same issue.

I have opened access point from server, from there auto mail is working fine. But from my local machine if I open accesspoint and send auto mail then its not working.

Let me know is there any SMTP settings needs to be done from local machine?

Regards,

Bindu Apte

MVP & Luminary
MVP & Luminary

Re: Qlikview macro issue(Auto Mails)

Have a look within your user-properties in qlikview. There is a tab mail and there you need to define the (right) settings. I would start and copy the settings from the qmc by your mail server and if this don't work you could take a look within your outlook-settings (respectively from this mail-program which you are using).

Beside them there could be various settings on firewall, group policies and proxys which might prevent a successful mailing - if you get error-messages you could to search for them (google) and ask your mail admin for support.

- Marcus