Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Using a DTS to send SMTP mail to addresses in a table

Greetings,

Please could someone kindly provide me with some advice on the best way to achieve the following...

1 - I need to send the same email to a large number of recipients (several thousand) whose addresses reside in a table
2 - I do NOT have access to SQLSendMail so intend to cycle through a recordset using a DTS script and send via SMTP
3 - I believe that sending mails individually is probably not too efficient so considering adding to a recipient list
4 - If writing a script to add all (comma/semi-colon delimited), I believe it will exceed the maximum number of recipients
5 - If adding them to batches, what would be a suitable number and what is the most efficient code to do this?
6 - Is there anyway of creating an SMTP grouping or distribution list on the fly perhaps or is number 5 better?

If you have any example code to share, I would be very grateful indeed!

Many thanks,
Tony
0
antdow
Asked:
antdow
2 Solutions
 
Anthony PerkinsCommented:
See this link here:

XPSMTP.DLL - SQL Server SMTP Mail XP
http://www.sqldev.net/xp/xpsmtp.htm
0
 
Atlanta_MikeCommented:
I've been doing it like this for years...

http://www.sqlteam.com/item.asp?ItemID=5003
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now