SendMail Problem

A

AP

When I use the following Help sample code,

ActiveWorkbook.SendMail "(e-mail address removed)"

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
 
J

Jim Cone

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" <[email protected]>
wrote in message
When I use the following Help sample code,
ActiveWorkbook.SendMail "(e-mail address removed)"
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
 
M

Mike

this works for me
sub outlookexpress
ActiveWorkbook.SendMail _
Recipients:="(e-mail address removed)", _
Subject:="No Subject"
end sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top