Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 "jdoe@domain.com" 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

1 Answer 1

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

 
discard

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.