Skip to main content
Inspiring
January 31, 2007
Question

Sending emails to all in a database field

  • January 31, 2007
  • 1 reply
  • 187 views
Hi Guys,

I have a field in my database that holds a users email address, and Id like to email all users in the table if possible.

I have never tried this but can just think I need to make a form to send from and when I hit send Im not sure whether I need to save my input to a database then send or save it somewhere else then send?

Also which ever way I do it how do I get my CDONTS to loop through my table fieild of addys so it sends to them all?

Any thoughts are appreciated....

Im using ASP / VBS / Access database.

Thanks in advance for any thoughts.
Tag
This topic has been closed for replies.

1 reply

Inspiring
January 31, 2007
TAG

There are two ways of doing this depending on whether it is a general
message, or if parts are being customised.

If it is the later then you create a recordset, and then place a repeat
region on the page. Inside of the repeat region you enter your CDO mail
code. This loops the program and sends out one email at a time. What you
have to watch with approach is that you may need to set a higher scrip
timeout for the page.

If it is a general message then create a recordset, and then write the email
addresses to a string variable with a comma separating them. You can then
use this variable in the BCC field of a single CDO script.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Tag2007" <webforumsuser@macromedia.com> wrote in message
news:epqk8o$g7s$1@forums.macromedia.com...
> Hi Guys,
>
> I have a field in my database that holds a users email address, and Id
> like to
> email all users in the table if possible.
>
> I have never tried this but can just think I need to make a form to send
> from
> and when I hit send Im not sure whether I need to save my input to a
> database
> then send or save it somewhere else then send?
>
> Also which ever way I do it how do I get my CDONTS to loop through my
> table
> fieild of addys so it sends to them all?
>
> Any thoughts are appreciated....
>
> Im using ASP / VBS / Access database.
>
> Thanks in advance for any thoughts.
> Tag
>