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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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 !!!!
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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.
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
@@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?
@@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
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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
Hey Jeffrey. Thanks for your kind words 😊 Regarding your first question, make sure you specify the right account (e.g. jeffrey102000@mail.com) 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
@@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.
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
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 🙂
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!
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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?
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
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.
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
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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 ruclips.net/video/uCdBC2pXPyY/видео.html
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
Hey ranjani. Check this: ruclips.net/video/EYZpM0g67JE/видео.html The plan is to save the attachments dynamocally, eg with the date and time down to miliseconds 🙂 Kind regards, Anders
@@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 - mail_demo@demo.com (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: - invoices_demo@demo.com - sales_demo@demo.com 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 - other@demo.com (out Config). Thank you in advance Kind regards, Mari
@@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
@@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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Hey Kicthen Realities, great question, I just created this to answer the question, ruclips.net/video/zy_pjivxDGM/видео.html Please let me know, if that solves the problem 😊
@@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
@@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 :)
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
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
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
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 ruclips.net/video/EizZPhhBLCQ/видео.html from 10:37 3) I do not understand completely, can you elaborate? Kind regards, Anders
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?
If it's one particular excel sheet, just use a read range, like here ruclips.net/video/E9GUL53V3-E/видео.html 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 :)
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.
Hey Tanu. You can either use the gmail activity or use the gsuite like this ruclips.net/video/okrKQemOKN0/видео.html The latter is by far the most robust solution. Kind regards, Anders
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
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Do you want to learn UiPath from the beginning with my best guide? Then watch my UiPath Beginners Tutorial: ruclips.net/video/3ZKzTHdpsTs/видео.html
Sir how to write queue items to excel
Once all the queue items are processed then how to write the data table to an excel file.
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Very systematically explained. Please if possible also suggest how to get the mail body as well.
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
Awesome video!
Hey Niccolo. Thanks a lot :) Kind regards, Anders
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 !!!!
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Super video.. Thanks Anders!
You're very welcome, Tele 2 - your support helps me a lot 😍
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.
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
@@andersjensenorg Thanks a lot for help. :-)
* and you cant let the robot run here 😊
@@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?
@@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
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
this was very helpful , thank you !
Thank you, Ed 😊
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
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
Thank you so much sir! Your explanation is very good , keep up the great work ! :)
Thank you, Sharkzz 🤩
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
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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
Hey Jeffrey. Thanks for your kind words 😊 Regarding your first question, make sure you specify the right account (e.g. jeffrey102000@mail.com) 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
@@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.
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
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 🙂
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!
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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?
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
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.
How to extract specific data from the body of the mail and I want to use for multiple mails
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
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Hello sir can you help how to read Email atach document under particular text
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
how to pick specific text or numerical value from body of the email?
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
How can I extract specific data from the body of the mail and save into Excel
Hey Govind. Sure. Check this video, I've just made: ruclips.net/video/AV59DqhJa38/видео.html :) Kind regards, Anders
hello Anders, how can i get the particular data from the body of the mail
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 ruclips.net/video/uCdBC2pXPyY/видео.html
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
I figured it out myself! :D
@@andrewandrew9928 Hey Andrew. I'm sorry for the late reply, but glad you've figured it out yourself 😊 Kind regards, Anders
hello Anders, i am getting the the error of object reference in data row
Hey Krati. That's most like a null reference. Check that your variables are in scope. Kind regards, Anders
Is there a way to read the attachments of same name in all the mails
Hey ranjani. Check this: ruclips.net/video/EYZpM0g67JE/видео.html The plan is to save the attachments dynamocally, eg with the date and time down to miliseconds 🙂 Kind regards, Anders
Very good turturial! But how do I sort out the mails and there possible PDF attachments with keywords stored in 2 CSV files?
Hey Mari, can you elaborate your case a bit more? I'll gladly make a video about it. Kind regards, Anders
@@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 - mail_demo@demo.com (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: - invoices_demo@demo.com
- sales_demo@demo.com
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 - other@demo.com (out Config).
Thank you in advance
Kind regards,
Mari
@@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
@@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
Hello, the script is always overwrites the results in Excel sheet. How to save added earlier rows in a Excel sheet?
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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
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
Hi.. THanks for the video. I just wanted to know how can I copy a table from email body to ta excel
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Multiple Assign: Can not assign 'item.Headers("Date").ToString' to 'strdate'. i am getting this error message
Which one?
How do you get words from the body of the email?
Hey Kicthen Realities, great question, I just created this to answer the question, ruclips.net/video/zy_pjivxDGM/видео.html Please let me know, if that solves the problem 😊
@@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
@@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 :)
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?
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
@@andersjensenorg Thank you ever so much.
Hi can you show how to extract other details like Flag status, categories, size (mail size in kb) and Flag completed date?
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
@@andersjensenorg its ok ..no problem... Thanks for your quick response
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
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 ruclips.net/video/EizZPhhBLCQ/видео.html from 10:37
3) I do not understand completely, can you elaborate?
Kind regards, Anders
How to read only excel sheet data from the saved attachment folder?
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?
@@andersjensenorg I want to read the data from it
If it's one particular excel sheet, just use a read range, like here ruclips.net/video/E9GUL53V3-E/видео.html 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 :)
@@andersjensenorg ok thank you
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.
What is same process in Gmail account... ??
Hey Tanu. You can either use the gmail activity or use the gsuite like this ruclips.net/video/okrKQemOKN0/видео.html The latter is by far the most robust solution. Kind regards, Anders
how to add link to folder if its name agrees with id?
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
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
Hey ItsMe Chethan. Can you use this: ruclips.net/video/HiS_lQ1wbD4/видео.html Kind regards, Anders
please increae volumn while recording
Will do 😊✌️
How to bring email in foreground
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
You Screen size is too small don't know why.
Hey Damandeep. Have you tried it on a computer and remembered to change the RUclips resolution to 1080p? Kind regards, Anders
@@andersjensenorg yes that's the only option.