UiPath Tutorial 09 - Read Email in UiPath | Filter Email in UiPath | Get IMAP Mail Messages Activity

Hi Guys!
In this video we will learn -
How to retrieve emails
How to filter emails(Apply conditions on retrieved emails)
Get IMAP Mail Messages Activity
MailMessage Variable
=============================================================
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A1...
UiPath Tutorial Playlist:
• UiPath Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764

[@qualityassurancelab7764]

Hi Guy! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@rimantasdanilevicius6754]

Once again, thank you for great tutorial. How to know which port to use? Does port 993 is default as imap.gmail.com for all such gmail cases?

[@qualityassurancelab7764]

@@rimantasdanilevicius6754 You are welcome, yeah 993 is default for imap.gmail.com

[@shivavaishnav1711]

Hello Ma'am. Thanks for your tutorial videos it's helping me alot. I'm facing problem will performing this activity, as Google is blocking me from entering in my own gmail and i am getting error message while running the Uipath. Can you please guide me. Thanks you so much

[@rimantasdanilevicius6754]

@@qualityassurancelab7764 Thanks for reply :)

[@qualityassurancelab7764]

@@shivavaishnav1711 You are welcome, please let me know what error message you received.

[@swarnavamseekrishna5011]

Very well explained and loads of thanks to you 🙏.

[@jyothijosh2006]

The way of explaining concepts are really good and very neat too, thank you for the providing such a good examples.

[@aswinkv9630]

Hai Quality Assurance Lab team, you are just amazing. I have no IT background and even me can understand your videos. Special appreciation to the lady who handle lectures. Madam your are explaining everything in grassroot level in simple language. Thank you

[@qualityassurancelab7764]

Thank you so much for the feedback, I am really glad to know that these videos are helpful to you

[@panji8764]

Love it

[@palanivels4478]

Hi, I could not find list format in Browse tyes

[@zhenhuixiang6816]

Hi, how could I find emails with specific subject pattern but not exactly the same word? e.g. I would like to find email with subjects like this "abcd# 12345 approval required" and "abcd# 56789 approval required"

[@mscoder9902]

Thanks

[@deepakgautam6904]

Hi mam how do you record with obs I am getting a lot of selector error when I record.

[@bharatsuri5976]

Hello , you had put find "mail" in "mails" ....... in which mails was a list variable storing all unread emails... but how does the system recognize "mail" ? is that a system variable ??

[@zahidakhtar8]

Hi, Could you please share a video how to read subject of undelivered outlook mail. I didn't find anything helpful or a feature in Uipath to do this. Some answers in forum says.... you need to code but what to code and how to incorporate it in uipath. It will be helpful if you make a video on it.

[@adarshjain2745]

Is there any issue in automating banking websites login?

[@nitaprasad3855]

Hi can you please make a tutorial on Image and text automation ?

[@yakkalilikitha5872]

mam i didnt retrieve my mails because of this issue "Get IMAP Mail Messages: The operation has timed out." i get this error before dropping if condition only.

[@lavanyac7241]

Hi Ma'am! this helped me out a lot.. but I have small doubt, that can we have a result report for this?

[@dr.mohammedmohammed7633]

where you got the email port , 993 , please can you clarify those thing ?

[@darknight929ify]

hello, how do we add something from gmail to excel in row and coloumns [

[@Suri_Aqua]

Main.xaml: (2) : error BC30451: 'VarMail' is not declared. It may be inaccessible due to its protection level. help me to resolve this

[@jb_godzilla7398]

I liked the tutorial but a question apart from reading the data above such as the address and the subject, it is possible that UiPath can enter the emails and download a file, exit and do the same with another

[@qualityassurancelab7764]

Yes, UiPath can download the email attachments using the activity Save Attachments.

[@adarshjain2745]

How can one know the port and server of other websites in which one want to login....

[@saisrikanthbalijepalli3432]

Hi Quality Assurance lab I am trying to read the body of the gmail. For this I have used "item.body" in for each activity. I could see it as blank. When i tried to read the subject or From , it is working fine. Kindly provide your inputs on the same.

[@qualityassurancelab7764]

Hello! To get email body , add an assign activity and assign the value mail.Headers(“HTMLBODY”).ToString to the variable say body This will give you HTML body. To get the plain text out of it - Create a variable regex of type new System.Text.RegularExpressions.Regex add one more assign activity and assign the value regex.Replace(body, "", string.Empty) to the variable say plainEmailBody. The variable plainEmailBody will display the email body in the message box.

[@tejaswinerella5223]

Hi, @Sai did you tried that regex process using assign activity?

[@user-vd5gt9if4u]

Hi madam, Can we make unstructured data into structured excel data files using UiPath ?

[@qualityassurancelab7764]

Hi, could you please explain the scenario a bit more, what is the content of the unstructured data , and what you want to convert?

[@shekarsingh7424]

can anyone tell me why I am getting invalid credential error? despite of filling correct email and pass.

[@shafmairaj6493]

I'm getting this error i tried less secure setting in google account , app password thing , enabling IMAP in google account but couldn't resolve it ERROR: Get IMAP Mail Messages: Timed out while waiting for Mail Service to connect. RemoteException wrapping System.TimeoutException: Timed out while waiting for Mail Service to connect 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)

