UiPath - How to read Outlook Mails and save them to Excel

[@andersjensenorg]

Do you want to learn UiPath from the beginning with my best guide? Then watch my UiPath Beginners Tutorial: kzbin.info/www/bejne/aYuuq4d-mdWmitU

[@tele2662]

Super video.. Thanks Anders!

[@andersjensenorg]

You're very welcome, Tele 2 - your support helps me a lot 😍

[@niccolodonati3588]

Awesome video!

[@andersjensenorg]

Hey Niccolo. Thanks a lot :) Kind regards, Anders

[@mailanuraggoyal1]

Very systematically explained. Please if possible also suggest how to get the mail body as well.

[@andersjensenorg]

Hey Anurag. Thanks for the kind words. You can just put in the following: item.Body.ToString Let me know, if that helps 😊 Kind regards, Anders

[@remixowlz]

Thank you so much sir! Your explanation is very good , keep up the great work ! :)

[@andersjensenorg]

Thank you, Sharkzz 🤩

[@coffeeedobrien]

this was very helpful , thank you !

[@andersjensenorg]

Thank you, Ed 😊

[@owgjunxian7111]

hi anders i love your videos i just want to ask if i have a section in outlook with different emails of same format but different format how do i extract the information inside the email

[@andersjensenorg]

Hey Owg Junxian Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@baijayantimalanayak5518]

Hi Anders, i want to extract the details of the phishing emails which are saved into a folder with eml extension. How should i do that because if i create a folder in my outlook and move the phishing emails to that new folder , then nothing gets extracted but if i give any other folder emails then those emails get extracted into an excel. It would be great if you could help me !!!!

[@andersjensenorg]

Hey Baijayantimala Nayak Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@cyrus300000]

Hi Anders, I like your videos, I've only just started learning UiPath, I have a key question that I'm trying to solve. I need to rename my files with a date string. The specific problem I have is downloading from Outlook (like in your 14 min video on the subject) and then saving to a folder, I was able to create individual folders (as you showed) but I need to save all of them in the same folder and give each download a name with a date string appended to the end. Make sense? Thank you for your videos they are great!

[@andersjensenorg]

Hey XQ...Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@scuolaperfezpnl]

Thank you for your good explanation. Can the robot enter in a mailbox not mine but another mailbox?Because I received always an error, in mine never error

[@andersjensenorg]

Hey Dany. Thank you. If it is Outlook no. Then the account needs to be configured locally. However you can go the Exchange way? Kind regards, Anders

[@griiiinless]

Hi Anders, I could create this project with no problem, cause you made it so easy and I appreciate that, but when I'm trying to do it on a remote machine, "Get Outlook Mail Messages: The specified folder does not exist" comes up. I switched focus to the Outlook on remote machine by making a basic recording, something else should I do? Thanks in advance.

[@andersjensenorg]

Hey Ali. First of all thank you very much 😊 You can only use the Get Outlook Mail Messages on the machine, where you robot run. If you wanna do it on the remote (and you can let the robot run here), then you need to do it with Exchange or in the UI (click activity etc.). I hope that that helped you, otherwise just write me. Kind regards, Anders

[@griiiinless]

@@andersjensenorg Thanks a lot for help. :-)

[@andersjensenorg]

* and you cant let the robot run here 😊

[@srushtiapandkar5777]

@@andersjensenorg Thankyou for making such detailed video it is easy to understand. Even I am facing the same issue. but i didnt understand the remote robot part which you explained in the above Reply. Kindly can you ellaborate please?

[@andersjensenorg]

@@srushtiapandkar5777 Hey Srushti. Thanks for the question. You can only use the Outlook activites on the current machine, meaning that if you have your UiPath on one machine and your Outlook mail account on another (e.g. by a RDP), you cannot use the Outlook Account, but instead you need to use Exchange Activities. Did that make sense? :) Kind regards, Anders

[@joyaldavidabraham5688]

Sir how to write queue items to excel

[@joyaldavidabraham5688]

Once all the queue items are processed then how to write the data table to an excel file.

[@andersjensenorg]

Hey JOYAL DAVID ABRAHAM Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@divyatirunagari2760]

How to read body of first unread email from email thread to excel ? I followed one of your video and successful in reading email body to excel, now am struggling to read only first email and don’t want the entire thread to be copied to excel. Is regex suggestible in this case?

[@andersjensenorg]

Hey Divya. In the 'Get Outlook Mail Message' you can set the property 'Top' to 1 (default is 30) - that is how many emails you wanna retrieve. If you only want unread, you just leave the tick in 'OnlyUnreadMessagesDisplayName'. Let me know, if that solved your problem 🙂 Kind regards, Anders

[@divyatirunagari2760]

