help with after insert event in Access 10

[richlyn]

I am not able to populate the email address in the to field which needs to picked up from a referenced table.