• E-mailing an Access Report

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » E-mailing an Access Report

    • This topic has 5 replies, 5 voices, and was last updated 24 years ago.
    Author
    Topic
    ac9fz
    Guest
    June 7, 2001 at 3:57 pm #1769694

    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!

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSnevwill
      AskWoody Lounger
      June 8, 2001 at 10:19 pm #1784292

      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.

      Reply | Quote
      • ac9fz
        Guest
        June 8, 2001 at 10:34 pm #1784295

        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

        Reply | Quote
        • WScharlotte
          AskWoody Lounger
          June 9, 2001 at 9:03 am #1784337

          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.

          Reply | Quote
          • WSbobdog
            AskWoody Lounger
            June 9, 2001 at 9:40 pm #1784349

            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?

            Reply | Quote
            • WSRupert
              AskWoody Lounger
              June 10, 2001 at 1:55 am #1784357

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

              Email from Access

              And go to “MS Access Downloads”

              Reply | Quote
    Viewing 0 reply threads
    Reply To: E-mailing an Access Report

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.