topic RE: The MAPIEx dll created by… in Product Forum

Blue Prism hangs when calling "List Mails Within DateTimes" of BluePrism - MapiEx

SaakarBairagi — Mon, 10 Dec 2018 18:04:00 GMT

Blue Prism hangs when calling "List Mails Within DateTimes" action of BluePrism - MapiEx. It gets stuck there doesn't move further. Let me know what is the issue here?

I also faced the similar…

SachinUpadhyay — Fri, 22 Feb 2019 13:45:00 GMT

I also faced the similar issue while using ""Get Mail"" action.With Outlook 2016,it hangs very frequently.I am still looking for solution.

The MAPIEx dll created by…

AmiBarrett — Fri, 22 Feb 2019 20:44:00 GMT

The MAPIEx dll created by Blue Prism is incredibly unstable. You're better off grabbing a copy of the Outlook VBO either from a BP6 install or off the Digital Exchange. It'll support this.

RE: The MAPIEx dll created by…

praveencga — Thu, 13 Feb 2020 10:53:00 GMT

Does Outlook VBO supports Get Mail with HTML?

------------------------------
Praveen Chinthaginjala
Senior Technical Architect
HCL Technologies
Europe/Amsterdam
------------------------------

RE: The MAPIEx dll created by…

david.l.morris — Thu, 13 Feb 2020 13:09:00 GMT

As far as I know, it doesn't support Get Mail with HTML out of the box. Maybe there's a parameter somewhere I haven't noticed, but I've only seen it retrieve plain text. What are you hoping to achieve with that functionality?

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: The MAPIEx dll created by…

praveencga — Thu, 13 Feb 2020 13:29:00 GMT

Our Mail body contains HTML tables . So it is more efficient and easy to get the content in HTML to store it into Blue Prism Collections.

------------------------------
Praveen Chinthaginjala
Senior Technical Architect
HCL Technologies
Europe/Amsterdam
------------------------------

RE: The MAPIEx dll created by…

david.l.morris — Thu, 13 Feb 2020 13:47:00 GMT

All right, you got me interested so I had to go look at the code lol.

It looks like it's pretty easy to add retrieving the HTMLBody from the Mail Item.

Take a look in the object 'MS Outlook Email VBO' then in the page 'Internal_Get Items' and then in the code stage 'Get Items'. You can edit this code stage to output the HTMLBody. I suspect someone else has already created an edited version of this to output the HTMLBody. I'll facepalm if that's the case. Anyway, you only need to make 2 changes in the code stage:

First code stage change. Find the line in the code that is exactly like this:
dataTable.Columns.Add("Body", Type.GetType("System.String"))
and then add a line below it like this:
dataTable.Columns.Add("HTMLBody", Type.GetType("System.String"))

Second code stage change. Find the line in the code that is exactly like this:
row("Body") = item.Body
and then add a line below it like this:
row("HTMLBody") = item.HTMLBody

Third change but outside the code stage:
Open the Collection 'Items' in the page 'Internal_Get Items' and add a field called 'HTMLBody' with a datatype of Text.

I tested it briefly and it works for me. Let me know how it goes. And thanks for bringing this up! I didn't expect it to be so easy.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: The MAPIEx dll created by…

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

There is a modified version of the VBO that supports outputting to HTML out of the box. However, it pulls one or the other, rather than both at the same time.

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

RE: The MAPIEx dll created by…

david.l.morris — Thu, 13 Feb 2020 14:50:00 GMT

Thanks! I've imported that into our eval environment. I glanced at it, and I recognize the sharedEmail input I stole...err....borrowed from you a while back.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: The MAPIEx dll created by…

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

Haha, that's what it's there for!

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

RE: The MAPIEx dll created by…

praveencga — Thu, 13 Feb 2020 15:02:00 GMT

Thanks Dave
It worked

------------------------------
Praveen Chinthaginjala
Senior Technical Architect
HCL Technologies
Europe/Amsterdam
------------------------------