Try this from Ron de Bruin posted in 2003

", ")

send mail doesn't support entering text. You can use Automation to do
this.
See the following sites for detailed information:

Ron de Bruin
http://www.rondebruin.nl/sendmail.htm
http://msdn.microsoft.com/library/en...tml/odc_xlmail...

Dick Kuselika
www.dicks-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm

--
Regards,
Tom Ogilvy