Discussion board where members can get started with QlikView.
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???
Go to Solution.
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.
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.
Can you provide me an example???
I think alerts are only available if you have Publisher. If not you have to use a macro.
Can u please share code for macros
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..
Please check the latest attachment
I think your needed like this.(Don't forget to give Mail settings.)
reply me if it is fine.
I will let u knw ,if its works fine.
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.