<div>
<div class="content wysiwyg-content">
Greetings,<br />
<br />
Please could someone kindly provide me with some advice on the best way to achieve the following...<br />
<br />
1 - I need to send the same email to a large number of recipients (several thousand) whose addresses reside in a table<br />
2 - I do NOT have access to SQLSendMail so intend to cycle through a recordset using a DTS script and send via SMTP<br />
3 - I believe that sending mails individually is probably not too efficient so considering adding to a recipient list<br />
4 - If writing a script to add all (comma/semi-colon delimited), I believe it will exceed the maximum number of recipients<br />
5 - If adding them to batches, what would be a suitable number and what is the most efficient code to do this?<br />
6 - Is there anyway of creating an SMTP grouping or distribution list on the fly perhaps or is number 5 better?<br />
<br />
If you have any example code to share, I would be very grateful indeed!<br />
<br />
Many thanks,<br />
Tony
</div>
</div>


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

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.