Access as Email generator

A

Alexandre Saillant

Hi,

I have a Access database with Customers names, critical info and emails. I
want to be in touch with them on a monthly basis. I want to send a monthly
news letter. I only have 500 - 600 hundreds people to send stuff to and I
would like to personalized my emails. I can use Access to generate a DAP or
report that will create that personalized email content. I just dont know
how to send the DAP or Report as an email automaticaly.

I would like access to send them one by one or so. I dont care if take all
week-end to do it. I will never send much more thant this anyway.

How can I have a routine that send a DAP or Report to the email address in
each field in the Query? Is it possible?

Data look like this:
Joe Blacks, Sunfire, 30 000 km, shuttle service, [email protected]
Joe White, Montana, 40 000 km, shuttle service, [email protected]
Joe Green, CTS, 55 000 km, Rental Car, [email protected]

Alexandre Saillant
 
A

Arvin Meyer

There's some free code that is on my website that you could work with to
send email:

http://www.datastrat.com/Code/MultipleEmail.txt

You may want to have a look at this 3rd party solution. I've been using it
to generate pdf purchase orders and email them and I'm quite impressed. So
much so that I use it instead of my own code above. Look for the PDF and
Mail Class Library:

http://ourworld.compuserve.com/homepages/attac-cg/

Then if you don't mind spending more, there's the FMS application that does
it all right out of the box:

http://www.fmsinc.com/Products/Emailer/index.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
B

Brucels

I have been using WorldMerge (www.coloradosoft.com/) to send 400+
personalized emails each month to the members of an organization for which I
maintain an Access database. WorldMerge pulls the information from Access
with no problem.

I have also created statements and other personalized documents in Word
using the same information from Access with no problem. I understand that it
is possible to create emails in Word, but I haven't tried that yet.

Bruce
 
Top