Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 4th, 2005, 02:35 PM
Authorized User
 
Join Date: Jun 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Is there queing facility available in CDO?

Hai!
 I am designing a website where I need to send email to more than 5000 members at a time. It is not possible to include all these email address in BCC and execute it because of 2 important reasons:
1. It takes very long time to execute and the output that is to be displayed is delayed.
2. The script execution time given by my webhost is 30 seconds. Which is not possible to send bulk emails.
So, I want piece of program that can put this 5000 emails in the que and get back immediately to display the output to my users. I want the program to use CDO. please help me..

Arul Kumar.PA
__________________
Arul Kumar.PA
 
Old March 4th, 2005, 07:14 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

BCC - not a good option.

I assume your addresses are in a data base? Just treat it like a normal loop and execute your mail script each time. The following assumes you have a connection string called conn:
--------------------------------------
dim myAddresses
sql = [get all the addresses in a record set]
set myAddresses = conn.execute(sql)
if not myAddresses.Eof
   do until myAddresses.Eof
      [now execute your mail script - CDO, CDONTS - any method that works]
      myAddresses.moveNext
   loop
else
   response.write "No records found"
end if
--------------------------------------

;;;The script execution time given by my webhost is 30 seconds. Which is not possible to send bulk emails

Im very sure the default is 90 seconds, you get what you pay for with hosting. Anyhow - using the method above this is not a problem.

Wind is your friend
Matt





Similar Threads
Thread Thread Starter Forum Replies Last Post
Collection facility AnjuSujith ASP.NET 2.0 Professional 6 November 27th, 2007 01:13 PM
Search Facility JayLou BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 0 March 26th, 2007 05:37 AM
Search Facility in site qazi_nomi Classic ASP Basics 3 March 14th, 2005 07:57 PM
How to give login logout Facility cbpanchal VB How-To 2 July 28th, 2004 06:42 AM
How to add attachment facility with JSP page. monika_jain_99 J2EE 2 July 9th, 2003 12:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.