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 - 2001-06-03 : 13:36:02
|
Stretz writes "Thank you for your article on SQL Mail. It was very helpful and I was able to implement database email processing very quickly. http://www.sqlteam.com/item.asp?ItemID=401
However, I am stumbling with trying to get the @originator_address to give me the SMTP address of the sender. It will only give this if the email originates from a sender outside of our Exchange server. For all mail originating from our Exchange server, @originator_address returns the Exchange (Ex:) address, not the SMTP address.
Is there a way to have it always return the SMTP address?
I am using SQL Server 7.0 and Exchange 5.5 w/ SP4 on separate servers. The email client for SQL Mail is Outlook 2000 SR1.
Thank you for your help,
Stretz" |
|
|
|
|
|
How to get SMTP address with xp_readmail?