Results 1 to 10 of 10
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Automate Emailing of reports (Access 2000 >)

    Hi,

    I have a friend that has a access database. Recently they asked me to help automate the emailing of reports, and I am stuck!!!
    The reports is a query with a parameter. the parameter prompts for a code, ie, 1, 2 , 3 etc. If 1 is typed a certain group of records is filtered and supplies the report with that group of records. This must then be emailed to the appropriate client. Is there anyone who can help me with a macro, or vba script to automate this procedure!?

    I am sending a zip file that contains the DB for reference sake.

    Many thax for the one who can assist me...
    Attached Files Attached Files
    Regards,
    Rudi

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automate Emailing of reports (Access 2000 >)

    Have a look at the (very long) thread started at <post#=335437>post 335437</post#> or do a search on the lounge about PDF or Snapshot and you will find solutions. If you need more help feel free to ask.
    Francois

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automate Emailing of reports (Access 2000 >)

    I'll have a look and see if I can puul anything from it. I might call again though!

    thanx Francois
    Regards,
    Rudi

  4. #4
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automate Emailing of reports (Access 2000 >)

    If/when you do come up with an 'easy to use' 'works every time' solution pl post it in full detail for us who have tried & failed to solve similar problems!

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

    Re: Automate Emailing of reports (Access 2000 >)

    The thread starting at <post#=375863>post 375863</post#> seems to be related to what you want (or rather, your friend).

    Before implementing the code to e-mail per section, the query and report must be modified: the parameter must be removed from the query, and the info from the report header of the report must be moved to the group header. See attached version.
    Attached Files Attached Files

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automate Emailing of reports (Access 2000 >)

    Hi Hans
    Browsing around the various posts, this seems to be a rather common query concerning emailing a group of records as a report the various people. It also seems that u have quite a bit of experience and knowledge in this area. Your reference to the post thread of SmokeEater is similar to what i need, and i have worked on it based on the code in the DB. I am not getting the sendobject part working though. Also, the code will send one record at a time based on how it is configured at the moment.
    My access vba is not very up to scratch. Would you please assist me in getting this automation working.
    Thanx very much
    PS, I have included the DB with the latest changes. Please check where I am going wrong.
    Attached Files Attached Files
    Regards,
    Rudi

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

    Re: Automate Emailing of reports (Access 2000 >)

    Try the attached version. It prints the report if Email = "1", otherwise sends it, one for each code. It does this by opening, and looping through, a recordset grouped by code.

    In answer to Debbie's other question: unfortunately, snapshot is the only format that will preserve images, so the logo will have to be text only.
    Attached Files Attached Files

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automate Emailing of reports (Access 2000 >)

    Hans, your a star. You are living up to your reputation, and I'll certainly give credit where it is due!!!!!!

    I tested it by emailing the report to myself, and it works like a bomb!
    Thanx soooo much!
    I'll call again when necessary!
    Regards,
    Rudi

  9. #9
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automate Emailing of reports (Access 2000 >)

    Ian,
    Here is a working solution based on your statement. Well, it worked 4 me that is!
    Hans has very generously shared from his wealth of knowlege to create a solution that works wonderfully.
    see the attachment for proof!

    Cheers
    Attached Files Attached Files
    Regards,
    Rudi

  10. #10
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automate Emailing of reports (Access 2000 >)

    Thanks. I'm sure I'll find a use for the technique.

Posting Permissions

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