Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-10-02 : 10:25:11
|
| I've implemented a 100% SQL SP solution for group email. After deployment and first trials, the customer has come up with a reasonable enhancement request. They would like the sender to receive a single email with the Email body containing the list of 'To' names (for tracking purposes).Right now, they're using the capability to email 100s of users, but there will be a time when 1000s of users will be in the to list.I recall that the SQL - SMTP interface has a limit of something like 6,000 characters - too short to accomodate a complete 'To' list of 1000s of email addresses. Is there a way to get around this limitation or should I plan on generating this one email in ASP?My backup plan which I like better than the customer's suggestion - email the sender a URL that will query the email table and return a page containing the to list.Sam |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-02 : 12:14:48
|
| I like your suggestion better as well. The problem is not only that you'll hit the wall with the email body soon, but the only real way to work around it is to include the To's: in an attachment. Yeah, you could use an ASP/.Net email setup, but it needlessly increases email traffic...and what happens when the user deletes the email accidentally? I think you can sell the hyperlink idea very easily by indicating the ease of use and the fact that the records will always be maintained on the database, available any time, and that future enhancements can be far more easily accomplished with it. Cutting down on email traffic may also be a big plus with them. |
 |
|
|
|
|
|
Email 'Text Body' length