MS Access

[King of Town]

I have something I am trying to get to work, and it will probably take Visual Basic code that I don't know how to make work. Here is the situation:

I have a database with records in 3 different tables. I want to email those records to different people. There would be probably a different person getting an email for each record on the table. Instead of doing a different Send Object macro for each different recipient, I would like it to just read the receipients name off a field on the table.

So the to: field on the send object would look like [Tables]![John Smiths Table]![Employee Name]

I tried to write the code but I get an error telling me it can't find the field.

I'm probably not explaining it very well, but any help would be appreciated.

 

[GoodGame]

My if-all-else fails experience with Access is that some of the same things can be done in Excel, if less pretty.