I was wondering what the best method to email to a list of people in a table would be. I have a table with set up with the first field in the table as employee. The employee table already has the names set up correctly for outlook as lastname, firstname. Currently my email button is set up as so...

oOutlook = CREATEOBJECT("Outlook.Application")
#DEFINE olMailItem 0
oMailItem = oOutlook.CreateItem(olMailItem)
WITH oMailItem
	.To = "Name1; Name2; Name3; Name4; Name5; etc"
	.CC = "Name6"
 	.Subject = "Violation Report - " + thisform.lblPERMITTEE.Caption

However, every time a new employee gets added or deleted, we have to change the list of people many times throughout the database.

What would be a good way to parse through the employee_lookup table with the field employee as the list in the To column?