CFMail Timing out - Is this the most efficient way? 1

[wilcoHead]

I have a weekly mailer that goes out to over 1000 contacts. When I send this I am getting a CFMAIL timeout error:

------------------------------------------
"The request has exceeded the allowable time limit Tag: cfmail"
-------------------------------------------

I am using an access DB - My quesstion is, what is the fastes way to loop oveer the contacts and send out the e-mails without getting a timeout error?



-------------------------------------------
The Code
-------------------------------------------
<CFQUERY NAME="GetMailContacts" DATASOURCE="#request.dsn#" DBTYPE="ODBC">
SELECT *

FROM MailTable

</CFQUERY>
<CFMAIL
QUERY="GetMailContacts"
TO="#GetMailContacts.EmailFld#"
FROM="me@mysite.com"
SUBJECT="Weekly Mailer"
timeout="300">

<cfmailpart
type="text"
wraptext="74">
You are reading this message as plain text, because your mail reader
does not handle HTML text.
</cfmailpart>

<cfmailpart
type="html">
<---HTML Newsletter Here --->
</cfmailpart>
</CFMAIL>
-------------------------------------------------------

Thanks for your input;
WilcoHEAD

 

[ecobb]

You need to either change the timeout setting in the CF Admin (not recommended), or get a third party mail tag for bulk emails, something like:

http://www.activsoftware.com/activmail/

Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[Wullie]

You don't need to alter the timeout in the CFAdmin, you can do it from within the script itself so it isn't a global change:

<cfsetting RequestTimeout = "999">

Hope this helps

Wullie

Fresh Look - Quality Coldfusion/Windows Hosting

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[wilcoHead]

Wullie;

Where would I place that anywhere on the page?

Thanks for your input;
WilcoHEAD

 

[Wullie]

Just place it at the very top of the page.

Hope this helps

Wullie

Fresh Look - Quality Coldfusion/Windows Hosting

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell

 

[wilcoHead]

Thanks, I will try it!

Thanks for your input;
WilcoHEAD