Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-12 : 08:53:01
|
| Tracey writes "Is it possible to change the 'from' (Sql Agent) via code? I have currently changed it from Sql Agent to Sales Department but depending on who the message is directed to, I'd like to customize it.For example, I'd like some messages with a Marketing 'from' and some some with an Accounting 'from' etc...It seems like I can only have one 'from'value?Any feedback will be appreciated!" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-15 : 20:27:20
|
| I think the FROM is based on the MAPI profile you are using. However, you could do something like this if you were to use another email routine such as CDO instead of xp_sendmail. Here is an article and comments that talk about other email options....[url]http://www.sqlteam.com/item.asp?ItemID=5908[/url] or [url]http://www.sqlteam.com/item.asp?ItemID=5003[/url]------------------------GENERAL-ly speaking... |
 |
|
|
|
|
|
xp_sendmail