Hi Friends,

I wonder if anyone can give me some instruction on how to send through Excel an email with an HTML file as message body.
I tried something out but does'nt recognize the html but placed it in the body message as text.

I know how to send email and even how to send it with a spreadsheet as message body, but an HTML message body would give me much more flexibility.

Thanks a lot,
Elad.

Not sure how you are sending eMail, however I'd suggest instantiating an Outlook object and sending the mail in Outlook natively.

First, Add the resource "Microsoft Outlook 11.0 Object Library" (Or whatever Outlook object library you have). The code will be:
-------------------------------------------------------------------
Dim MailObj as Outlook.MailItem
MailObj = Outlook.Application.CreateItem(olMailItem)
With MailObj
  .To = "[email protected]"
  .CC = "[email protected]"
  .Subject = "The Subject (HTML Format)"
  .BodyFormat = olFormatHTML
  .HTMLBody = "HTML Content"
  .Display 'Can be .Send but prompts for user intervention before sending without 3rd party software like ClickYes
End With
-------------------------------------------------------------------