Thanks for the insight guys; I'm still hoping for some more suggestions.

My non profit wouldn't even spend the five dollars per mailing, but would love for me to invest hundreds of man hours to make it easier for them.

That's why I was asking; Normally I'd lean towards creating an app to do it, and have the app contain all my logic, and use an existing WYSIWYG editor for the end user to make a "pretty" email.

But this is one of those undefined goals, where no-one knows what they want, so any application i make would have my personal flavor on it, and would then be criticized and caught in feature creep forever. I don't like getting painted into a cornerl with undefined goals.

If I knew of something off the shelf that was peer approved or recommended, i'd throw that into the mix to extract me from doing all the work.

a classic example: I get an email at 8pm at night, telling me in general "we want to say something about X" and ask for volunteers at our upcoming 5 K run.

They want it to go out @7am the next morning, so I'm up all night fiddling with content, and then scripting everything out to do it in sp_send_dbmail.

I need them to have the ability to make the content and essentially test it on a select group, and then to teh full list.

.