Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Dynamically send email

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

....

37 Replies
fosuzuki
Valued Contributor II

Dynamically send email

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

Dynamically send email

Can you provide me an example???

Highlighted
jason_michaelid
Honored Contributor II

Dynamically send email

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

Not applicable

Dynamically send email

Can u please share code for macros

Not applicable

Re: Dynamically send email

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

Dynamically send email

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

Re: Dynamically send email

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

Re: Dynamically send email

I will let u knw ,if its works fine.

Not applicable

Re: Dynamically send email

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

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

Community Browser