How to send reports to email addresses in the query results?

[uagraw01]

Hello Splunkers!!

As per the below results. I want to send individual report to each manager on their email id. Likewise I have more than 50+ managers And i have to send individual reports on their individual email id. Please guide me how can I achieve this.

Manager	pass	fail	email
abc	80	20	abc@gmail.com
xyz	70	30	xyz@gmail.com
nbq	60	40	nbq@gmail.com

[johnhuang]

• To send a separate email for each of the results, make sure you set "Trigger: For each result" in your alert configuration.
• To send the email to a recipient defined by a field value in your report, you can configure the the "To:" address to $result.<field_name>$, e.g. in your case it should be $result.email$