Results 1 to 14 of 14
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'SendMail' failed (Excel97)

    My Excel97 spreadsheet uses SendMail attached to a macro to mail itself back to an admin office at month end using Outlook Express
    On some PC this works fine but on others I get the error message
    "Method 'SendMail' of object '_workbook' failed" - err.number 1004
    The pc's are mix of Win98/95 but all are running OE6 on Win98 and OE5.5 on Win95. Anyone have an idea why I'm getting the error and what to do about it please

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 'SendMail' failed (Excel97)

    Does it work on the problem PC's if you make sure that Outlook Express is active before executing the Excel macro?
    Are you sure that Outlook Express is the default mail program on those PC's?

  3. #3
    Banned Member
    Join Date
    Jul 2002
    Location
    Newport Richey, Florida, USA
    Posts
    2,149
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    Read This Here

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    Since the OP states that the systems that show the fault have Outlook Expres, I think the article you refer to is not relevant.

    I think Hans is right on the money that OE might NOT be the default mail system for those machines.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Jun 2003
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    I can confirm that Outlook Express is the default mail program - on most of the pc's in the company Outlook is not installed and it doesn't seem to make any difference whether OE is running in the background or not

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    What happens if you choose File, Send to, Mail recipient ?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    New Lounger
    Join Date
    Jun 2003
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    I've just noticed that the send-to option has disappeared from the File menu
    I tried to add a 'mailto' button th the toolbar and it immediately greyed out as if unavailable

  8. #8
    Banned Member
    Join Date
    Jul 2002
    Location
    Newport Richey, Florida, USA
    Posts
    2,149
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    Nothing in this Forum is irrelevant. My time and the fact that I'm tring to help is relevant.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'SendMail' failed (Excel97)

    Cowboy,

    The link you posted if for Office 98. That's the Mac version, so it doesn't apply to the way sendmail works on PCs.
    Charlotte

  10. #10
    Banned Member
    Join Date
    Jul 2002
    Location
    Newport Richey, Florida, USA
    Posts
    2,149
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    Woops. <img src=/S/bash.gif border=0 alt=bash width=35 height=39> My bad. Dang it. Sure sounded good though. Am I fired? <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15> Sorry Pieterse, coffee hadn't kicked in and I'm a little <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15> untill it does.

  11. #11
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    How about if you put an erro trap in the macro so that if the error occured the following would run.


    Workbooks("BOOK1.XLS").HasRoutingSlip = True
    With Workbooks("BOOK1.XLS").RoutingSlip
    .Delivery = xlAllAtOnce
    .Recipients = Array("bob@abc.com", _
    "phil@xyz.com", "me@work.com")
    .Subject = "Here is BOOK1.XLS"
    .Message = "Here is the workbook. What do you think?"
    End With
    Workbooks("BOOK1.XLS").Route

    Good Luck

  12. #12
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: 'SendMail' failed (Excel97)

    In the Immediates window on some of the problem machines, see if:

    ?Application.MailSystem = xlMAPI

    returns True
    -John ... I float in liquid gardens
    UTC -7ąDS

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    No apologies needed, but accepted anyway <img src=/S/smile.gif border=0 alt=smile width=15 height=15>.

    Of course anyone answering here is trying to help. I just wanted to point out your link was not entirely to the point (even though it seems the only one in the KB to address the error message).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  14. #14
    New Lounger
    Join Date
    Jun 2003
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'SendMail' failed (Excel97)

    I think I may have cracked it! Knowledge base article Q190719 - WD97: No Send To Mail Recipient with Outlook Express and Windows 98 seems to answer the problem
    Efectively I have re-installed Windows Messaging on two of the recalcitrant PC's and the SendMail option has returned with full functionality restored to my Excel VBA
    I guess it was never installed on one PC but the other was working, then lost the functionality - the only changes that I can think have occurred is an upgrade to IE6 - maybe that disabled something as part of the Security Upgrade. Thanks anyway to all who replied - nice to know there is someone there when you need help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •