Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Sending emails to all in a database field

Explorer ,
Jan 31, 2007 Jan 31, 2007
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
TOPICS
Server side applications
189
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 31, 2007 Jan 31, 2007
LATEST
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
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines