This article is contributed. See the original author and article here.

Several days ago, I worked on a service request that our customer got the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using XXX. Exception Message: 1) Exception Information =================== Exception Type: Microsoft.SqlServer.Management.SqlIMail.MailFramework.Exceptions.BaseMailFrameworkException Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.) Data: System.Collections.ListDictionaryInternal TargetSite: Void Send(Microsoft.SqlServer.Management.SqlIMail.MailFramework.Framework.IMessage) HelpLink: NULL Source: DatabaseMailProtocols HResult: -2146232832 StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.MailFramework.Smtp.SmtpMailSender.Send(IMessage msg) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ProfileMailSender.SendMailToAccount(Account a, IMessageSender ms, OutMailItem si) 




 


This error means when is calling the stored procedure sp_send_dbmail (Transact-SQL) – SQL Server | Microsoft Learn the specified string is not in the form required for an e-mail address, for example using or other thing that is not expected. Changing to a correct format our CX was able to send the emails.  


 


Enjoy!


 



Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.