Bulk email using ASP

[James Thompson]

I need to send out about 800 emails from addresses stored
in an Access Database, can this be achieved using ASP and
maybe an emailing component? Any other resources?

Thanks

 

[Jeff Cochran]

I need to send out about 800 emails from addresses stored
in an Access Database, can this be achieved using ASP and
maybe an emailing component?

Sure. Though it's not the ideal method.

Any other resources?

There are a bazillion bulk mailing programs out there, Google and take
your pick.

Jeff

 

[Ray at]

For the hell of, I just ran a quick test on CDO vs. FSO for generating
e-mails, and this is what I got. I ran it a number of times, and the
difference between the two numbers was fairly consistent.

Sending 10,000 e-mails per object

CDO: 33.50781 seconds
FSO: 7.914063 seconds

Ray at home

 

[UncleWobbly]

a subject close to my heart at the moment - I have to send alert emails from
an application I develop for my company and have found CDO a bit
"sluggish" - care to post your FSO solution?

best regards

H

 

[UncleWobbly]

ah, OK, the FSO hasn't got any magic here - thanks for this.

 

[Ray at]

This is the basicest of a ".eml" file, but like so: (I stopped the smtp
service while doing this 10,000 times...)

Sub GenerateByFSO(NumberOfMessages)
Dim i
Dim oFSO, oFile

Set oFSO = Server.CreateObject("Scripting.FileSystemObject")
For i = 1 To NumberOfMessages
Set oFile = oFSO.CreateTextFile("C:\Inetpub\mailroot\pickup\msg" & CStr(i)
& ".eml")
oFile.WriteLine "X-Receiver: (e-mail address removed)"
oFile.WriteLine "X-Sender: (e-mail address removed)"
oFile.WriteLine "To: <[email protected]>"
oFile.WriteLine "Subject: Test FSO"
oFile.WriteLine vbCrLf
oFile.WriteLine "Test e-mail FSO"
oFile.Close
Set oFile = Nothing
Next
End Sub

It would have been a bit speedier (I'd imagine) to generate on string with
vbCrLfs and then doing only one .write on the file.

Ray at home

 

[Paul]

I read recently that it's better to create emails outside the SMTP Pickup
folder and then move them in, otherwise the SMTP service will attempt to
read the file immediately - if it's locked by the creating application this
might slow SMTP.
http://www.microsoft.com/technet/prodtechnol/iis/iis4/deploy/confeat/mail.asp

question - do we know if CDO writes direct to Pickup folder

also came across reference to trade-off between performance and delivery
guarantee
http://msdn.microsoft.com/library/e...ing_or_posting_using_the_pickup_directory.asp

question - have you changed from the default (use buffering) to guarantee
delivery

regards
paul

 

[UncleWobbly]

Yeash, thanks for this Ray. When you said you'd done it with FSO I thought
you had some method for FSO I had not encountered for dealing with mail but
I understand now - not enough vision on my part in reading your original
post here... Thanks anyway.