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.
(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!
(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!