Convert to HTML and e-mail selection as the body of the e-mail.

[ryanmhess]

Looking to make a macro that does basically what the subject title says.

I want to Range("A1:E19").Select and convert that selection to HTML and have
it e-mailed to (e-mail address removed) as the body of the e-mail and not as an excel
attachment.

Any Help would be greatly appreciated.

I was using ActiveWorkbook.SendMail Recipients:="(e-mail address removed)"

But like I said, that just e-mails the excel file as an attachment and I am
looking to convert to HTML and e-mail that as the body.

Thanks again!

 

[Ron de Bruin]

hi ryanmhess

See
http://www.rondebruin.nl/mail/folder3/mail4.htm

 

[ryanmhess]

I'm not too VB savy. A little unsure on how to go about and what you mean by
"Don't forget to copy the function RangetoHTML in the module."

 

[Ron de Bruin]

Hi ryanmhess

Copy the macro and the function that you see on the page in a standard module
Look here : http://www.rondebruin.nl/code.htm

Download the Body example workbook from my site to test the code if you use Outlook.
http://www.rondebruin.nl/sendmail.htm

You can also use the add-in from my site

 

[ryanmhess]

Thank you very much Ron. It's working great now!

 

[amit]

Hi Ron - I've used your range to outlook code extensively in the past and it
works great thx a lot for that....i've got a slight issue with this
though....the code u have on your website converts the range to html....is
there an easy modification to the code to covert the code to enhanced image
(picture) instead of html...this would be immensly useful becos i want to
capture the currec formating available in excel 2007 (like red lights etc)...

any help would be much appreciated.

thx
Amit