Hello, all I’d like to send e-mail if specific column condition is ‘False’ Can I achieve it with Activities function? Select only ‘False’ contents row (Feedback column) Including excel information to Outlook body , header… etc dynamically [image] [image] Thank you~

@Dorothy_lee - Here is my xaml [image] dtfiltered = (From r In Dt.AsEnumerable Where r("Feedback").toString.ToUpper.Contains("FALSE") And (Not r("Feedback") Is Nothing OrElse Not String.IsNullOrEmpty(r("Feedback").ToString)) Select r).CopyToDataTable Please See the output below… [image] Hop…

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

Help Activities

Dorothy_lee May 11, 2021, 7:31am 19

@prasath17 Thank you so much!
It’s perfectly working now… !

1 Like

How not to read null value in excel while writing to excel or text file?

Topic		Replies	Views
How to send an outlook email based on raw data Help excel , mail , outlook , activities , question	17	1574	November 22, 2019
If activity and send outlook mail message activity error Studio studio , question , activities_panel	3	29	September 3, 2024
Get outlookmail activity-subject Help activities , studio	16	1183	July 2, 2019
IF and ASSIGN activity (to compare excel values) Activities excel , activities , question	10	1645	September 8, 2021
Assign a value from excel to a variable Help	4	3106	April 3, 2018

Most Active Users - Yesterday
ashokkarale
Anil_G
Ruban_shanmugam
Lalit_Chaudhari
eyashb
sonaliaggarwal47
PWilliams
AzeemK
Juan_Hkahfi
More details...

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

Related topics