Re : How to copy Excel Sheet and paste in Email Body , using MS Excel VBO and Outlook VBO

[AmanTiwari]

Hello Community,

I am working on a Proof of Concept using Blue Prism, where in one of the step i need to copy excel sheet with specified number of rows and paste it into Outlook Mail Body and send the mail to required end user.

I am not able to perform this step, as there is no direct method for the same.


Please provide me with a solution for the same.

Thanks ,

Aman Tiwari

------------------------------
Aman Tiwari
------------------------------

[expertcr]

Good morning.

When passing data from other applications, the message is converted to HTML.

I try this and work fine for me: copy what to paste in a new Excel File and saved as HTML.

Then just copy that HTML into the message body in the Outlook VBO.

STEP 1:

STEP 2

STEP 3

STEP 4: in the action use the date item for the message.

Email Send and I revive this:

------------------------------
Luis Lopez
Customer Support Engineer English and Spanish
Blue Prism Ltd
------------------------------

[OlavoNeto]

Hi, Luiz.

I did the same process that you did, but not work to me.
Do you now what i did wrong?






------------------------------
Olavo Neto
------------------------------