This is causing the buffer limit to exeed I believe or something. Either way, I'll explain what's happening and hope someone can help.

I've written a mass email page, it allows my administrator to email everyone on the database in one go, looping through the recordset to send each email out one at a time. This is working fine, but upon talking to my server admin there is a risk of being blacklisted if more than 120 emails are sent out in a minute.

As this is the case, I needed to slow the script down (I timed it and it took less than 15 seconds to email 55 people) and thought an easy way would be to delay it by a a second every email, meaning it could never send out more than 60 in a minute. I changed script time out to 300 seconds to stop it timing out and flush the page at the top to display a loading screen.

The problem I now have, is it takes absolutely ages instead, definately too long - it was 3 minutes before I gave up and it had only delivered 30 of the emails. Can anyone help me sort this delay out to stop it sending more than 120 emails in a minute.

My idea was the following, but for some reason this doesn't work correctly and slows it down more than it should.

If intTurn = 1 Then
intTurn = 0
Do Until Second(now) = Second(now)+1
' Wait
Loop
End If

I have never heard of this blacklist rule. Exactley who is going to blacklist you? Network administrators dont commonly have mush of a sense of humor, are you sure your one hasnt developed one?

Wind is your friend
Matt

I'm on a shared hosting environment and as a mean of protecting themselves from spam abusers the host has put in place bulk email limits. Anything more than 120 emails a minute gets my domain name blacklisted on there and I can no longer send out/recieve emails (the smtp is open for out and in usage)


Even if i wasn't to be blacklisted, it'd be interesting to know if there was a way to delay a script every x records without reverting to a resource intensive loop - just to further knowledge

If I may, my 2cents worth:

Everyones has high hopes for thier business systems. Alot of end users what mail, newsletters and the like. This rule is very restricting if you want a high volume, in, and outgoing infomative web site. Personally I would change to a more business like solution. You have to think, what other restictions do they have in place, or wil thay put in place in the future.

Anyhow - The second part of this article looks like what you are after:
http://www.4guysfromrolla.com/webtech/012101-1.shtml

Wind is your friend
Matt