Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to send email to a group of people from access DB?

0 views
Skip to first unread message

cooldv

unread,
Jun 1, 2003, 4:20:49 PM6/1/03
to
i have an access DB that contains first name, last name, city, state,
zip, email address etc....

is it possible to send email to a group of people from the DB, based
on say city or state or last name and likewise.
(example is: an HTML display where there will be a link saying - send
email to all the people in this group (who have the same zip code
xxxxx)

Any help appreciated

Curt_C [MVP]

unread,
Jun 1, 2003, 4:29:25 PM6/1/03
to
It's just your Select statement.
Pass the results to CDO and have it send the e-mail.

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
..Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"cooldv" <md...@hotmail.com> wrote in message
news:d356c6c0.03060...@posting.google.com...

Simon Wigzell

unread,
Jun 1, 2003, 8:13:17 PM6/1/03
to
Curt is very "curt" in his replies. An examples is always much better than a
description so to select all records where zip code = e.g. 12345 "

SELECT * FROM Addresses WHERE ZipCodeField='12345'


Bullschmidt

unread,
Jun 2, 2003, 12:32:35 AM6/2/03
to
You can separate people in the To part of the CDO or CDONTS e-mail
with a space and a comma.

Otherwise you could send an e-mail for each person:

ASP News Letter by Faisal Khan
http://www.stardeveloper.com/asp_newsletter_1.asp

Best regards,
J. Paul Schmidt
http://www.Bullschmidt.com - Freelance ASP Web Developer
http://www.Bullschmidt.com/DevTip.asp - ASP Developer Tips

0 new messages