0

I am attempting to send an email to a text message number using the sp_send_dbmail stored procedure in SQL Server (both 2008 R2 and 2016 give the same results). Even if I send a test email from the server test tool, the body of the email is not sent in the text. If I send the same test to a normal email address, the body displays correctly. How do I get the body to display in the text message?

Test Email

Resulting Text

Brian Swart
  • 922
  • 1
  • 9
  • 25
  • SQL Server doesn't natively send text messages, and emails don't get sent to a mobile natively if you put a mobile number instead of an email address; email and SMS are 2 different technologies. I think the problem is not SQL Server, but what ever you are using to convert an email to be sent as an SMS. – Thom A Apr 24 '18 at 18:47
  • We're using Exchange 2016 to process the email. I would think Exchange is able to handle it correctly if it can send it to an email address correctly. I also tried sending an email from my email address to my phone through outlook and it worked. – Brian Swart Apr 24 '18 at 18:49

0 Answers0