I have many scenarios for using SQL server to send the mails. None of mine yet have used a batching method since the recipient list is pretty small.

1. Data integrity...

Gift Peddie (5/27/2010)

---

This relates to what I was saying...

Well, that was my point with the purely fixed distribution list on the mailserver. I was...

alen teplitsky (5/27/2010)

---

as a former email admin, why not just let MS Exchange handle the work. create some custom receipients that are hidden from the corporate address book and a...

Cinderella data users!

Oh how I laughed so long I cried.

The actual crying is pretty much done with now. That was almost the entire company when I joined. Every department with...

Aye. There are better things to do with a DB system than use it as a mass mailer and better systems for doing so but sometimes, if you have a...

Ahh, I see where you are going there. If Mcafee was monitoring an email client and an external program tried to connect via the back end of the client then...

One simple way is not to use Mcaffee. Sorry but that's just it.

Besides if it is flagging a plain html email with no attachment as a virus then there is...

Outlook and Notes are clients (not sure if Notes server is called that).

Mine is set to send via MS Exchange though any email server software such as sendmail would do....

Nice article and it made me look back at some stuff I had done a while back and re-jig it to fit in with this.

I took a slightly different take...

The one bit in my script that people might find useful in the one from the article is the conversion from the silly* integers to real dates.

The below is actually...

Nice one. Where was this a couple of weeks ago when I was looking to build a job dashboard.

I actually ended up taking things to bits, breaking it down and...

Jonathan Melo (12/14/2009)

---

I believe that must be a Jeff Moden article,...

Always good to see different ways of approaching things. Will have to have a look at the issue with the single item here and then maybe set up some performance...

Brad Chapman-387295 (12/8/2009)

---

The extension hardening got a little harder trying to name file with xlsx extension.

When I change C# source to have xlsx extension the Excel file will not open....