Hello,
I really need some help.  I have a database that I built in Access 2007 that
has some basic fields in it (i.e. name, address, email, date added to
database, etc.).  I plan on bundling the database with the Access 2007
Runtime to deploy it on my customers PC.  My customer wants the application
to automatically send out emails, with a predetermined message to recipients
from the EMAIL field in the CUSTOMERS table.  I have been able, using the
Visual Basic in Access, to generate the email using sendObject, however, I
can't figure out the "To" line without putting in the actual email address.  
How do I get the "To" line to pull up the email address from the CUSTOMERS
table.  Here is the code I have now:

DoCmd.SendObject _
   , _
   , _
   , _
   "ToJohn@doe.com", _
   , _
   , _
   "Subject", _
   "Message", _
   False

Thank you for any help.