ActiveWorkbook.SendMail - Message body

[al007]

Sub SendActiveWorkbook()
ActiveWorkbook.SendMail _
Recipients:="(e-mail address removed)", _
Subject:="Test" & Format(Date, "dd/mmm/yy")
End Sub

How can I add a message body to the above mail??

 

[Leith Ross]

Hello Al007,

The SendMail method has no option for "Body" because the Workbook is
considered to be the body of the email. To have a body to the email you
would need to send the workbook as an attached file through another
program like Outlook.

Sincerely,
Leith Ross

 

[Ron de Bruin]

Like Leith told you this is not possible with SendMail
But if you onlu use Outlook Express and not Outlook look at CDO
http://www.rondebruin.nl/cdo.htm