CDONTS limitations...

[aamaker]

Im trying to come up with a way for our account managers to mass-mail all our clients (i.e. clients who need to know support info for the equipment they have bought from us, service and maint. tips, etc. -- not spam - things they've told us they want to know regularily.

In using CDONTS to try to test its ability to loop through the email addresses in the access 2000 database the page times out while looping throught the database...(10,000 + email address is what were dealing with - for testing I just used my own address 5,000 times in the database)

Is there a way to use CDONTS to handle sending email (passed from a form) to 10,000 + email addresses? (its important for the solution to be scalable - i.e. to be able to (a year from now) handle 20,000 +.


is BCC the answer here? ANyone have a working example of code to loop through database with this method?

THanks for your help.

 

[japes89]

I have come across similar issues. Be careful though, it is easy to fall into running the looping process in the webpage the accepts the form information!!! This will ...
1) take a long time ( especially for 5000 start recips )
2) only get longer as the list grows
3) may time out....

What I have done on my site is separate the two. Have the form send the "directions" as it were to the next page. That page then would hold the parameters of the job in a temporary table. Next, have a schuduled script that checks that temoprary table to 1) build the email messages and 2) send them out.

This keeps the web page away from looping of the CDONTS process and allows many account managers to access this site at once without stressing the sytem.

Hope that help.
Contact me if you have questions.

JP _______________________________________________
OutsideIntranets.com
Stop wasting time, get to work

http://www.outsideintranets.com

 

[aamaker]

by scheduled script you mean like a com object/application Not sure thats an option for me but thanks.

 

[japes89]

no, I mean a scheduled stored procedure, that kicks off every lets say 30 minutes. Or it could be a batch file that is run by the scheduler ( START->SETTINGs->CONTROL PANEL->SCHEDULED TASKS ) that kicks off a 'cscript vbs' .
Easy easy easy to build and run.
_______________________________________________
OutsideIntranets.com
Stop wasting time, get to work

http://www.outsideintranets.com