VinicioAizpurua (6/3/2010)
Nice solution regardless the comment why to do it with SQL. It is all depends on you organization and the resources you have in your hands. Sometimes you have to deal with certain resources and that all you have. In other hand about the solution presented, it would be nice to present how did you confiugured the SQL mail profile in terms SMPT relay. By adding this you will have a complete solution for those that would be in the same situation for sending massive mails. About the answer about the creatio of mailing list, once again it is all depend on who owns the process and the data. Same comment about .Net solution. You will need to have the data available somewhere. In other words, this is a solution presented for database administrators/developers. I am considered included in this last group and that's why I see this is a viable solution.Best regads
Vinicio Aizpurua
Miami, FL
it's good security policy to limit who can send SMTP traffic outside the organization to one server. i've seen where people would set up unofficial wifi access points with no security and connect them to the company LAN. Spammers pick up on this and start sending millions of emails via the wifi and people's local SMTP server installations that are unprotected. developers are notorious for doing this. next thing you know your organization ends up on a lot of the email blacklists and other organizations start to reject your emails.