473,231 Members | 1,791 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Sending Many emails at once

I have an exchange server, that I sometimes use to perform mail shots to
clients on our database, these can be upwards of 1000 at a time.
As we don't want different clients to see who we are working with we put
these mailshots in the bcc field of the mails.

This can sometimes cause a problem as we are getting alot of mails bounced
back. I would like to write a script to have these emails sent
out individually using the to: field of the mail. I have googled for
examples of doing this but haven't found anything useful yet

Could somebody please point me in the right direction

Thanks

Stuart

p.s. I am not sending out Spam, I am sending mail to clients on our database
that have specifically said they want to receive mail from us!
--
Quidquid latine dictum sit, altum viditur.

(Whatever is said in Latin sounds profound.)
Jul 19 '05 #1
10 4924
It's the exact same code to send the mail...just use the .TO property. Or
are you saying you dont know how to do the DB lookup loop?

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Stuart Mueller" <I.*********@email.address> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...
I have an exchange server, that I sometimes use to perform mail shots to
clients on our database, these can be upwards of 1000 at a time.
As we don't want different clients to see who we are working with we put
these mailshots in the bcc field of the mails.

This can sometimes cause a problem as we are getting alot of mails bounced
back. I would like to write a script to have these emails sent
out individually using the to: field of the mail. I have googled for
examples of doing this but haven't found anything useful yet

Could somebody please point me in the right direction

Thanks

Stuart

p.s. I am not sending out Spam, I am sending mail to clients on our database that have specifically said they want to receive mail from us!
--
Quidquid latine dictum sit, altum viditur.

(Whatever is said in Latin sounds profound.)

Jul 19 '05 #2
Curt_C [MVP] put finger to keyboard and typed:
It's the exact same code to send the mail...just use the .TO
property. Or are you saying you dont know how to do the DB lookup
loop?
"Stuart Mueller" <I.*********@email.address> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...
I have an exchange server, that I sometimes use to perform mail
shots to clients on our database, these can be upwards of 1000 at a
time.
As we don't want different clients to see who we are working with we
put these mailshots in the bcc field of the mails.

This can sometimes cause a problem as we are getting alot of mails
bounced back. I would like to write a script to have these emails
sent
out individually using the to: field of the mail. I have googled for
examples of doing this but haven't found anything useful yet

Could somebody please point me in the right direction

Thanks

Stuart

p.s. I am not sending out Spam, I am sending mail to clients on our
database that have specifically said they want to receive mail from
us!
--
Quidquid latine dictum sit, altum viditur.

(Whatever is said in Latin sounds profound.)


I don't know where to start, basicaly!
Will I need an app like aspemail to do the sending of the mail or can I use
something built into IIS?

would aspemail be able to handle sending out so many emails, would IIS be
able to handle sending out so many emails?

