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 |
|
Jaheel220
Starting Member
3 Posts |
 Posted - 2005-12-15 : 16:34:35
|
| exec master.dbo.xp_startmail 'Profile2'exec master.dbo.xp_sendmail @recipients='abc@dream.com', @subject='Test 2', @message='Hello 2'exec master.dbo.xp_stopmailI execute the above code in Query analyzer. It says mail sent.But Microsoft Outlook 2003 does not forward/send that mail. It gives error message "This message has not been sent". On the other hand, Outlook sends and recievs emails if I type those emails in Outlook. In other words, it works fine on its own but does not send emails originated from SQL Server agent.I guess there is something in Outlook to be checked or configured etc but i'm aware of that yet.Any help would be apprecitated. |
|
|
activecrypt
Posting Yak Master
165 Posts |
|
|
|
|
|
SQL Mail with Microsoft Outlook 2003