Results 1 to 2 of 2
2014-05-23, 14:11 #1
- Join Date
- May 2014
- Gainesville, GA
- Thanked 0 Times in 0 Posts
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. email@example.com is on page 1 with pertinent information. firstname.lastname@example.org is on page 2 with pertinent information. I have no idea how to get page 1 to email@example.com and page 2 to firstname.lastname@example.org. (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.
2014-05-23, 15:07 #2
- Join Date
- Mar 2004
- Manning, South Carolina
- Thanked 1,473 Times in 1,340 Posts
The Following User Says Thank You to RetiredGeek For This Useful Post: