How to send a single email to multiple email id mentioned in different rows of the table

[rahulbhatia]

Hi All

I have following table as outcome of my query :-

Name lastname Emailid
A D abc@gm.com, xyz@redif.com
B E bcd@dm.com
C F fgh@yah.com

I want to send this table to all the email ID's mentioned under EmailID column in a single email.

[sandeepmakkena · Accepted solution]

(YourSearch)
| eval mail= Emailid
| eventstats values(mail) AS mail_adresses 
| eval recipients=mvjoin(mail_adresses, ",") 
| table Name,lastname,mail, recipients
| sendemail to=$result.recipients$ 

Hope this helps, Thanks!