I got this error when I specified multiple email addresses in reply_to
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 7 (2014-08-19T12:54:35). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.). )
here is the sql snippets
EXEC msdb..sp_send_dbmail @profile_name = 'Company', @recipients = 'email@example.com', @subject = 'PO delivery dates confirmation', @body = 'test', @body_format = 'HTML', @importance = 'Normal', @reply_to = 'firstname.lastname@example.org;email@example.com'
I can't use distribution group because the reply_to is dynamic base on the query. what would be the work around for this?