Simple Access/VB Email Lookup question?

Question by Mr Dean: Simple Access/VB Email Lookup question?
Hello all, I have a little VB code that sends a generic message after a new record is added:

Private Sub Form_AfterInsert()
DoCmd.SendObject _
, _
, _
, _
"email address", _
, _
, _
"Subject", _
"Text", _
False
End Sub

How would one go about looking up an email address from a contact that is on sub form.

So for example, I give Dave a task to do in a task (entry in form creates a new task in

Read the full article here ...