Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We just moved from an on premise Exchange server to Office 365's Exchange Online. My question is, is there any way to still get email name resolution from Office 365? I have many stored procedures and SQL Agent jobs where the name is specified instead of the email address, and I'd like to know if I can do something to avoid needing to find and change all of them.

So, can "John Doe" be translated to "" using Sql Server 2008 R2 db_mail and Office 365 Exchange Online, like I could do with the old on premise Exchange?

share|improve this question
Does this article meet your needs?… – Mr.Brownstone May 12 at 3:39
@Mr.Brownstone -Not really, I was able to use it as an SMTP server just fine, the question was regarding name resolution. My answer below is what I ended up doing. – MAW74656 May 13 at 16:04
up vote 0 down vote accepted

The answer seems to be "no, you can't". Thanksfully our email addresses were consistant, so I was able to write a function that transforms the [firstname lastname] or [groupname] into the valid email address. For anyone outside our company, their raw email address can be supplied.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.