February 28, 2012 at 9:40 am
Hi, I am using SP_SEND_DBMAIL. It only work with full email address, like 'paul_martin@abcd.com'. It will fail if I use the domain login name 'p_martin' as @RECIPIENTS. Also, in some case, I would like to email a domain user group like '@developers'.
Can anyone help? Thanks!
PS: both 'SQL server' and 'SQL agent' are using domain account as service account .
_______________________________________________________________
February 28, 2012 at 10:45 am
You won't be able to use an alias as sp_send_dbmail uses SMTP to send emails, it doesn't actually connect to exchange. As such you'll need to use the full email address. IF you wish to email a group you will find that the group will also have an SMTP address which you could use. To find this in exchange open up your outlook address book and look at the Email Address tab which will show you the SMTP address.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply