JediSQL (9/24/2013)
A major problem with dbmail is that you cannot specify the From address at run time; you have to set up a different profile for every From address you want to use.
Since this is a 2005 forum I'll assume that this is actually a 2005 server we are talking about so you are correct, @from_address was added as a parameter to sp_send_dbmail in 2008.
Still I would consider this an annoyance, not a major problem since there is a workaround. Especially in comparison to the sever error that is being caused by using sp_OA* in this case. So I would still recommend using sp_send_dbmail over sp_OA*
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question