I have a table Contact DB, with the typical ContID (PK), FName, LName, Phone, Email, etc for fields.
I have a second table Feedback DB, with some feedback on the Contacts with the following fields – ID (PK), ContID (FK), Reviewer, Date, Q1, Q2, etc.
I have a query and report (FeedbackQry & FeedbackRpt) on the Feedback DB that returns all of the information submitted, and another report (IndvFeedbackRpt) that prompts for the individual (Contact), and the date, so that it is a report for that person alone, for a certain date range.
The problem is that for 100 some odd people, you have to go into the report, type in the first person, the date, run the report, and then email. Rinse and repeat for each individual person. It is very time consuming.
I want to be able to fill out a form with a number of names, have it pull the email address based on the contact entered, and then email the report to each individual.
Enter Date Range: (Enter date range for report parameter) Contact Name: (Enter Name) Email address: (Pulled from Contacts based on Contact Name) (Enter Name) (Pulled from Contacts based on Contact Name) (Enter Name) (Pulled from Contacts based on Contact Name) (Enter Name) (Pulled from Contacts based on Contact Name) <Button to Email All Reports for Contacts entered above>
Is this possible?