sending multiple emails

[Joey Martin]

I have about 5000 emails in my database. I wrote a basic script that sends
an email to all of those email addresses. Usually I have to break it up and
only send 300-400 at a time so my script does not timeout.
I know I can up my timeout to 45 minutes if I needed to, so that they could
all be sent at once, but I do not believe that is a wise decision.

Does any know of any other ways to do this more efficiently?

Thanks.

[Aaron Bertrand - MVP]

Re: sending multiple emails

Use Listserv software???

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

"Joey Martin" <mart3939@bells outh.net> wrote in message
news:5ONlc.6845 4$oN1.40372@big news5.bellsouth .net...[color=blue]
> I have about 5000 emails in my database. I wrote a basic script that sends
> an email to all of those email addresses. Usually I have to break it up[/color]
and[color=blue]
> only send 300-400 at a time so my script does not timeout.
> I know I can up my timeout to 45 minutes if I needed to, so that they[/color]
could[color=blue]
> all be sent at once, but I do not believe that is a wise decision.
>
> Does any know of any other ways to do this more efficiently?
>
> Thanks.
>
>[/color]