Can I send Outlook e-mail based on excel data condition?

[prasath17 (Guru)]

@Dorothy_lee - Another option would be filter the data first (this will avoid the if condition) and then read filtered data in the foreach loop for sending the email…

DtFiltered = (From r In Dtout.AsEnumerable
Where r("Feedback").toString.Contains("FALSE")
Select r).CopyToDataTable

Here dtfilterted is of variable Datatable.

For Dynamic body, Please try like this…(Copy paste the right hand side value to your body)

Make sure to check - isBodyHtml Checkbox in the property…

Hope this helps…