When I use the following Help sample code,

ActiveWorkbook.SendMail "

I get this error:

Run-time error '1004':
Method 'SendMail' of object '_Workbook' failed

(The email address is a workable one and not the one shown above)

I'm using Excel 2003 and Outlook Express 6.

Appreciate your help very much.

AP

Outlook Express doesn't appear to be as flexible as Outlook.
Take a look at this...
http://www.j-walk.com/ss/excel/tips/tip86.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins: sort, compare, print, thesaurus, permutations,...)


"AP"
wrote in message
When I use the following Help sample code,
ActiveWorkbook.SendMail "
I get this error:
Run-time error '1004':
Method 'SendMail' of object '_Workbook' failed
(The email address is a workable one and not the one shown above)
I'm using Excel 2003 and Outlook Express 6.
Appreciate your help very much.
AP

See this page
http://www.rondebruin.nl/mail/problems.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"AP" wrote in message ...
When I use the following Help sample code,

ActiveWorkbook.SendMail "

I get this error:

Run-time error '1004':
Method 'SendMail' of object '_Workbook' failed

(The email address is a workable one and not the one shown above)

I'm using Excel 2003 and Outlook Express 6.

Appreciate your help very much.

AP

this works for me
sub outlookexpress
ActiveWorkbook.SendMail _
", _
Subject:="No Subject"
end sub
"AP" wrote:

When I use the following Help sample code,

ActiveWorkbook.SendMail "

I get this error:

Run-time error '1004':
Method 'SendMail' of object '_Workbook' failed

(The email address is a workable one and not the one shown above)

I'm using Excel 2003 and Outlook Express 6.

Appreciate your help very much.

AP