topic Re: Qlikview macro issue(Auto Mails) in QlikView

Qlikview macro issue(Auto Mails)

bindu_apte — Fri, 22 Apr 2016 08:29:36 GMT

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

Re: Qlikview macro issue(Auto Mails)

zhadrakas — Fri, 22 Apr 2016 09:02:55 GMT

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

Re: Qlikview macro issue(Auto Mails)

bindu_apte — Fri, 22 Apr 2016 09:41:16 GMT

Hey Thanks Tim.

I already made this settings.

Still its not working.:(

Regards,

Bindu Apte

Re: Qlikview macro issue(Auto Mails)

Anonymous — Fri, 22 Apr 2016 10:11:40 GMT

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

Re: Qlikview macro issue(Auto Mails)

bindu_apte — Mon, 25 Apr 2016 04:04:35 GMT

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

Re: Qlikview macro issue(Auto Mails)

bindu_apte — Mon, 25 Apr 2016 04:32:48 GMT

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.

Re: Qlikview macro issue(Auto Mails)

Anil_Babu_Samineni — Mon, 25 Apr 2016 07:19:24 GMT

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

Re: Qlikview macro issue(Auto Mails)

marcus_sommer — Mon, 25 Apr 2016 07:22:26 GMT

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-Documents.

- Marcus

Re: Qlikview macro issue(Auto Mails)

bindu_apte — Mon, 25 Apr 2016 10:15:57 GMT

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

Re: Qlikview macro issue(Auto Mails)

marcus_sommer — Mon, 25 Apr 2016 10:32:27 GMT

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

Re: Qlikview macro issue(Auto Mails)

bindu_apte — Tue, 26 Apr 2016 03:10:57 GMT

Hi Anil,

Its already been checked.

As of now am using 25 port number, so I checked after changing port numbers but not working.

Re: Qlikview macro issue(Auto Mails)

bindu_apte — Thu, 28 Apr 2016 04:32:48 GMT

Hi,

Please help me out to resolve this issue.

Regards,

Bindu Apte