Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2014
    Location
    Gainesville, GA
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Separating Access Report to send out to Multiple Recipients

    This is my first post on Windows Secrets Lounge. I am a fairly tech savvy person that can generally figure out issues on my own but I absolutely have NO clue when it comes to VBA and macros.

    At my job a presented an idea to solve a problem by using Access and no good deed goes unpunished! I now have to come up with the solution as well!

    I have created a report titled "Fuel Exceptions Report". The info is grouped by email addresses. I have the report setup to separate pages by email address. 123@abc.com is on page 1 with pertinent information. 345@abc.com is on page 2 with pertinent information. I have no idea how to get page 1 to 123@abc.com and page 2 to 345@abc.com. (Also there are realistically about 1,500 different email addresses).

    I have a separate table with a list of email addresses that could possibly show on my report that links to the information being queried for my report. The fields of my report are Email Address (grouping), Card number, Vehicle ID (ties to the email address), Date, Merchant Location, Product, TransactionDate, Quantity and Exception.

    Any and all help is appreciated.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    JL,

    Welcome to the Lounge as a new poster!

    Check out post #2 in this thread. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    jlpatrick (2014-05-30)

Tags for this Thread

Posting Permissions

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