Anders Jensen Thanks for your reply. My question is different. For an email thread in outlook, even when we open the latest mail, we can see the conversation.How to get the Latest unread email from the email thread? I don’t want the entire conversation of email thread.

[@jeffrey102000]

Hi Anders, thank you for the tutorial, its very helpful. I have two questions, 1) how do I access the subfolders on an inbox instead of the main inbox, I tried using the subfolder name instead of the inbox name and had an error, it did not recognise the subfolder name. 2)I need to analyse emails in a shared inbox and i believe every email has a tag so even if it is replied to multiple times keeps the same tag or sort of email id from outlook. I want to create an analysis to see how effective we are responding to emails and how long it took of a particular email to be dealt with, where can i find this outlook id or tags relating to a particular mail. Thanks

[@andersjensenorg]

Hey Jeffrey. Thanks for your kind words 😊 Regarding your first question, make sure you specify the right account (e.g. [e-mail]) and in the MailFolderDisplayName you simple just put in "Inbox\Subfolder". That will work. Regarding your second question use the expression 'item.Headers("UID").ToString' Let me know, if that helped you? Kind regards, Anders

[@jeffrey102000]

@@andersjensenorg Hello Anders, Thank you for your swift response. I tried your suggestions with the name of the email account and the "Inbox ameofsubfolder" and it worked. for some reason it doesn't work when I enter the actual email account. The other thing I observed was, it timed out when i tried to extract the 3000 plus emails in that folder, I set the time to 300000 and then to 600000 but no joy. What I failed to mention earlier was, there are different subfolders on this shared email account for the different users using the shared mail account, and what I am trying to do is analyse per user. Is there a way to search the multiple subfolders? something on the lines of the multiple assignments we did with the variables we passed in the for each loop? What I also noticed is I get errors like item.From.ToString doesnt exit on some of the other subfolders. Thank you for your kind assistance.

[@SumitSingh-cg2qc]

Hi, Anders jensen I have a problem related to extraction of mail message form outlook when i execute a Get outlook message" activity and use a message box it shows a message "[UiPath Community Forum] Summary". I able to understand why this shows to me can you please regarding this problem. Thanks

[@andersjensenorg]

Hey Sumit Singh Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@jeffrey102000]

Hi Anders, sorry its me again, I noticed that the date i got from your video class is just the "From date" on the email body. I am trying to estimate how long it takes for msg's in the box to be fully answered so i need both dates eg when the mail was received and when the response was given, so i need to be able to extract both "From" and "To" dates on the mail. I also noticed the "UID" doesn't appear to be the actual msg-ID, I was hoping to use the "UID" as a key for both "From" and "To" on the message to establish the link between the msg's but they are not related. I thought i could take a specific subject on one of the emails that are related and verify the relation with the "UID" but the "UID" doesn't seem related so i cannot use that as an option to aggregate the msg's

[@andersjensenorg]

Hey jeffrey. Can you read the 'Send' folder and in there get the sended time? Regarding your UID, I honestly don't know. I'm sorry I cannot help your further. If you find a solution, I would be very happy, if you want to share it with me 🙂

[@andrewandrew9928]

Hi Anders, great video! How would the file path to a subfolder in Outlook look like? For example, in my Inbox, I have Invoices folder and within Invoices folder, I have New folder. Would the folder path be "Inbox\Invoices\New"? I tried it and it's not working, so I'm wondering if the MailFolder path needs to be in a different format

[@andrewandrew9928]

I figured it out myself! :D

[@andersjensenorg]

@@andrewandrew9928 Hey Andrew. I'm sorry for the late reply, but glad you've figured it out yourself 😊 Kind regards, Anders

[@일본사는한국남자日本]

Hi Mr. Anders Jensen I always enjoy your tutorial. Thanks a lot. I have three questions when I download attachments of outlook in UiPath. To solve my inquiry, I am trying to watch your all videos. If there is already the video, can you recommend me ? Or not Can you upload the solution?? or teach me.? Here are three questions. 1. I want to save attachments by filter fuction i do not want to download files which File's subject has "RE:" 2. And I want to download only attachments by deciding specific time. For example, 13/07/2020 12:00 ~20/07/2020 11:59 I watched the video you already explained. However, I want to change the period (number)every week automatically!! I mean when I try to run the UiPath next week, I do not want to change the period in my hand. even though I do not change the period by my hand, is there any way to change the period every week in automatically?? Or set the period?? So sorry to ask a complex question. 3. The last question is related to the attachements and excel. I want to extract the cell data of attachments and paste to another sheet's cell. This is possible now. However, I do not want to run the attachments file I already ran when I tried to run three times or five times because I do not want to overlap the information of attachments' cell data. For example if there are three attachements, I ran. The data is recorded. And then I ran again. Then, I got a new attachment file. If I run, already existed three files will be run again right?? let me just run a new attachement file only. These are all. I am so sorry to ask lots. I really enjoy your tutorial and click good botton! Please help me

