Sendmail Macro
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/ |
Sendmail Macro
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/ |
All times are GMT +1. The time now is 02:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com