Sub SendActiveWorkbook()
ActiveWorkbook.SendMail _
", _
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


--
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

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" wrote in message
...

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