[@andersjensenorg]

Hey Huynmin. Thank you 😊 I have made this answer for you, let me know if it helped? 1) The easiest thing to do is inside your for each, where you iterate through each mail, make an If with the condition item.Subject.Tostring.StarsWith(“RE:”). And then put your actions in the Else. In that way you will skip the re mails. You can solve it in the filter/vb as well. 2) Check this video kzbin.info/www/bejne/e5rdi4Oenad_ebM from 10:37 3) I do not understand completely, can you elaborate? Kind regards, Anders

[@FazlulHaque77]

Followed everything minutely but on Run with write line Date activity got the error message saying = Write Line: Object reference not set to an instance of an object. could not solve

[@andersjensenorg]

Hey Fazlul Haque Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@mariposa9318]

Very good turturial! But how do I sort out the mails and there possible PDF attachments with keywords stored in 2 CSV files?

[@andersjensenorg]

Hey Mari, can you elaborate your case a bit more? I'll gladly make a video about it. Kind regards, Anders

[@mariposa9318]

@@andersjensenorg Thank you for responding! I have to make an attended robot with ReFramework. * Create 2 text files with keywords (to see if it is an invoice or reminder). * Read the emails (IMAP) from - [e-mail] (out Config) with the keywords from the 2 different text files. * Save the PDF files in attachments and filter them with the same keywords (from the 2 text files) invoices or reminders. * Create 1 text file CSV with 2 columns: VAT number | mail address --- In this list possible use 2 mail addresses: - [e-mail] - [e-mail] If INVOICE: * Extract the VAT number with a Regex. * Based on the VAT number and the list of VAT numbers and mail addresses, determine to which mail address the invoice should be forwarded. * Forward the invoice to the email address found. (SMTP) If REMINDER: * forward PDF to mail address - admin@ demo.com (out Config). If NO invoice, NO reminder (or no attachment): * forward mail to - [e-mail] (out Config). Thank you in advance Kind regards, Mari

[@andersjensenorg]

@@mariposa9318 Hey Mari. Let's break it down, cause it will be quite a massive answer to make. How far did you come and what's the problem in the making of the workflow? Kind regards, Anders

[@mariposa9318]

@@andersjensenorg Hello, I have problems to filter the PDF's (that I saved in a folder) with the keywords (i stored in 2 CSV files). So I'm stuck from there. :-) greetings

[@itsmechethan6105]

Can you please do a video on using APIs we have to automate website or using API key we have to automate the map not only map. some other activity like fetching or send the data because a lot of people don't know about how to use API in uipath

[@andersjensenorg]

Hey ItsMe Chethan. Can you use this: kzbin.info/www/bejne/fpq2kJ-HZtyVepY Kind regards, Anders

[@Montu24]

How to extract specific data from the body of the mail and I want to use for multiple mails

[@andersjensenorg]

Hey Mihir. Great question. Check the video I upload in 8 hours :) If you can't wait, write me on LinkedIn and I send you the link directly. Kind regards, Anders

[@sameermore2249]

Hello sir can you help how to read Email atach document under particular text

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@MrShoumen]

Hi.. THanks for the video. I just wanted to know how can I copy a table from email body to ta excel

[@andersjensenorg]

Hey Shoumen Biswas Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@govindpatel8063]

How can I extract specific data from the body of the mail and save into Excel

[@andersjensenorg]

Hey Govind. Sure. Check this video, I've just made: kzbin.info/www/bejne/d4eYanenna-UaZo :) Kind regards, Anders

[@sunny-handa]

how to pick specific text or numerical value from body of the email?

[@andersjensenorg]

Hey Sunny Handa Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@sathishKumar-lr7tl]

Multiple Assign: Can not assign 'item.Headers("Date").ToString' to 'strdate'. i am getting this error message

[@andersjensenorg]

Which one?

[@itsmechethan6105]

Hello, Andres please help I am trying to get a mail body I get a null value I use item.body.tostring I get null if I use item.header("Html Body").tostring for this expression I get the mail body and it in Html I need to extract only body how to do? Please help me I hope I will get a solution from You

[@andersjensenorg]

Hey ItsMe. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@bahadarkhan6355]

Hi, Anders I get all images which are in mail body for example under signature as attachments. How could I avoid theses? Thanks, Bahadar khan

[@andersjensenorg]

Hey Bahadar. Then we have to filter in the data and extracting the things we want and don't want. Can you provide me with an example of your mail and what you want (just anonymize the data)? Kind regards, Anders

[@j0k3R619]

