Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Location
    Kitchener, Ontario, Canada
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    send object macro (2000)

    I have a number of reports that I distribute through outlook using a "send object" macro. I've added the macro to the database switchboard. I can successfully send this email from the switchboard using my computer--where the database was created. The macro will not work when the database is accessed from other computers. The database resides on a server. I'm thinking that the macro picked up my email account and won't work with other accounts.
    Does anyone have any ideas as to who I can make this functional from other computers?

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

    Re: send object macro (2000)

    SendObject should work on all PCs that have an e-mail application installed; it should use the default mail application, and use the account of whoever is using the database at the time.

    Does the macro generate an error message when it's run on another computer? If so, what does it say?

  3. #3
    Star Lounger
    Join Date
    Mar 2006
    Location
    Kitchener, Ontario, Canada
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: send object macro (2000)

    The message is

    THERE WAS AN ERROR EXECUTING THE COMMAND

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

    Re: send object macro (2000)

    Thanks. That is the error message if you click the button on the switchboard form. Could you try running the macro directly from the database window on one of the problem computers? You'll probably get a different error message.

  5. #5
    Star Lounger
    Join Date
    Mar 2006
    Location
    Kitchener, Ontario, Canada
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: send object macro (2000)

    Thanks Hans
    It looks like Access has not been fully installed on the other machines.

    Thanks again for all your 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
  •