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

--

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


"CLR" wrote in message ...
Hi All.........
Using xl2k, I made a macro using mostly Ron de Bruin's fine code to send an
email of part of an Excel sheet, (copied over into a helper workbook) in
Lotus Notes.
The macro works fine on my
work computer with Lotus Notes. It also works on my home much smaller
computer using
OE5, but does not work on the user's computer I want to give it to at work,
nor any other
computer around my area. The User's computer is essentially the same
Dell as mine,
only a little faster, and with the same 1GB RAM......the rest of the program
works fine on
his computer, just the sendmail command don't work

I get the error msg of "Run time error 1004 Method 'sendmail' of object
'_Workbook' failed.

I tried both
Application.sendmail EmailAddy, "mytest3 from Mike"
and
Application.Dialogs(xlDialogSendMail).Show EmailAddy, "mytest3 from Mike"

same results with both.........works on mine, don't on his.....

Our computers at work are burdened down with EXTREME controls by the MIS
dept.....some
more than others. Could there be some sort of setting that may be different
on the various
computers that would demonstrate this situation?

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3