Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SendObject won't send (2000)

    I'm trying to run the Docmd.Sendobject command in my vba code as follows:
    DoCmd.SendObject acSendReport, "Patients Report", acFormatRTF, "xxx@yyy.com"
    The email opens up just fine in Outlook, but I can't click on the Send button. That is, I try, but it just doesn't do a thing! How do I send this email?

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

    Re: SendObject won't send (2000)

    That seems more of a problem with Outlook than with Access.
    1. Are you sure the To: address is valid?
    2. What happens if you close & save the e-mail message, then reopen it? Can you send it then?

  3. #3
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject won't send (2000)

    I think you're right, Hans. I think it's an Outlook problem, because I tried running a very simple SendObject macro in the sample northwind database that shipped with Access, and I have the same problem. I'm sure that the To: address is valid, and I can't try your second suggestion until I get home. However, I know that I can send other emails through Outlook. I will try testing this functionality on another PC and will let you know if it works.
    Thanks for your help.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SendObject won't send (2000)

    TJ

    Just an idea that has happened to me sometimes. Have you checked the References in the Visual Basic Editor ( Tools-->References) Sometimes they go a bit amiss. Are any MISSING?

    Jerry
    Jerry

  5. #5
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject won't send (2000)

    I don't think any are missing. I don't know which references would be relevant to this functionality besides for the basic ones. Perhaps this involves a reference to the Outlook library? Even if yes, if it was broken, I would imagine the mail message wouldn't even open up. I'll check the references, but I don't think they are the problem, here.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SendObject won't send (2000)

    Hi TJ

    Just a shot in the dark. I would go with Hans idea as you have already discussed with him

    Jerry
    Jerry

Posting Permissions

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