UiPath Basics #9 - Email Automation

This video tutorial shows, how to automate emails with UiPath. In an example aimed towards Beginners, it is shown how to get data out of Outlook emails and save them into applications or Excel. Finally it is show, how to send emails in Outlook.
📚Best book about the coding language (VB.NET) in UiPath [Affiliate]
geni.us/v6ffI
🤖UiPath Tutorial: The Basics For Beginners
• UiPath Tutorial: The B...
🔔Subscribe if you enjoyed
kzbin.info...
#uipath #rpa #automation

[@rekindlethewick583]

Thanks Anders - what I really find helpful in your videos is seeing activities that I did not know existed in UI. Very cool stuff. I usually watch the videos 2 or 3 times pick up things I missed the first time. Thanks again!

[@andersjensenorg]

Hey rekindlethewick. Wow, that is very kind of you 😊 Is there anything, you think, I can improve? Maybe just small areas. Kind regards, Anders

[@manuelcaballero5827]

Thank you Anders, this one was included in the other course, but i watched again. Looking forward for more videos and intermediate level as well. Thank you again!! Manuel.

[@andersjensenorg]

Thank you, Manuel. This one was the last that is included in the entire Beginners Course. The next ones will be new 😊 Again thank you for all your positive comments and feedback - it is very valuable. Kind regards, Anders

[@zevex95]

Hi Anders. Thanks for the nice explanatory videos. I'm new to RPA but I learn a lot from watching your videos. Keep up the good work :)

[@andersjensenorg]

Thanks a lot, Ismail Z 🤗 Your feedback helps me immensely. Kind regards, Anders

[@Eichman86]

Thank you so much for your amazing Tutorials

[@andersjensenorg]

Hey Medhat. Thank you for your nice words 😊 Kind regards, Anders

[@MrAnupam200]

Hi Anders, Thanks a lot.... You are genius... I used to eagerly wait for your videos... Your video are learning model for me... Thanks a lot... keep up the good work

[@andersjensenorg]

Hey Anupam. You are too kind, thank you very much 😊 If you have any questions or topics that you want to see, please let me know. Kind regards, Anders

[@mahamidhussaini4328]

Hi Andres, This tutorial is very nice. I am commenting this by automation. Thanks once again

[@andersjensenorg]

Haha love it, when the bot is commenting 😀 This was manual by me, have a great 2023, Mahamid!

[@levibundi9931]

I was trying the RPA challenge and needed this because for the challenge Outlook is used at the moment but can attempt this on gmail.

[@andersjensenorg]

Hey Levi, thanks for everything you do - all the support is highly appreciated, and something that helps my little company grow 🦾🦾♥️

[@kreigfields3157]

Hi Anders, as always, great stuff! Is it possible to use UiPath to access email when there isn't a local copy of Microsoft Mail? We are using the online version of Microsoft Outlook.

[@andersjensenorg]

Hey Kreig. Thank you 😊 Is it O365? Can you use Exchange? Else create a UI Solution (I know 🤷🏻‍♂️). Kind regards, Anders

[@jamietan8002]

Thanks for your video. It is very helpful but how to search emails based on specific sender email address? And probably save them into specific folder.

[@andersjensenorg]

Hey Jamie Tan 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

[@dipanshukumar5678]

Thanks you Adars. I have one question. I have one one folder in outlook where I'm getting so many email everyday with attachment and without attachment. if the email having attachment i need to fetch that attachment and paste it into onedrive. If the email doesn't have attachment i need to move that email in to rejected folder Can u please guide me regarding this? By using Power Automate

[@andrewandrew9928]

you should use Outlook email rules to move the emails. No need to automate this function. Go to Manage Rules and Alerts in Outlook and one of the rules is "Has Attachment"

[@andersjensenorg]

Hey Dipanshu. We can either do, what Andrew suggests. That have the benefit of being very easy without use of another application. Downside is, that if we chose to scale our automation, we need to set it up on each server/computer/vm, where if we chose to do it in the automation itself, we will not run into that problem. And big thank you, Andrew Andrew for your solution 😊 Kind regards, Anders

[@NT-it3gr]

