i have an input.csv file which has similar data as follows
Field1(status) - Not completed / Completed
Field2(emailid) - email@example.com
Now for all those records where status="Not completed" i want to send email to all those emailids.
How to achieve this in most simplest way.
You can try something like this:
| table field1 field2 | where field1="Not completed" | map search="sendemail to="$field2$""
Also command reference is you want to add more option to sendmail:
View solution in original post