CDOSYS Process timing out

[lscott35020]

I've got an asp application that bulk emails a large number of clients by looping through a database. The database is large enough that the process 'times out' before it completes, meaning that the 'Send Email' button has to be clicked 5-6 times before all the emails are sent.

How do I keep the process active until all the emails are sent?

 

[TheCandyman]

By default IIS has a set 'time out' period. Thankfully in ASP we can set our own time outs by using this:

Server.ScriptTimeout = 110

Which means this page will time out after 110 seconds. You can adjust the number accordingly. If i have a large email blast to send after each email i normally send this

	'...get emails ready to send, then...
	objMail.Subject = "Email Reminder"
	objMail.HTMLBody = strReturn
	
	If Err.Number <> 0 then
		response.write Err.Description
		Error.Clear
	Else
		objMail.Send 'no errors, send email
	End If
	Set objMail = Nothing 
	Set cdoConfig = Nothing 			
	response.write " Sent to: " & rs("email") &"<br>"
	response.flush