Retreiving entries from a list (form)

[GT_engineer]

I have a form with a subform. The subform is in datasheet format and is basically a list of employee. So you add as many employees as you want to a particular form (the form is for inspections). Some forms may have 2 employees and others 4-5.

I have a button where you click it and it will send an email to the employees on the list.

I don't know how to retrieve the employees name from the list???

If it were a single form I could easily do name = me.Employee but becuase its from a datasheet i have several employees.

Any ideas??

 

[GT_engineer]

I also want to add that i want to retrieve the names one at a time because I'll have to do a DLookup to retrieve the email address of each employee. I will then have to add all of the email addresses together in one continous string to send the email out.

thanks