Results 1 to 3 of 3
  1. #1
    knightangel is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2014
    Posts
    2

    Multiple individual reports emailed

    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?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe a multiselect listbox that contains possible recipients?
    https://www.accessforums.net/forms/l...ery-43595.html
    Last edited by ItsMe; 05-13-2014 at 06:33 AM. Reason: typo

  3. #3
    knightangel is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    May 2014
    Posts
    2
    I will definitely take a look at these and see if they will work. Thank you for the link!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Individual Record Reports
    By Abarxax in forum Access
    Replies: 1
    Last Post: 04-19-2014, 09:43 AM
  2. Replies: 6
    Last Post: 03-19-2014, 03:53 PM
  3. Email Individual Access Reports
    By Nae in forum Reports
    Replies: 3
    Last Post: 08-26-2012, 04:39 PM
  4. Individual Record Reports
    By ThebigCt in forum Reports
    Replies: 6
    Last Post: 02-15-2012, 07:37 PM
  5. print individual reports for all value in a table
    By brennanstice in forum Reports
    Replies: 1
    Last Post: 09-01-2011, 07:27 AM

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
  •  
Other Forums: Microsoft Office Forums