List of emails based on name selections.

[Coxck]

I am creating a database to track status of jobs we have actively running. I would like to create a list of emails for each project. Currently I have my basic tables and forms built, and I would like to select people from the existing table and have all the emails pop up on the status form. What would be the best way for me to go about this. I could have upwards of 50 people in an email list.

I am more of an Excel person and I have just started learning DB.

Example:

Select names
Abby
Cory
Brian


Adam

Output
Abby@xxx
Cory@xxx
Brian@xxx
Adam@xxx

Thank you

Cory

[June7]

You want to list email addresses?

You have the full email address saved into a field?

Selecting multiple filter parameters for the same field will probably require a multi-select listbox and VBA code. Review http://allenbrowne.com/ser-50.html

Unless you want to manually type the parameter list into query object that uses IN operator for filter criteria. http://www.w3schools.com/sql/sql_where.asp