Hi can you show how to extract other details like Flag status, categories, size (mail size in kb) and Flag completed date?

[@andersjensenorg]

Hey Jennish. For the size you can do a for Each on the attachments and them you can get the length with mailitem.contenstream.length. I am not really sure, how you get Flag status out, sorry. Kind regards, Anders

[@j0k3R619]

@@andersjensenorg its ok ..no problem... Thanks for your quick response

[@jeffrey102000]

Hi Anders, I am still experiencing timeout even when i set it to 20mins just to extract about 2600 emails. What am I doing wrong?

[@andersjensenorg]

Hey jeffrey. Tbh I don't think, you're doing anything wrong, but more likely itøs a hardware/UiPath issue. I would write to the support at UiPath and hear their oppinion. They're quick to reply and very helpful. In this isssue, I can't help you, sorry 😞 Kind regards, Anders

[@jeffrey102000]

@@andersjensenorg Thank you ever so much.

[@dmitrygarmatyuk3831]

Hello, the script is always overwrites the results in Excel sheet. How to save added earlier rows in a Excel sheet?

[@andersjensenorg]

Hey Dmitry Garmatyuk Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@kratirajoriya3117]

hello Anders, how can i get the particular data from the body of the mail

[@andersjensenorg]

Hey Krati. Regex is my go-to solution. Check this video, where I extract particular data out of a PDF. Let me know, if you have more questions, I will guide you 🙂 Kind regards, Anders kzbin.info/www/bejne/q3THc3Zopb2Dr7s

[@ranjaniranju8834]

Is there a way to read the attachments of same name in all the mails

[@andersjensenorg]

Hey ranjani. Check this: kzbin.info/www/bejne/e4q9oYBmnJtqgKc The plan is to save the attachments dynamocally, eg with the date and time down to miliseconds 🙂 Kind regards, Anders

[@kratirajoriya3117]

hello Anders, i am getting the the error of object reference in data row

[@andersjensenorg]

Hey Krati. That's most like a null reference. Check that your variables are in scope. Kind regards, Anders

[@tanupareta6171]

What is same process in Gmail account... ??

[@andersjensenorg]

Hey Tanu. You can either use the gmail activity or use the gsuite like this kzbin.info/www/bejne/pZzVfISborR-hJI The latter is by far the most robust solution. Kind regards, Anders

[@nicolevillegas7267]

How do you get words from the body of the email?

[@andersjensenorg]

Hey Kicthen Realities, great question, I just created this to answer the question, kzbin.info/www/bejne/sKrCoZ2fq913fa8 Please let me know, if that solves the problem 😊

[@maddinenirajeshbabu3143]

@@andersjensenorg thanks in advance how to download load particular extension attachments using ui path Example we have outlook attachment having .pdf,.txt,.html,.zip attachment are there I want download only pdf files can you help on this

[@andersjensenorg]

@@maddinenirajeshbabu3143 Thanks for the question. Yeah use the save attachment and in the filter you wanna use the ".pdf" (regex). If you are in doubt, let me know and I make a video :)

[@aleksandrakondraciuk2401]

how to add link to folder if its name agrees with id?

[@andersjensenorg]

Hey Aleksandra. Can you be a bit more specific (my brain might be a little slow, sorry). You want to add a link to the specific folder in the DataTable for each of the files, where we have an attachment? Kind regards, Anders

[@CA_Sandeep_Modi]

please increae volumn while recording

[@andersjensenorg]

Will do 😊✌️

[@NatkhatNeel]

How to read only excel sheet data from the saved attachment folder?

[@andersjensenorg]

Just to understand your question correctly: You downloaded X attachments and now you only wanna read the .xlsx files right? Do you wanna open them or just get the file names?

[@NatkhatNeel]

@@andersjensenorg I want to read the data from it

[@andersjensenorg]

If it's one particular excel sheet, just use a read range, like here kzbin.info/www/bejne/e2qqhn9raLtmY6c and then you can work with it. If you dont know the names of the sheets, then I made a video just about that, but need to be edited. Will be up tomorrow in like 12 hours :)

[@NatkhatNeel]

@@andersjensenorg ok thank you

[@NatkhatNeel]

Can you please share a video how to extract only numbers from invoices? And also having a Data like "ui20path20" need to read this data from text file and sort it like uipath2020 and write it to excel.

[@praveendhanasekar2555]

How to bring email in foreground

[@andersjensenorg]

Hey Praveen Dhanasekar Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@damandeepsingh2859]

You Screen size is too small don't know why.

[@andersjensenorg]

Hey Damandeep. Have you tried it on a computer and remembered to change the KZbin resolution to 1080p? Kind regards, Anders

[@damandeepsingh2859]

@@andersjensenorg yes that's the only option.