I need to filter mail address I have 40+ mail address is there I want to read that mails only
then I need to read and hear again I need to filter the subject I can use if condition for that
Like Subject contains (“Update”) like this
Here I need to send mail if I do not get the mail from the filter mail ID I need to send mail to them
How to do this? please help @NIVED_NAMBIAR
how to give filter excepression

if I use filter expression I get this error
RemoteException wrapping MailKit.Net.Imap.ImapCommandException: The IMAP server replied to the ‘SEARCH’ command with a ‘BAD’ response: Could not parse command
at UiPath.Mail.Activities.GetMailActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
I hope I will get a replay from you
Thanks
Chethan P
Hi @copy_writes
You can try in two ways
- Store the output of mails in get Outlook mail activitiy in mails variable.
Now use below assign query to filter mail containing subject as Update
mails = mails.AsEnumerable().Where(Function (mail) mail.Subject.ToString.Contains(“Update”)).ToList()
Other way is
In filter expression put the expression like this
“@SQL=” + “””” + “urn:schemas:httpmail:subject” + “””” + ” like ‘%Update%'”
I am not much sure with second way
But u can try that
Regards
Nived N 
Happy Automation 


1 Like
I have 40+ mail id is there from that mail id only I need to extract the body and I if it has update on that time we have to extract the body and place it in excel.
Hi @copy_writes
What u mean by update there ?
Like the mails contains only filteres mail whose subject is mail
If there are multiple mails having subject as Update u can loop through each mails and use mail.body to retrive the body of mail and can append to datatable
Regards
Nived N 
Happy Automation 


1 Like
if we need to extract the body and the subject from that particular mails like Chethan@gmail cherry@gmail.com Upto 40+ mails are there on that time what we have to do
Hi @copy_writes
did u mean that extraction of mails from 40+ is slowing the automation process by using for each ?
yes and how extract that particular 40 mail.
Hi @copy_writes
You can write in FilterExpression property “SUBJECT Update”
1 Like