UiPath | How to Download Attachments from Outlook and save them dynamically | Tutorial
ฝัง
- เผยแพร่เมื่อ 1 ก.ค. 2024
- Learn how to download attachments from Outlook with UiPath. This very easy guide shows you how to. Afterwards we show the solution to the problem, if the attachments are named the same and how we then save them without overwriting.
You could also watch:
🔵 UiPath RPA Beginners Tutorial - • UiPath RPA Beginners T...
🔵 How to use Outlook with Uipath • I Build my RPA Company...
00:36 Get Outlook Mail Message
We get the desired amount of Outlook Mail Messages and store them into a list of mailmessages.
00:40 Mail Account Property
It's always best practice to specify the mail account to make sure, we don't accidentally look in another mail account at the computer.
01:06 Mail Folder
Remember to specify what Outlook folder to look in. Default is Inbox.
01:57 Save Attachments
Use the Save Attachments activity to save attachments.
02:08 For Each
We iterate through our list of mails. And then save the attachments.
02:25 Setting the TypeArgument in For Each
Remember to set our TypeArgument to System.Net.Mails.
03:55 Problem with Attachments with the same name
Solve for the problem with attachment with similar name (create unique file names for the attachments).
05:18 How to get the date of the mail and use it as an ID
We create unique file names by using the date of the mail.
07:18 Using DateTime
10:25 Use an If to check if the got any attachments
11:05 Create Folder
Connect with me:
🔔 Subscribe - th-cam.com/users/klogeande...
💼 LinkedIn - / andersjensens
👥 Facebook - / andersjensenorg
💌 Email Newsletter - andersjensen.org/email-newsle...
#uipath #rpa #automation
Check the full playlist with Outlook Tutorials: th-cam.com/play/PLXXz88_TPiHrhtzUv0CYARIujXSjZqelc.html
This playlist takes to a different playlist not outlook
Great job Anders. This video is very much helpful. Thanks!
You're very welcome, maria aden - your support helps me a lot 😍
Thanks very much for your effort! and the clear and useful!
Hey MRGRANDE1. Thanks a lot :) Have a great day. Kind regards, Anders
Thank You for the sharing, It is very clear and helpful.
Awesome, you can use the videoes 🤩🙂
Hi Anders
Thank you so much, it is so helpful.
Hey Ali. Awesome you could use it 🙂 Kind regards, Anders
It worked! Thanks good sir!
Hey Zhi! Great and thanks for commenting - that's helping me a lot 😊👍 Kind regards, Anders
thanks a lot Anders.....you are helping me in solving many issues
Thanks a ton for writing, Akhil. That helps me a lot 🙂 Kind regards, Anders
Your videos are helping me a lot.
Thanks a lot - your comments help me a lot 😊👍
i love u !!! Thank u !!!!
Thanks a ton, 墨尼 🤩 Have a great day. Kind regards, Anders
Awesome :)
Thanks 😁
Hello Anders. I have a file to download from Outlook, however, the name is more than 50 characters long. UiPath does not recognize it as an attachment to save it to a folder. When I reduce the filename to 50 characters, UiPath is able to save it to a folder. The file name is coded a special way for another system, and needs to remain its original character length. Can I extend the character limit? Is there another alternative besides truncating the file name? Thank you, in advance. I really enjoy your videos. They are very detailed and informative.
Hey Antoine
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Really helpful video. What if similar attachment files (mails.xlsx) is in a single email?
Hey mpawar88. Thanks a lot. Sure, do you mean two attachments with the same name in the same mail? Kind regard, Anders
@@andersjensenorg yes
Hey Anders, just a quick question. Would I be able to apply this for the Outlook Web App as well or does it only work on the outlook desktop application?
Hey Infernal. Is Outlook Web App = Outlook365? 🙂 Kind regards, Anders
@@andersjensenorg I think its a Web exchange kind of thing. Like the url is: example.com.au/owa/
Hi Anders, how can I change the date format? 5:43 this is my Format "Wed, 19 Jan 2022 08:36:34 +0100" and i want to keep it simple as possible. Thanks for your grate videos and best regards from Munich!
because currently im working with another phrase: "ddd, dd MMM yyyyy hh:mm:ss K"
Hey Stefan Krah
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Hi Anders, thanks for your video i'm a RPA beginner, how can i do to save multiple attachements with the same name without overwrite ? Best regards.
Hey Arnaud. It's covered in the video - we add the date (with miliseconds) to the attachment to make sure, we don't overwrite. Let me know, if that helps? Kind regards, Anders
@@andersjensenorg Thanks for your fast response but the attachements must be in the same folder and in your video we've a folder by attachements but i can't do that because the attachements (an excel sheet) must feed a datatable to be able to pre-fill an email.
@@arnaudpinciroli8034 Hi Arnaud, Have you found the solution? I want to know that as well.
Because it's impossible to have the same exact file name in the same exact folder.
Hi Anders,
If I have to download mail attachment from outlook, if it has attachment.. to a particular location, otherwise I have to download the mail itself if no attachment are present, to another particular location..
And the mail and attachment to be downloaded by bot from outlook mailbox should be less than one day that of current date (system date)...(read and download mail and attachment which has come yesterday not today)
and mail should be saved with the subject+date and time inside the mail...
Can you guide me with one sample video along with link.... It would be very grateful
Hey Anupam K
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
string was not recognized as a valid datetime
Anders, I'm getting this error. How to overcome this
Hey sanjay karthik
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Hi Anders! I dont know what is happening here. My one is showing, the operation has timed out. What should do?
Hey Mohammad Rezwanur Rahman 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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Hi Anders!
Would you tell me how to unzip files? I got an extension but for some reason it disappear next time i use Uipath.
Thank you!
Manuel.
Hey Manuel. You'll need to reinstall the package for each project ☹ I have a video about zip and unzip coming up in around 28 hours. Have a good day. Kind regards, Anders
@@andersjensenorg Oh good, I thought i was doing something wrong, I will check the video. I still have to learn once i do have my flow completed how to use robot and automatize with orchestrator and everything.. oh well, i checked a video in the past but I have to do it again.
Thank you for your help, it seem you are very fluent with RPA.
Regards,
Manuel.
HELP ME!!
after I run I get errors like this
Message: String 'Wed, 21 Dec 2022 20:59:23 +0700' was not recognized as a valid DateTime.
Exception Type: System.FormatException
Hey [027]_Wahyu Hidayat Siregar 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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Hello, First thanks for the Video. I've a question: How to get the Attachements names? I want to open it after the download if it a ".xls Data". Thank you.
Hey Le
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 simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
What are the supported attachment types for Safe attachments in MDO . Kindly help.
Hey Kundan Kumar 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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
My mail datetime comes in this string "Thu, 31 Mar 2022 17:33:06 -0300" and I have 0 idea of how to parseExact this monstruosity.
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 5800+ 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi. I would like to know if you did this case with Ui Path Studio X? If yes, could you send me a link of your work for my reference. Thanks very much. 😁
Hey Ralph. Yes and no. Check this, where Michael shows me StudioX: th-cam.com/video/SWPXDoDyZxo/w-d-xo.html :) I hope that helps? Kind regards, Anders
@@andersjensenorg yeah. It did helped a lot. Thanks
The automation is running fine, but no attachment is saved. What I should do please?
Hey Maria Clara Luz 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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html Have a great day. Kind regards, Anders
Hello sir,
My Robot was perfectly running fine but it start leaving some Activity and also auto pickup new file without showing any error .any solution !!!
I'm not using orcheatrator
Hey Priya, that one is very hard to solve, since no message etc. Can you try the "boring" solution and reinstall? Kind regards, Anders
@@andersjensenorg
Okay.
Database having bulk data as it can be problem because BOT take data from database and bulky data not response on time of BOT timing ?
How to exclude inline attachments and download only which are in attachment section ?
Hey Suchith, can you send such a mail to me at anders@andersjensen.org? Then I can work with it and show you. Kind regards, Anders
@@andersjensenorg I have this same query. How to exclude inline attachments and download only which are in attachment section ?could you help?
can this be done for outlook 2007 ??
Hey Rohit. I'm 90% sure, but I havn't got Outlook 2007. Can you try it? Kind regards, Anders
I have experienced a big problem....The Specific folder does not exist....I dont know how to fix this. Can you help me?
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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
In case your Item.Header returns date time format like this "Tue, 08 Nov 2022 19:34:51 +0800", you can try using >>>> CDate(mail.Headers("Date")).ToString("yyyy.MM.dd")
Hey Alan - thanks a lot for clarifying 😍💪
How uipath control java application？
Hey Excel
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 simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Creating a separate folder for every attachment is a bit silly. I would think almost ANY automated process in a real company wouldn't want the additional bother of having to deal with all those resulting folders. Better to do the (harder) work of timestamping the attachments themselves.
Username checks in 😅 Just kidding. Thanks a lot for the feedback and I tend to agree, but usually you'll just use the folders/attachment for the next automation step. Have a great day and please comment whenever you think I can do better 😊