[@bounguichakhmayes6103]

I find this exception : RemoteException wrapping MailKit.Security.AuthenticationException can you explain ?

[@qualityassurancelab7764]

To access email with the help of applications like UiPath, JMeter, Automation Anywhere etc., sometimes app password is required , instead of normal email password. Please generate app password and try again - kzbin.info/www/bejne/gnqag5iwh81qbKc

[@ajaythyaraj4141]

Disable antivirus temporarily

[@hasibshohag7308]

I got one point on Logon is secure password ! what to do?

[@amritasharma7575]

i have this error ....plz help

[@Vijaykumar-ct6ss]

12:00 split function... Array

[@gauravchaurasiya3335]

it shows invalid credentials (i checked every information is correctly filled) plz help what to do.....

[@qualityassurancelab7764]

Could you please try again by - Enable 2 step authentication on Gmail account generate app password for the same account Use app password instead of regular password in the UiPath project Please refer this - kzbin.info/www/bejne/gnqag5iwh81qbKc

[@shapbnil]

What to do if this Error message coming?? Source: Get IMAP Mail Message, Message" Invalid Credentials(Failure), Exception Type: MailKit.Security.AuthenticationException. Please help

[@qualityassurancelab7764]

Could you please try again by turning on less secured app security settings in gmail - myaccount.google.com/lesssecureapps?pli=1

[@srushtikotangale2064]

I am getting the same error.

[@bhanumahesh1125]

can't we do email activity in sequence workflow?

[@qualityassurancelab7764]

Yes you can do

[@basitmirza7649]

How to extract datatable from emails and save it on excel file?

[@maswani8561]

hi team, i am not able to create variable please help me to create variable like you are create in this vedio.

[@mkarthik14]

Hi Madam, Very useful video. How to get the port number ?

[@qualityassurancelab7764]

Hi, thank you! Port numbers are fix for every server, you can search for port number on internet

[@sampathvangala9405]

what shoud be the if condition for sender of the mail

[@qualityassurancelab7764]

You can check the conditions such as sender of the mail is a specific sender , sender contains any specific text etc.

[@krishnasai5111]

I'm getting error in host property madam no such host is known

[@adarshjain2745]

For me google is blocking the sign in attempt

[@venkatabhinesh4980]

Hi I gave correct credentials but when it debug it's shows invalid credentials

[@JamshedpurMusafir]

I am going through same error

[@nemizjain]

Some of the activities are not available are not available in our studio. It is very difficult to follow you

[@prashantrai5911]

Acha padhati ho aap thoda jyada video UI PATH used cases ke project par banaiye.jyada se jyada video UI PATH par banaye jaise AUTOMATION ANYWHERE par banaya hai

[@qualityassurancelab7764]

Thank you, I will make more videos on UiPath. You can let me know if you have any specific scenario on which you wish me to make videos.

[@prashantrai5911]

@@qualityassurancelab7764 ok I sent u one case at your mail id u can make video on that used case,and by the way r u working in any organisation or unr working as a tutor.Meanwhile make a video on that how can fresher get a job in UI PATH developer

[@vijaypalkankanala5577]

Download Gmail attachment using uipath

[@maheshbharathakavi2013]

i need full information and scenarios based on real time how can i get it if i take membership you will provide right ?

[@qualityassurancelab7764]

Hi, Mahesh, I replied to the question over the email, please let me know if you have any further questions.

[@maheshbharathakavi2013]

am getting error as below Get IMAP Mail Messages: An error occurred while attempting to establish an SSL or TLS connection. One possibility is that you are trying to connect to a port which does not support SSL/TLS. The other possibility is that the SSL certificate presented by the server is not trusted by the system for one or more of the following reasons: 1. The server is using a self-signed certificate which cannot be verified. 2. The local system is missing a Root or Intermediate certificate needed to verify the server's certificate. 3. The certificate presented by the server is expired or invalid. See github.com/jstedfast/MailKit/blob/master/FAQ.md#InvalidSslCertificate for possible solutions.

