I have a table which have multiple users and regions associated to them. I want to send email alert notification to only those users whose region is not doing well.
I have gone through discussions in the communities but was not able to find scenario where mail recipients can be dynamic.
I am able to send test mail now, but when i am entering the receipient name in Mail receipient box its not working,the mail is not sent to anybody. Am i missing something?
Yes, it is possible. In email body you can send the figures as Table format using Aggr & Concat function. So there is no need to send the Trigger twice for the same user. In single trigger only you will be able to Send the report for both Region for that user.
How can I have dynamic recipients and the msg body should generate based on user. Every user should not get same mail text. They should get their respective mail text containing their respective values.
