January 12, 2012 at 10:41 am
We are moving from sql 2000 to sql 2008 and I am in the process of configuring database mail. I have the operators set up and successful tested. When I run the function with a full email address it works fine. I am running into a problem when I am typing in 'Joe Smith' as a recipient. In sendmail this would send to jsmith@xyz.com. When I put this in database mail it give me a recipient must be specified error. If I put in jsmith@xyz.com it goes through fine. Is it not possible to do this anymore or is there a setting I am missing some where. One side note, the email I am trying to send to is not set up in an operator. Thanks for your help.
Jason
*This doesn't work
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'IT Department',
@recipients = 'Joe Smith',
@subject = 'Test Message',
@body = '',
@body_format= 'HTML'
*This works just fine
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'IT Department',
@recipients = 'Jsmith@xyz.com',
@subject = 'Test Message',
@body = '',
@body_format= 'HTML'
January 12, 2012 at 10:49 am
An exchange server will do a lookup for you to determine that "Joe Smith" is actually j.smith@somedomain.com.
a regualr SMTP server does not do that, it requires a valid email address instead. dbmail uses the SMTP protocol, which is what you are hitting up against.
I'm not sure if an IMAP connection would do the lookup you are trying to do (but dbmail does not use IMAP)
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply