View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryanmhess ryanmhess is offline
external usenet poster
 
Posts: 22
Default Convert to HTML and e-mail selection as the body of the e-mail.

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 as the body of the e-mail and not as an excel
attachment.

Any Help would be greatly appreciated.

I was using ActiveWorkbook.SendMail "

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!