Creating an email with many recipients address

[Sebastien Bergeron]

Hi Everyone,

I have a DB with 2 Tables. One is the staff list. Each record his a person with contact information fields: Name, email , phone etc . . .

The other one is base on (Job) that we are working on. Each record is a job. The fields are mostly to describe the job ; duration, location, description, status, etc. Also I have few fields about who are assigned to work on it and what task they have to do. These fields are "Drop-Down List" that uses the values of the other database ( the staff one).So a list of all the people appear to chose from so i can i assign them to the job.

Here the question: I want to add a "button" that would lunch a script that would send an email to all the people that have been assigned to work on that job. So basically the script would get the name of each field that have a name on it and would "retrieve" their email using the email field for the same record from the "staff" DB.

Can someone help me ?