Results 1 to 6 of 6
  1. #1
    ac9fz
    Guest

    E-mailing an Access Report

    I want to e-mail a report to a list of recipients. The recipients are in the group header so there is a page break for each recipient. I can't find an e-mail option in Access. If I try to e-mail it via a Word E-mail merge, it creates a page for each record in the detial section so the recipients receive multiple pages.
    Help - How can I send each recipient their individual sheet?
    Thanks a heap!

  2. #2
    New Lounger
    Join Date
    Dec 2000
    Location
    Rockhampton, Queensland, Australia
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-mailing an Access Report

    In O2K under File menu there is a Send To option. However if the data for each recipient differs, this method will send the complete report to each recipient. The other alternative is to use automation.

    It may be easier to filter the report for each recipient and then email.

  3. #3
    ac9fz
    Guest

    Re: E-mailing an Access Report

    You're right, I do want to send different parts of the report to each individual. I want to create an automated process to send the portion of the Access report that pertains to the recipient (based on the Group Header) to the proper person. I'm struggling with hoa to automate this.
    Thanks,
    Andrew

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: E-mailing an Access Report

    The problem is partly in perception. Access reports don't really have pages in the same sense that Word docs have, and what's on any given "page" can cause it to run over into another one. Even Access has to run through the report a couple of times to figure out how many pages it has. You'd be best off to either apply filters for each person and then email the result sequentially, or to use a Word mail merge instead.
    Charlotte

  5. #5
    2 Star Lounger bobdog's Avatar
    Join Date
    Jan 2001
    Posts
    108
    Thanks
    3
    Thanked 5 Times in 4 Posts

    Re: E-mailing an Access Report

    I have an app where I need to email monthly invoices to each department, maybe 50 per month. This client uses Outlook and Access 2000. Is this doable? I know how to do this for a single report (and it works beautifully), but haven't yet tried creating a blizzard of emails to different recipients all at once. Any problems you're aware of?

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: E-mailing an Access Report

    You might find this useful, although I have only just found it and have no experience with it!

    <A target="_blank" HREF=http://www.candace-tripp.com/_pages/HTML/default_HTML.asp>Email from Access</A>

    And go to "MS Access Downloads"

Posting Permissions

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