Hi Anders, how do you add a signature logo to the outlook uipath "send outlook mail message" ? I had this in the body: "Hi " + CurrentRow.ByField("Name") +vbnewline +"Hello"+ [ Signature company Logo ] . Are you able to advise any top 3 UIpath books you recommend? Thank you.

[@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 6000+ 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

[@NT-it3gr]

Thanks for responding Andres. I managed to solve it. Will lookout for your community. In case someone is looking for ans. 1) ensure that sendoutlook mail properties is bodyhtml checked. 2) in body "" 3) attached the logo image to email.

[@NT-it3gr]

*Anders

[@kaijisan1206]

Hi Jensen, how to create an email folder with Uipath for a mail box in the web ? Is it possible ? I tried to use the move mail message to a non existing folder hoping it will create it, but that did not work.

[@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 4900+ 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

[@rsltlocke2759]

Hi I just found your videos. I have emails that contain PDF attachments. What is the best way to open the PDF document, scan for specific words ? Thanks so much A video would be very helpful to build on what you can do with email attachments.

[@andersjensenorg]

Hey RSLT. Regex, definately Regex. Check this video out: kzbin.info/www/bejne/q3THc3Zopb2Dr7s I know it's invoices, but the intuition is the same. Let me know, if you need help after that. Regarding the attachments, check this: kzbin.info/www/bejne/e4q9oYBmnJtqgKc I have also made one regarding sending them. Please let me know, what you think 😊 Kind regards, Anders

[@rsltlocke2759]

@@andersjensenorg The PDF documents are varied in length and content - as a beginner, does Regex not require a specific pattern of text to recognize it ? Thanks

[@julieluo4837]

Thanks Anders, but I hit with error “Get Outlook Mail Messages : The Specified folder does not exist” .. I am working with outlook app installed on my Laptop though

[@andersjensenorg]

Hey Julio. Are you sure you use the correct folder name, e.g. mine is named Indbakke (Danish) and not the default Inbox? Kind regards, Anders

[@julieluo4837]

@@andersjensenorg do u mind to share how to find the exact folder name? Coz I only know it stated as Inbox

[@kazuu5028]

how about the attachment? how do i send attachment? and btw thanks a lot you really helping me out with uipath

[@andersjensenorg]

Hey Kazuu 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

[@shubhamgarg5621]

how can we make the text of notepad bold which will show in email

[@andersjensenorg]

Hey Shubham Garg 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

[@oscarmiranda1791]

One question, I do the same process but it gives me an error "the specific folder does not exist" I already checked and the name is correct I hope you can help me I've been with that error for days

[@andersjensenorg]

Hey oscar miranda 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

[@kristiannemagro466]

Hi, I have tried this and it was working fine. Now I'm getting this error: --------------------------------------------------------- Source: Send Outlook Mail Message Message: The operation failed. Exception Type: System.SystemException RemoteException wrapping System.SystemException: The operation failed. ---> RemoteException wrapping System.Runtime.InteropServices.COMException: The operation failed. at Microsoft.Office.Interop.Outlook._MailItem.get_GetInspector() at UiPath.Mail.OutlookAPI.InitOutlook() --- End of inner exception stack trace --- at UiPath.Mail.Activities.SendMailActivity.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)

[@andersjensenorg]

Hey Kristianne Magro 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

[@hwyshshsheuwi]

How do I get the Get outlook mail message ?

[@andersjensenorg]

Hey Kevin Rodriguez 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

[@olgasukhova777]

Can you please include a translation for all of your videos for subtitles?🙏

[@andersjensenorg]

Hey Olga. There is an English subtitle included in it? Kind regards, Anders

[@olgasukhova777]

@@andersjensenorg Hello Anders 😉 Yes, I found everything yesterday, thank you again. I still did in Russian and German, also with reading options 😃 Now, I can work with you and also hear in Russian or German 😊 My English has gotten worse because I only speak German at the moment.

[@sarumathip.7312]

I have office 365 share any video to send mail in microsoft office 365

[@andersjensenorg]

Hey sarumathi p. 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

[@deepakraul9750]

ok but how to connect email with ui path you not explain that part

[@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