Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email sections of a access report (Access XP)

    Hi there,
    I have a report that contains many company divisions that are grouped. On my database switchboard, I want a button that will email the sections (divisions) of the report to the apprpriate areas. How would I go about it, do i need to sub divide the report first. How would the code look like that will do this task.

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

    Re: Email sections of a access report (Access XP)

    There is no way to send only one section of a report. You will have to use code to open the report once for each division, displaying only the records for that division. See <post#=275460>post 275460</post#> for a code example.

    If you use Outlook, you'll run into problems if you try to send e-mails programmatically. See <post#=286364>post 286364</post#> later in the same thread for workarounds.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email sections of a access report (Access XP)

    Thanks Hans

Posting Permissions

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