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???

1 Solution

Accepted Solutions
Not applicable
Author

Hi Sumit,

Please see the attached sample file and Image.

This is how you want.

Follow the settings like in the image.

and go to the Alerts wizard in the application and do changes.

Let me know whether it works for you or not.

Regards

....

View solution in original post

37 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Have you considered using Alerts? It is possible to use an expression to get the recipients from a field, and you can configure the condition to trigger the alert.

Regards,

Fernando

Not applicable
Author

Can you provide me an example???

Jason_Michaelides
Luminary Alumni
Luminary Alumni

I think alerts are only available if you have Publisher.  If not you have to use a macro.

Not applicable
Author

Can u please share code for macros

Not applicable
Author

Hi Sumit,

Please see the attached sample file and Image.

This is how you want.

Follow the settings like in the image.

and go to the Alerts wizard in the application and do changes.

Let me know whether it works for you or not.

Regards

....

Not applicable
Author

now  my question is

suppose I have table which has fields Daycompleted,Employeeid,EmailId,Whenever any employee complete a 30 days in an office,an email should go to that particular email id..

i have any answer please help me out..

Not applicable
Author

Hi Sumitth,

Please check the latest attachment

I think your needed like this.(Don't forget to give Mail settings.)

reply me if it is fine.

Regards

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

Not applicable
Author

I will let u knw ,if its works fine.

Not applicable
Author

Hi Sumitth,

Please see the latest attachment.(Provide Mail settings)

In the previous one i provide 2 buttons to complete the action how you need(for clear understanding)

In this straightaway i am providing all the actions in a single button.

Hope it will help you..

reply me if it really helps you.

Regards

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