topic MS Outlook VBO with v6.2 in Product Forum

MS Outlook VBO with v6.2

NikhilSathe — Wed, 30 Oct 2019 06:08:00 GMT

Hi
I have BP v6.2 and want to try MS Outlook VBO. (is it possible?)
I downloaded it from DX and imported it into my process. It shows all the actions possible.
I tried executing "Send Email" but it gives error "Internal : Could not run the object because one of the code stages has a compile error, use Check for Errors for a list of problems".
I tried googling it and it indicates some settings regarding Microsoft.Office.Interop.Outlook.dll, but do not know how to solve it.
Any ideas?

------------------------------
Nikhil Sathe
Sr Consultant
Capgemini Technology Services
------------------------------

RE: MS Outlook VBO with v6.2

MaheshKushare — Wed, 30 Oct 2019 14:02:00 GMT

Hi Nikhil,

1. Please save the "Microsoft.Office.Interop.Outlook.dll" in Blue Prism directory ex. C:\Program Files\Blue Prism Limited\Blue Prism Automate\
2. provide the path in VBO for the DLL in code options (Extrenal Ref). ex. C:\Program Files\Blue Prism Limited\Blue Prism Automate\Microsoft.Office.Interop.Outlook.dll
3. In code options add Namespce as "Microsoft.Office.Interop.Outlook".

Hope this will help you!

------------------------------
Mahesh Kushare
Sr. Consultant
Capgemini
Asia/Kolkata
------------------------------

RE: MS Outlook VBO with v6.2

NikhilSathe — Thu, 31 Oct 2019 05:34:00 GMT

It worked!! Thanks Mahesh!

Now the next question 🙂 there are other DLLs present there, to I have to perform similar activity in order to have the fully functional VBO?

DLL -> Namespace
----- ----------------------
System.Data.dll -> System
System.Xml.dll -> Microsoft.VisualBasic
System.Drawing.dll -> System.Drawing
?? -> Microsoft.Win32

By performing above settings will I be able to draw tables/insert screenshots in email?
Thanks in advance

------------------------------
Nikhil Sathe
Sr Consultant
Capgemini Technology Services
------------------------------

RE: MS Outlook VBO with v6.2

MaheshKushare — Thu, 31 Oct 2019 15:40:00 GMT

Yes Nikhil, You can.

create a message body with HTML. it will insert ->

try sample below (refer attachment) ->

<html>
<body>
<table border="1" >
<tr bgcolor="Yellow">
<th>NAME
</th>
<th>ADDRESS
</th>
<th>PHONE
</th>
<th>STATE
</th>
<th>COUNTRY
</th>
<th>EMAIL ID
</th>
</tr>
<tr bgcolor="#fcf9f8">
<td>MAHESH KUSHARE
</td>
<td>TORONTO
</td>
<td>+12269886490
</td>
<td>ONTARIO
</td>
<td>CANADA
</td>
<td>MAHESH.KUSHARE@CAPGEMINI.COM
</td>
</tr>
</table>
<p><img width=500 height=300 id='1' src='C:\Users\1234\Pictures\bp-logo.PNG'></p>
</body>
</html>

------------------------------
Mahesh Kushare
Sr. Consultant
Capgemini Solutions Canada Inc
Toronto
2269886490
------------------------------

RE: MS Outlook VBO with v6.2

NikhilSathe — Fri, 01 Nov 2019 08:11:00 GMT

Got it! Thanks!

------------------------------
Nikhil Sathe
Sr Consultant
Capgemini Technology Services
------------------------------