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

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

AmanTiwari — Mon, 18 May 2020 09:35:00 GMT

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
------------------------------

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

expertcr — Mon, 01 Jun 2020 16:15:00 GMT

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
------------------------------

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

OlavoNeto — Tue, 23 Mar 2021 15:28:00 GMT

Hi, Luiz.

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

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