SendMail Problem
 

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

SendMail Problem
 

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

SendMail Problem
 

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

SendMail Problem
 

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