I could figure out the DB lookup loop, if I just knew what to use =(

Stuart
Jul 19 '05 #3
Seems like ur working with a distribution list not a DB?
anyhows,

you can use the CDONTS or CDOSYS objects, depending on which platform ur
running on...
"Stuart Mueller" <I.*********@email.address> wrote in message
news:uC**************@TK2MSFTNGP10.phx.gbl...
Curt_C [MVP] put finger to keyboard and typed:
It's the exact same code to send the mail...just use the .TO
property. Or are you saying you dont know how to do the DB lookup
loop?
"Stuart Mueller" <I.*********@email.address> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...
I have an exchange server, that I sometimes use to perform mail
shots to clients on our database, these can be upwards of 1000 at a
time.
As we don't want different clients to see who we are working with we
put these mailshots in the bcc field of the mails.

This can sometimes cause a problem as we are getting alot of mails
bounced back. I would like to write a script to have these emails
sent
out individually using the to: field of the mail. I have googled for
examples of doing this but haven't found anything useful yet

Could somebody please point me in the right direction

Thanks

Stuart

p.s. I am not sending out Spam, I am sending mail to clients on our
database that have specifically said they want to receive mail from
us!
--
Quidquid latine dictum sit, altum viditur.

(Whatever is said in Latin sounds profound.)

I don't know where to start, basicaly!
Will I need an app like aspemail to do the sending of the mail or can I

use something built into IIS?

would aspemail be able to handle sending out so many emails, would IIS be
able to handle sending out so many emails?

I could figure out the DB lookup loop, if I just knew what to use =(

Stuart

Jul 19 '05 #4
Dominique put finger to keyboard and typed:
Seems like ur working with a distribution list not a DB?
anyhows,

you can use the CDONTS or CDOSYS objects, depending on which platform
ur running on...

I have a windows NT box that has my exchange 5.5 mail server on.
I have a windows 2000 box with IIS on, that hosts an intranet site.

Am I wrong in the belief that aspemail is an alternative to CDONTS?

Stuart
Jul 19 '05 #5
It's a third party solution/component and depending on what you need, not
necessary. You will need access to an SMTP server. Here is a simple example
of CDO
http://www.darkfalz.com/1090

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Stuart Mueller" <I.*********@email.address> wrote in message
news:ul*************@TK2MSFTNGP12.phx.gbl...
Dominique put finger to keyboard and typed:
Seems like ur working with a distribution list not a DB?
anyhows,

you can use the CDONTS or CDOSYS objects, depending on which platform
ur running on...

I have a windows NT box that has my exchange 5.5 mail server on.
I have a windows 2000 box with IIS on, that hosts an intranet site.

Am I wrong in the belief that aspemail is an alternative to CDONTS?

Stuart

Jul 19 '05 #6
Curt_C [MVP] put finger to keyboard and typed:
It's a third party solution/component and depending on what you need,
not necessary. You will need access to an SMTP server. Here is a
simple example of CDO
http://www.darkfalz.com/1090
"Stuart Mueller" <I.*********@email.address> wrote in message
news:ul*************@TK2MSFTNGP12.phx.gbl...
Dominique put finger to keyboard and typed:
Seems like ur working with a distribution list not a DB?
anyhows,

you can use the CDONTS or CDOSYS objects, depending on which
platform ur running on...

I have a windows NT box that has my exchange 5.5 mail server on.
I have a windows 2000 box with IIS on, that hosts an intranet site.

Am I wrong in the belief that aspemail is an alternative to CDONTS?

Stuart


So I could use CDONTS, I wouldn't need to use my exchange server.
I would just loop through all of the addresses in my list changing the
iMsg.To line

I can have html mail, which I need for the mailshots.

Would it cause a lot of congestion on my server, how quickly could CDONTS
process hte emails?
Does CDONTS use the default smtp server that comes with IIS?
Is CDONTS installed by default?

Stu
Jul 19 '05 #7
Use CDO if your server supports it, CDONTS is old and going away.
CDO/CDONTS is installed with IIS.
CDONTS only uses the webserver's SMTP, CDO allows you to point to any SMTP.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Stuart Mueller" <I.*********@email.address> wrote in message
news:OJ**************@TK2MSFTNGP12.phx.gbl...
Curt_C [MVP] put finger to keyboard and typed:
It's a third party solution/component and depending on what you need,
not necessary. You will need access to an SMTP server. Here is a
simple example of CDO
http://www.darkfalz.com/1090
"Stuart Mueller" <I.*********@email.address> wrote in message
news:ul*************@TK2MSFTNGP12.phx.gbl...
Dominique put finger to keyboard and typed:
Seems like ur working with a distribution list not a DB?
anyhows,

you can use the CDONTS or CDOSYS objects, depending on which
platform ur running on...
I have a windows NT box that has my exchange 5.5 mail server on.
I have a windows 2000 box with IIS on, that hosts an intranet site.

Am I wrong in the belief that aspemail is an alternative to CDONTS?

Stuart


So I could use CDONTS, I wouldn't need to use my exchange server.
I would just loop through all of the addresses in my list changing the
iMsg.To line

I can have html mail, which I need for the mailshots.

Would it cause a lot of congestion on my server, how quickly could CDONTS
process hte emails?
Does CDONTS use the default smtp server that comes with IIS?
Is CDONTS installed by default?

Stu

Jul 19 '05 #8
On Tue, 11 May 2004 17:00:01 +0100, "Stuart Mueller"
<I.*********@email.address> wrote:
Curt_C [MVP] put finger to keyboard and typed:
It's a third party solution/component and depending on what you need,
not necessary. You will need access to an SMTP server. Here is a
simple example of CDO
http://www.darkfalz.com/1090
"Stuart Mueller" <I.*********@email.address> wrote in message
news:ul*************@TK2MSFTNGP12.phx.gbl...
Dominique put finger to keyboard and typed:
Seems like ur working with a distribution list not a DB?
anyhows,

you can use the CDONTS or CDOSYS objects, depending on which
platform ur running on...
I have a windows NT box that has my exchange 5.5 mail server on.
I have a windows 2000 box with IIS on, that hosts an intranet site.

Am I wrong in the belief that aspemail is an alternative to CDONTS?

Stuart

So I could use CDONTS, I wouldn't need to use my exchange server.
I would just loop through all of the addresses in my list changing the
iMsg.To line

I can have html mail, which I need for the mailshots.

Would it cause a lot of congestion on my server, how quickly could CDONTS
process hte emails?


Rather slowly compared to an Exchange distribution list (stop putting
email addreses in BCC fields, that's a typical SPAM trick and often
blocked.)
Does CDONTS use the default smtp server that comes with IIS?
Yes, if you choose to.
Is CDONTS installed by default?


It's not an installed/not installed item. It's a programming library,
part of the operating system setup (uses CDONTS.DLL). And you can use
it with your Exchange server if you wish.

Jeff
Jul 19 '05 #9
If you have a budget ($75.00 US for the Pro Version) check out JMail at
www.dimac.net
The pro version has a nifty Mail Merge that works great..

http://www.dimac.net/Products/w3JMai.../MailMerge.htm
"Stuart Mueller" <I.*********@email.address> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...
I have an exchange server, that I sometimes use to perform mail shots to
clients on our database, these can be upwards of 1000 at a time.
As we don't want different clients to see who we are working with we put
these mailshots in the bcc field of the mails.

This can sometimes cause a problem as we are getting alot of mails bounced
back. I would like to write a script to have these emails sent
out individually using the to: field of the mail. I have googled for
examples of doing this but haven't found anything useful yet

Could somebody please point me in the right direction

Thanks

Stuart

p.s. I am not sending out Spam, I am sending mail to clients on our database that have specifically said they want to receive mail from us!
--
Quidquid latine dictum sit, altum viditur.

(Whatever is said in Latin sounds profound.)

Jul 19 '05 #10

"Stuart Mueller" <I.*********@email.address> wrote in message
news:OJ**************@TK2MSFTNGP12.phx.gbl...
Would it cause a lot of congestion on my server, how quickly could CDONTS
process hte emails?


I've never formally stress-tested it but have successfully used this method
to send individual emails to over 3000 staff in one hit (using CDONTS).

Alan
Jul 19 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Mr. x | last post by:
Hello, I am sending emails with Hebrew contents. When receiving emails - I cannot see the Hebrew characters (it is not outlook express configuration, because when receiving emails from friends -...
3
by: Steve Thurston | last post by:
Hi, I'm attempting to send emails for the first time using ASP.NET, so I'm hoping there's just a beginner's error going on here for me. But my emails aren't reaching their destination, and I...
8
by: Philippe Lang | last post by:
Hello, I need to send emails from Postgresql triggers. I was able to do it with a 'plperlu' function, that calls the 'system' perl function, that itself calls the 'mail' shell function. Is...
8
by: windandwaves | last post by:
Hi Folk I want to send out a basic newsletter from my MySql database of contacts. Does anyone know a nice and simple bit of PHP that allows me to do this? TIA - Nicolas
5
by: Kun | last post by:
i have the following code: ---------------------------------- import smtplib from email.MIMEText import MIMEText fp = open('confirmation.txt', 'rb') msg = MIMEText(fp.read()) From =...
5
by: Jai | last post by:
Hi, I am in a problem of sending mass emails(newsletter) to my website members. Actually my problem is this: I want to send newsletter to my website members. But I had given a facility for...
4
by: squishy | last post by:
I want to check an emailbox (that does not offer forwarding functions) and forward the mail in it to my new account. That's not a problem. But, I want the mails that I forward to my new email...
10
by: Jesse Burns aka jburns131 | last post by:
Here's my code: $today = getdate(); $to = someone@somewhere.com; $subject = "New Application: ".$userdata." - ".$today."/".$today."/".$today; $message_header = "New Application:...
0
by: sheel331 | last post by:
Hello, I am new to coding in vb.net and have run into an issue with some code that I am looking over. This is a webform that is filled out and once it is filled out, it takes the responses from...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.