• We've used a few different things to do the mail, CDO at one point and now looking at Lyris. Ideally you want to abstract yourself from the mail format if you can. We basically build a template, then the template gets some minor (for now anyway) personalization.

    You know, I don't know if we support a text option. I'll send the thread to Brian, he can add more.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/