ActiveWorkbook.SendMail - Message body

Sub SendActiveWorkbook()
ActiveWorkbook.SendMail _
Recipients:="[email protected]", _
Subject:="Test" & Format(Date, "dd/mmm/yy")
End Sub

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

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Leith Ross" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=504252
>