Databases and Emails

E

Elle

I have used Access to manage a customer database. Am I able to use the email
entries for each customer to send a bulk email?
 
A

Alex White MCDBA MCSE

Hi,

Yes, several ways to solve this problem, you can automate outlook to
generate the emails, (there are security problems with doing this, but there
are solutions to that problem), you can write your own code to email via an
SMTP server, I have some code if you want it (quite complex!). I have spent
the last 10 years writing email generating systems and there are a few
gotchas, one make sure the person you are emailing wants you to email them,
by just emailing your whole database you could get yourself blacklisted on
some email systems. NEVER put more than one person in the TO line, because
everyone can see everyone else that has been emailed. A tip put your email
address in the TO line and BCC everyone else. If your email is ether large
or your are emailing 100s or 1000s of contacts, you will want to break the
email into chunks e.g. email 100 people wait then email the next 100 etc.
For small numbers use Outlook for greater than 100+ write your own code.

What is the content of the email, what I mean is, is it in plain text, html,
does it have attachments?

Post back here if you need more information on how to bind with access.
 
Top