topic RE: MS Outlook Email VBO --> Works fine locally, error on VM. in Product Forum

MS Outlook Email VBO --> Works fine locally, error on VM.

EllenPeereboom — Wed, 29 Jan 2020 16:38:00 GMT

Hi,

I am currently running into some problems with MS Outlook Email VBO - Get Sent Items (Basic). I usually work with Mapiex, but I have not found an option for Mapiex to save an email as .msg file. Instead, I used Get Sent Items (Basic) to save the details of the email in a Data Collection, followed by a Save Email stage that uses the entry_ID of the email to save it.

Here is the flow that works fine locally:

On the VM, this error occurs in the first stage (Get Sent Items):

Any ideas how I could make this work? As mentioned above, the main goal is to save a sent email as .msg file.

Thanks in advance!

Ellen

RE: MS Outlook Email VBO --> Works fine locally, error on VM.

AmiBarrett — Wed, 29 Jan 2020 20:20:00 GMT

It looks like there's an issue with one of the code stages in the object. Is the VM connected to the same environment as your local system? You may need to open the object from the VM and see where the problem is.

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Richardson, TX
------------------------------

RE: MS Outlook Email VBO --> Works fine locally, error on VM.

vivek.kumar.goel — Thu, 30 Jan 2020 03:22:00 GMT

Hi Ellen,

Did you check if you have all the required DLLs present on the VM?

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
"If you like this post, please press the "Recommend" Button.
------------------------------

RE: MS Outlook Email VBO --> Works fine locally, error on VM.

AmiBarrett — Thu, 30 Jan 2020 06:02:00 GMT

@vivek.kumar.goel has a really good point on the DLLs.

You may also be able to modify the dll reference if you don't want to copy files over. I changed mine to: C:\windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Outlook\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Outlook.dll . This path may vary based on what version of Outlook is installed, but I've gotten it to work without issue on 2013, 2016 and O365.

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

RE: MS Outlook Email VBO --> Works fine locally, error on VM.

Nannevan_der_Wa — Wed, 12 Feb 2020 10:33:00 GMT

Hey Ami,

Yes it is connected to the same BP server, so version is identical locally and on VM. We are still lost on this matter. DLL's should also be in place as we are using version 6.5 where this object was included as a standard. The strange thing is that it works perfectly locally but just not on the VM, whereas outlook versions are also the same (outlook 2016).

DLL also seems to be in place. I am not sure what you are referring to when yous peak about "modify the dll reference if you don't want to copy files over". I am unsure if this is necessary in our case.

Hope you have some more ideas/suggestions on this matter.

Best,
Nanne

------------------------------
Nanne van der Wal
Advisor
EY
Europe/Amsterdam
------------------------------

RE: MS Outlook Email VBO --> Works fine locally, error on VM.

AmiBarrett — Wed, 12 Feb 2020 15:02:00 GMT

The OOB version of this VBO assumes that DLL file resides within the same directory as Automate.exe (IE: C:\Program Files\Blue Prism Limited\Blue Prism Automate ). The path you've pulled up is where Windows keeps its reference, and is what I modified my separate build of that mail handler to point to for sake of consistency (mainly because I built it against BP 5.4, before this VBO was available).

I think you're right that it was standard by the time 6.5 got shipped out. I remember some early instructions from BP requiring that you take some additional steps to get the DLL in there. If you're able to validate that it is in there, can you run a validation on the VBO and see what it says?

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------

RE: MS Outlook Email VBO --> Works fine locally, error on VM.

Nannevan_der_Wa — Thu, 13 Feb 2020 10:12:00 GMT

Thanks Ami. After double checking the outlook specific DLL was indeed missing on the VM whereas we had it locally. Adding the DLL in the same directory instantly resolved the issue.

Thanks once again and congrats on the career switch I believe ?!

All the best.

------------------------------
Nanne van der Wal
Advisor
EY
Europe/Amsterdam
------------------------------

RE: MS Outlook Email VBO --> Works fine locally, error on VM.

AmiBarrett — Thu, 13 Feb 2020 14:27:00 GMT

Glad to help!

Thanks!

------------------------------
Ami Barrett
Sr Product Consultant
Blue Prism
Plano, TX
------------------------------