Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamically send email

How to write a macro to send an email to all email ids in a email ids field in the table object when it satisfies a particular condition???

37 Replies
Not applicable
Author

Hey Bloss,

As per my understanding the testmail works for you.(Here you are not facing any problem)

But if you want to send the mail to your personel EmailID,It's not working.

Is it right?

If you want to send the mail to your personel ID, you need to give that particular server address and portno(ex:gmail) in the userpreferances.

Regards

...............

Not applicable
Author

Hey Rav,

The mail Does Not Send At All when using the alerts or the Macro. I wish to send it to anne.e.duffy@123.ie

The reason why I was showng you the user preferences was that the Test button on the mail works, so presumably I have the correct information set up.

The EMail address that I loaded into the script was copy and pasted excatly from the user preference set up so I do not understand why it will not send the mail when I press the button , unless there is somewhere else I need to update.

Thanks

A

Not applicable
Author

Hey Bloss,

Do one thing send the screenshot of your "Alerts" window.

If possible send one sample application.

If you want to send the mail you need to follow these thinngs

1->Mail settings.

2->Alerts window conditions.

3->Macro code.

Regards

...........

Not applicable
Author

Hi Rav

See below ( Thanks a mill for taking the time to help me !!)

I believe that my mail settings are ok ( as the test works)

I believe that the alert is triggering ( as if I tick pop-up the popup fires onrelaod !!)

When I test the macro it states executing yet does not fire the mail !!! ( the pop up shows though)

Please also see script amendments

Thanks again


Anne

if(ScriptErrorCount>=0) then
set vAlert=1;
ENDIF


Test:
Load * Inline
[
Emp_ID, DayCompleted, Emp_EMailID     
00008 , 30   ,anne.e.duffy@123.ie
00002 , 20   ,anne.e.duffy@123.ie
00004 , 30   ,anne.e.duffy@123.ie
00014 , 29   ,anne.e.duffy@123.ie
];

if(ScriptErrorCount>=0) then
set vAlert=1;
ENDIF

Alerts screen.bmp

Not applicable
Author

Hi Anne,

The script is correct.

Even if you are not providing any recipent list also,it will show the alert message as a pop-up.

I have a doubt

I don't know what you are providing in the Alert window.

Please see the attached image and check in your application like this you are following or not.

Regards

...............

Not applicable
Author

Hi Rav

Thanks so much for your time,

The mails still wont fire when pressing the Button,

I officially give up !!

Thanks


A

Not applicable
Author

Anne,

If possible attach your sample file.

Regards

...........

Not applicable
Author

Hi Rav

See attached ( this is my first time putting up a doc so I hope it posts ok!!)

Thanks


A

Not applicable
Author

Anna,

you are getting any error message when you clcik on Button after popmessage display.

Regards

..........

Not applicable
Author

No , No error , just the yellow pop up I pres the x to close and that is is !!

Its very strange !!!