Compose a mail (outlook) from Excel Data

[Raj.xls]

Hello Everyone,

i want VBA code for Compose a Mail In Outlook from Excel Data.

To:
CC:
Subject:
Title: Same Format what i Have in Excel Format Range (B5:N28)

Excel Version : 2010
Outlook Version : 2010

Request to help

[:) Sixthsense :)]

Just included Rondebruin VBA code in your file.

[Raj.xls]

Thank for reply

In Body of the mail received. But
Header is not coming in outlook..
can you revert

[davesexcel]

Check it out
https://www.rondebruin.nl/win/s1/outlook/bmail3.htm

Edit, woops, never saw a reply before I replied.

[:) Sixthsense :)]

But Header is not coming in outlook..

B'cos header is a shape. RangeToHtml only takes cell values.

Shape/Picture stays above the cell and it's not cell value.

Just confirm whether shall we paste whole range as picture in outlook body (Total Data As Picture)?

[Raj.xls]

Hi Sixthsense ,

Yes, i Want total date As Picture in Outlook body.
Can be able to do

[davesexcel]

Maybe use this, still from Ron DeBruin site. I use it all the time.

https://www.rondebruin.nl/win/s1/outlook/bmail3.htm

Please Login or Register  to view this content.

[Raj.xls]

Thank you So Much... to Everyone to Comments.

Its Working ...