I appreciated Ron West's followup posting of dynamically setting up email profiles/accounts via TSQL. I was recently questioned on sql05 abilities of producing emails with varible originating names which I know can be done manually.  We have an CRM application and the challenge was to create an email from a triggered activity with the contactee's name in the "from" box.  Rather than manage hundreds of profiles/accounts manually, the "on-the-fly" approach was the better scenario.  Ron's code, with some mods, is just what I'm looking for!

Much Thanks!

Todd Wilson