Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sendmail vs different computers
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendmail | Excel Discussion (Misc queries) | |||
SendMail Add-in | Excel Programming | |||
SendMail | Excel Programming | |||
Sendmail | Excel Programming | |||
SendMail and BCC | Excel Programming |