Hi Abel

Your code is not the same as the Example on my site

Sub Mail_workbook_1()
ActiveWorkbook.SendMail ", _
"This is the Subject line"
End Sub



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



"Abel Chan" wrote in message ...
Hi all,

I was trying to send out an excel workbook through Outlook Express.

I looked at http://www.rondebruin.nl/ and have:
Workbooks.Application.ActiveWorkbook.SendMail ", _
"This is a test"
In my code but I got an error 1004 "Method 'SendMail' of object '_Workbook'
failed"

I checked my Internet Option | Program and it has Outlook Express as the
default Email.

Any idea why?

Thanks so much.

Abel Chan