[@qualityassurancelab7764]

Could you please try again by turning on less secured app security settings in gmail - myaccount.google.com/lesssecureapps?pli=1

[@whiterabbit2296]

For those is having Invalid credentials (Failure) please go to your Gmail security and "Allow Secure apps" if doesn't how to able the secure please go to myaccount.google.com/security and turn on less security Alerts!!! only did it in your testing account or new account

[@qualityassurancelab7764]

Thanks for sharing

[@kesava90]

In 2020 version don't have Type Argument in For Each activity...how to solve ?

[@qualityassurancelab7764]

Could you pls share the exact version and release number? Did you tried by restarting the system, it worked for many people.

[@kesava90]

@@qualityassurancelab7764 Studio 2020.10.2-beta 4 , and i tried restarted

[@qualityassurancelab7764]

@@kesava90 I will get back to you as soon as I get the solution

[@rajeenasuresh]

@@qualityassurancelab7764 Is it because of selecting, For Each row instead of For Each, when I accidentally selected For Each Row I coudnt find the argument type.

[@qualityassurancelab7764]

@@rajeenasuresh Yes, For Each Row do not have argument type. For Each activity has the argument type.

[@bhanumahesh1125]

i got runtime execution error how to solve it

[@qualityassurancelab7764]

Could you pls share the complete error?

[@bhanumahesh1125]

@@qualityassurancelab7764 source:Get imap mail messages Message: the operation has timed out Exception type: System. TimeoutException

[@qualityassurancelab7764]

@@bhanumahesh1125 Open UiPath Studio as admin and provide the property value of TimeoutMS as 200000 in Get imap mail messages activity.

[@pritishsahoo3331]

Hi , it throws timeout exception when trying to access the gmail account

[@qualityassurancelab7764]

Hi, could you please confirm if any firewalls are blocking the communication

[@yashgorey]

i have error on gmail for security issue

[@qualityassurancelab7764]

Could you please share the exact error?

[@yashgorey]

@@qualityassurancelab7764 message!!! (Someone just used your password to try to sign in to your account from a non-Google app. Google blocked them, but you should check what happened. Review your account activity to make sure no one else has access. )

[@qualityassurancelab7764]

@@yashgorey You got this email since you tried to access gmail account from an App, i.e. UiPath. Were you able to execute the task from UiPath? If not, please enable 2 step Authentication and generate App password - kzbin.info/www/bejne/gnqag5iwh81qbKc Provide that app password in the UiPath project and try to execute again.

[@yashgorey]

@@qualityassurancelab7764 Plz make more Video on UiPath

[@qualityassurancelab7764]

@@yashgoreySure, you can checkout the latest video on UiPath Orchestrator - kzbin.info/www/bejne/eIi3f6Kpq52Girs

[@saritha.massistantprofesso2267]

i got such type of error

[@amritasharma7575]

Get IMAP Mail Messages: An error occurred while attempting to establish an SSL or TLS connection. One possibility is that you are trying to connect to a port which does not support SSL/TLS. The other possibility is that the SSL certificate presented by the server is not trusted by the system for one or more of the following reasons: 1. The server is using a self-signed certificate which cannot be verified. 2. The local system is missing a Root or Intermediate certificate needed to verify the server's certificate. 3. The certificate presented by the server is expired or invalid. See github.com/jstedfast/MailKit/blob/master/FAQ.md#InvalidSslCertificate for possible solutions.

[@qualityassurancelab7764]

Hi Amrita, I believe you have done same settings in the property of Get IMAP Mail Messages Activity as shown in the video, along with the PortDisplayNumber as 993 and ServerDisplayName as "imap.gmail.com". Such error mostly pccur due to installation of the any Antivirus software in the system. Could you please disable antivirus temporarily and try again?

[@kanchanggogoi7250]

@@qualityassurancelab7764 i was also facing the same issue...uninstalled antivirus...issue resolved

[@qualityassurancelab7764]

@@kanchanggogoi7250 thanks for sharing!

[@veera567g3]

Authenticatio error problem even i have given with correct credentials and again and again the same error. but finally i have solved the issue with other video tutorials. feeling disappointed with this

[@meditativeminds9159]

What to do if this Error message coming?? Source: Get IMAP Mail Message, Message" Invalid Credentials(Failure), Exception Type: MailKit.Security.AuthenticationException. Please help

[@qualityassurancelab7764]

please enable 2 step Authentication and generate App password - kzbin.info/www/bejne/gnqag5iwh81qbKc Provide that app password in the project instead of normal password and try to execute again