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_stopmail
I 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.