topic Re: issue with receiving mail with microsoft outlook vbo and email-pop3/smtp vbo in University Forum

issue with receiving mail with microsoft outlook vbo and email-pop3/smtp vbo

blazino17 — Thu, 28 Nov 2024 14:51:06 GMT

I am trying to read emails using the Get Received Items (Basic) action in the Microsoft Outlook VBO and also the Email - POP3/SMTP VBO, but I am encountering errors while running the process. Below are the details of the exceptions I received, as shown in the attached screenshots.

I do not have access to Outlook for Desktop; I only use Outlook for Web. Does this have any limitations when using the Outlook VBO?

Notably, I was able to successfully send a message using the Email - POP3/SMTP VBO, but I am unsure how to resolve the errors when trying to retrieve the body of an email . Kindly guide me on how to resolve these issues effectively.

The first snapshot is for the email-pop3/smtp while the last two snapshots is for the microsoft outlook vbo

Thank you!

Re: issue with receiving mail with microsoft outlook vbo and email-pop3/smtp vbo

harish.mogulluri — Fri, 29 Nov 2024 02:24:12 GMT

Hi @blazino17

The MS Outlook VBO in Blue Prism relies on the Microsoft.Office.Interop.Outlook.dll to interact with Microsoft Outlook. This DLL is typically installed alongside Microsoft Outlook. If the DLL is missing or not accessible, you will encounter a compile error within the Outlook VBO.

The error you are seeing in the MS Outlook VBO is most likely due to missing DLL. \

Since you already Sending email using POP3/SMTP VBO you can use for receiving email as well but it required POP3 Configuration information as required in the VBO.
Here is the VBO and it looks like it has Example process as well.
https://digitalexchange.blueprism.com/dx/entry/3439/solution/email---pop3smtp

Thanks,
Harish

Re: issue with receiving mail with microsoft outlook vbo and email-pop3/smtp vbo

blazino17 — Fri, 29 Nov 2024 13:12:18 GMT

I already have the Email VBO installed and that is what i used for sending the mail as shown above. I am currently using Outlook Web Access (OWA) without desktop access, can i directly configure POP3 in Blue Prism? I also looked up the example bprelease file and i did exactly what they did but still getting that same exception also

working with the Microsoft Email VBO,i also checked the C:\Program Files\Blue Prism Limited\Blue Prism Automate but i cant find the "Microsoft.Office.Interop.Outlook.dll" How do i install the dll?

Re: issue with receiving mail with microsoft outlook vbo and email-pop3/smtp vbo

harish.mogulluri — Fri, 29 Nov 2024 13:23:59 GMT

Hi @blazino17 -

Microsoft.Office.Interop.Outlook.dll is part of your office installation, If you are planning to use Outlook you probably need the mentioned DLL.

It is typically located either in program files or Program files (X86) in C drive or APP data

C:\Users\<YourUserName>\AppData\Local\Microsoft\Office

C:\Program Files\Microsoft Office

If you prefer to use DLL check below website to install the DLL

https://www.nuget.org/packages/Microsoft.Office.Interop.Outlook

Regarding Pop3: Yes you can use the POP3 if you have config related info like server name, port and any additional info.

I belive for sending an email you are using SMTP and config related to SMTP server for reciving you might need to use POP3 related info.

Thanks,

Harish

Re: issue with receiving mail with microsoft outlook vbo and email-pop3/smtp vbo

blazino17 — Fri, 29 Nov 2024 16:01:04 GMT

Thank you, Harish. I successfully downloaded and added the DLL to "C:\Program Files\Blue Prism Limited\Blue Prism Automate", resolving the earlier compile error. However, since I only have access to Outlook Web due to licensing restrictions and not the desktop version, the action still fails to complete successfully. How can this process be accomplished using Outlook Web without depending on the desktop application?

Also i configured the email -pop/smtp as required but i am still having errors. kindly find attached all snapshots

Re: issue with receiving mail with microsoft outlook vbo and email-pop3/smtp vbo

harish.mogulluri — Fri, 29 Nov 2024 16:23:51 GMT

Hi @blazino17

As mentioned above adding DLL will resolve the compile error in the object but if you are planning to use you need to install MIcrosoft Outlook

If you dont want to install you can use Graph API as well. Below I have added the asset from digital exchange.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-office-365---outlook