Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2006
    Posts
    39

    Unanswered: Trying to SendObject 2 Reports to email

    Ok - thanks to StarTrekker I was able to figure out how to macro SendObject to have a report sent as a snapshot attachment in an e-mail.
    Now my delima is that I need to get two of these reports attached to the same e-mail. Any suggestions?

    My ultimate goal is this:

    I'm trying to set this up so when I click on a button for "Training", and e-mail will be generated with two reports attached, one showing open results, the other with closed. I'd also like to Output both reports to a storage location for my archives. (i.e. Open_Training and Closed_Training in an archive folder)

    Thoughts or suggestions?
    Thanks a bunch!

    B-man

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    I don't think you can specify multiple attachments with sendobject. What email program are you using?

  3. #3
    Join Date
    Dec 2006
    Posts
    39

    Re: SendObject

    Rogue,

    I'm using Outlook for email.
    Can this work?



    Thanks ~

    B-man

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    You can use Outlook Automation. There are plenty of code snippets floating around (including here http://www.dbforums.com/archive/index.php/t-719698.html) to get you started. Post back if you run into specific problems.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You might also like to consider the possibility of making a report that has both your reports as sub-reports (merge the two reports) and send that with SendObject. Probably not the best way to go, but I thought it might be worth considering.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Dec 2006
    Posts
    39

    In Response

    Thanks Rogue and StarTrekker.
    I think the simpler solution is probably to subreport.
    I will do that.

    Thanks again for both of your suggestions.



    B-man

Posting Permissions

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