I added the sendmail macro to a worksheet that I distributed to 14 sites
that I support. They all have the save PC and software package
(Windows 95/Office 97) 13 of them work and 1 does not. One gives me
the following message:

Runtime error 1004. Method of 'SendMail' of object_workbook failed

I have tried saving it as a different version of excel and rechecked
all of the formulas to no avail. Any suggestions



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Try this

http://www.rondebruin.nl/sendmail.htm#Problems

See this part
XL2002: "Send To Routing Recipient" Command Does Nothinghttp://support.microsoft.com/default.aspx?scid=kb;en-us;296396
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Tagliaboo" wrote in message ...
I added the sendmail macro to a worksheet that I distributed to 14 sites
that I support. They all have the save PC and software package
(Windows 95/Office 97) 13 of them work and 1 does not. One gives me
the following message:

Runtime error 1004. Method of 'SendMail' of object_workbook failed

I have tried saving it as a different version of excel and rechecked
all of the formulas to no avail. Any suggestions



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/