Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
in RPA by (12.7k points)

So I want to copy a few rows and column from an Excel file and mail that copied content using Outlook. The important thing is that my Excel contains color and different fonts and I want the same theme/design in my mail. New to BluePrism, any suggestion is highly appreciated.

1 Answer

0 votes
by (29.5k points)
edited by

There are various ways in which this task can be done, the simplest one that I can think of would be using the Copy function from MS Excel VBO and then do a Paste Special on the Outlook Message.
Then select whichever format you prefer.

  • HTML format will be smallest, but may not 100% capture the Excel look
  • Bitmap will be largest, but will 100% capture the Excel look
  • Picture should be like the bitmap barring some minor differences

Make sure you have the mail body activated when you are doing the paste, so you are not attempting to paste the contents into the address list.

Related questions

0 votes
1 answer
asked Jul 29, 2019 in RPA by noah kapoor (5.3k points)
0 votes
1 answer

Browse Categories