How to send alert email to different users based on condition inside the report?

[Anantula]

Hello All,

We need to send an email to different managers based on the condition inside the report.

The report has four columns Site, Site Manager email address (Email address has been captured in database), Actual, Target and a calculation column (Actual - Target).

When ever the calculated column is greater than 0 (Actual - Target > 0), we need to alert that particular site manager by sending them an email.

I tried below scenarios,
Watch Rules & Alerts - we can send it to only one user.
Event Studio - We can achieve this by creating multiple events. (In this scenario we have 120 sites and it is keep changing all the time)

Can some one help me out whether this is achievable or not?

Thanks & Regards,
Anand

[AussiePete2011]

have you considered Event Studio?