Seperate Email for each record

[toby131]

I have a Access 2003 database containing contact information for customers.
I would like to send an email to each customer with the information in their
individual record. Is it possible to do this in access so that I do not have
to individually create each email? Here is the basic set-up of what I am
trying to send, with the fields that I need to be record specific in brackets:

TO:

Dear [Contact Name],
We are working to ensure we have the correct contact information for all our
customers. Would you please check the information below and get back to us
as soon as possible to let us know whether it is correct or if changes have
occured.

Contact Name: [Contact Name]
Phone Number: [Phone]
Address: [Address], [City], [State], [Zip]

 

[Mark Andrews]

You can loop through a recordset and build the email (to, cc, body etc...)
in code.

Take a look at our email module it is designed to allow you to build email
templates (text and html).
http://www.rptsoftware.com/products/email/

We currently use Ostrosoft's smtp component to send the email but you could
switch a few lines of code and send it via Outlook if you like that method
better.

Hope this helps,
Mark
RPT Software
http://www.rptsoftware.com

 

[erika gomez]

JSDYN ESTA CON MI HERMANA TIENEN UN NEGOCIO EN TORREMOLINOS SE LLAMA EL
CASCARON Y ESTA EN CALLE PEZ DORADO EL SE HACE PASAR POR MI MADRE MARYCRUZ Y
TODAS LAS NOCHES VIENE A DORMIR A CASA DE MI MADRE EN CALLE JUAN DE LA
ENCINA Y MIENTRS DUERMO NO SE QUE HACE

 

[erika gomez]

SIEMPRE M E HE PENSADO QUE ERA MI MADRE Y LA ADMIRABA HASTA QUE SE LE
EMPALMO Y NOTE ALGO DURO ENTONCES ME DI CUENTA DE QUE NO ERA' CLARO NO ES
QUE A MI ME GUSTE MIRAR PERO RECONOCERIA A MI MADRE DE LEJOS Y COMO ESTABA
CIEGA CON TANTA MEDICACION Y AUN ASI NOTABA ALGO RARO PUES POR ESO LA MIRABA
TANTO
UN SALUDO

 

[Paul Shapiro]

You can use Word to do a mail merge using the Access db as the data source.
Word can merge to email. Automating the complete process from Access VBA
code is moderately complex, but doing it manually from Word is very
straightforward.

 

[LukeChung-FMS]

I have a Access 2003 database containing contact information for customers.  
I would like to send anemailto each customer with the information in their
individual record.  Is it possible to do this in access so that I do not have
to individually create eachemail?  Here is the basic set-up of what I am
trying to send, with the fields that I need to be record specific in brackets:

TO:

Dear [Contact Name],
We are working to ensure we have the correct contact information for all our
customers.  Would you please check the information below and get back to us
as soon as possible to let us know whether it is correct or if changes have
occured.

Contact Name: [Contact Name]
Phone Number:  [Phone]
Address: [Address], [City], [State], [Zip][/QUOTE]

This is a feature that's part of our Total Access Emailer program.
Total Access Emailer lets you reference fields from your data source
in each email so you can personalize each message. Fields can also be
referenced in the subject line, attachments, etc. You can also attach
filtered data and reports for each recipient so they only get their
data.

More info here: http://www.fmsinc.com/MicrosoftAccess/Email.asp

A free demo is available here: http://www.fmsinc.com/Products/Emailer/conftrial.asp

Good luck!

Luke
FMS, Inc.
http://www.fmsinc.com