Send Emails Automatically

[DiveKennene]

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 _
, _
, _
, _
"(e-mail address removed)", _
, _
, _
"Subject", _
"Message", _
False

Thank you for any help.

 

[Sim]

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 _
, _
, _
, _
"(e-mail address removed)", _
, _
, _
"Subject", _
"Message", _
False

Thank you for any help.