Re: FN-FORUM Mailing Lists

date posted 12th January 2001 13:30

using asp to do mass emails is NOT a good idea! i speak from experience
here... :)
if you must use it though, loop using paged recordsets.
this will fire off 10 emails at a time and calls itself - this stops
timeouts but hits the server hard

set rs=server.createobject("adodb.recordset")
set mailobj=server.createobject("aspSmartmail.SmartMail")

pg=trim(request.querystring("pg"))

if pg="" then pg=1

rs.pagesize=10

rs.open sql, conn, adopenstatic

indexer=0

while not rs.eof and indexer I tried doing a loop with CDONTS whereby it created a new e-mail
> specifically for that one person - but when using the loop for CDONTS to
> send every one - I got an error. To resolve this I put the e-mail
addresses
> in a bcc field with the first to field used as a copy to myself. The
trouble
> is the length of the bcc field is getting larger and larger and creating a
> long server time and send time which the isp will not enjoy.
>
> I would welcome any advice as to the looping idea without having any
access
> rights if you have any.
>
> Thanks in advance
>
> Stephen Parker
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html