Sending e-mail using a dbase and CDONTS

[Mike]

I have an Access dbase that contains contact information. One of the fields
is an email address. Can I use ASP and CDONTS to send a email message to all
the address listed in the dbase?

Can I 'loop' through the code for all addresses?

Or what would be a better option.

Basically....I have a dbase, which contains email addresses, that I need to
send regular messages too.
The dbase has records added to it daily and I always need a real time list.

I have looked at programs that connect Outlook with Access but they need to
be sync'd every time a record changes, so that won't work.

Thanks,

Mikeal

 

[Jack Brewster]

Mike,

As long as you can retrieve the records from the database, you should be
able to use CDONTS to process the messages. Here's some sample articles
that should help you get familiar with CDONTS.

http://www.asp101.com/samples/email.asp
http://www.asp101.com/samples/email_html.asp
http://www.asp101.com/samples/email_attach.asp

I assume you can already pull records from the database. If not, you
can find samples for that at the same site.

 

[Mike]

Jack,

I have no problem setting a connection to my dbase and I am currently using
CDONTS to send messages form my server.

How can I set the code to send a message to ALL of the records in the dbase.

Can I loop through the code until eof is reached?

Or how could I format the dbase results to display all of the email
addresses to be separated by a semicolon?
(e-mail address removed); (e-mail address removed); (e-mail address removed);ect.......

Mikeal

 

[Jack Brewster]

Mike,

Create a routine that accepts an email address as a paramenter and
generates an email message.

Do a query to get all the email addresses from your database.

Take that result set and submit each record to your mail generation
routine. Regular loop-type stuff.

It's quick and dirty, but it should work. If you find that you are
sending a LOT of messages (that's relative and you'll have to determine
for yourself) or that the load on the server is too much, you may want
to find a more efficient solution.