How to send an automated email to email addrs in my Access db?

[Guest]

I have a small home-based business and maintain my customer mailing list in
an Access database. Most of my customers have email addresses so I would
like to send out my twic a year mailing via email using some kind of
automated means. My ISP doesn't allow me to send to everyone at once so it
takes me forever to cut and paste individual email addresses into Microsoft
Outlook and do this several times (1000!). Is there some way I can use the
email address field in my Access database and set up a macro or something to
run through each record in the database and send my email to each person
individually? (same message but sent one at a time to each record in my
database)

I would REALLY APPRECIATE any help since I've searched ALL OVER for this.
It seems like it shouldn't be difficult but I can't figure it out.

THANKS!!
Julie

 

[Steve Schapel]

Julie,

This would be possible with a macro. However, since it involves looping
through the records, a VBA procedure will be easier to get working.
There is some good information here...
http://www.granite.ab.ca/access/email.htm

 

[bob]

Try Helen Feddema at
http://www.helenfeddema.com/access.htm
go to 106

I use this technique myself and it is great!

Bob Galway