Database Mail

I'm keen to use database Mail in SQL 2005. It seems to work well and save's me having to implement a queue, audit logging for sent/errored etc, as SQL2005 can take care of all of that for me.

heres the but..

Is there any way to specify the "From" email address in sp_send_dbmail I know you specify it as part of email account & profile but I want to override that.

I just wanted to be able to keep an audit of all the emails that where sent from an asp.net website and thought i could get that functionality "out of the box" with SQL 2005 and DB Mail, but with out being able to set the from: address its not going to work

Any one have a sugesstion?

Thanks

If you really need this functionality, you can create a profile named aspnet and you can attach one account to this. but doing this you will not have the failover functinality of Databasemail. but you will have all the other features of database mail