Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Location
    Bismarck, North Dakota, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SendObject Action in Macro (2003)

    I have a macro that runs a report that gets its information from a pass through query. It also prompts for a parameter to query on. After that is run the SendObject Action is run to send the report as a snapshot. Edit Message is set to YES so the user can preview the list of addresses before sending. This fails miserably with the macro halting and giving a message of "Microsoft Office Access can't send this e-mail message".

    If I set the Edit Message to No, it runs fine. I also created a report with just a label in it. If I open and send that report before running the macro, everything works great until I close and re-open Access. Anyone have an idea that I can try short of rebuilding the whole thing? I have tried importing all of the information into a new database, but it still fails.

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

    Re: SendObject Action in Macro (2003)

    Without seeing the database it is impossible for us to know what causes the problem. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  3. #3
    New Lounger
    Join Date
    Nov 2005
    Location
    Bismarck, North Dakota, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SendObject Action in Macro (2003)

    As I was removing all the extras from the database, I also ended up removing the Pass through query. The emails started to magically work. I then added the query back in, but did not link it to anything that was needed to created the reports and email, and the emails failed again. I deleted the query and it worked.

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

    Re: SendObject Action in Macro (2003)

    Without further information I have no idea. Sorry.

Posting Permissions

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