sp_send_dbmail with multiple reply_to addresses 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 = 'hi@sg.com',
@subject = 'PO delivery dates confirmation',
@body = 'test',
@body_format = 'HTML',
@importance = 'Normal',
@reply_to = '2@sg.com;3@sg.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?
@reply_to can only accept 1 email address. Its by design - see this connect.

The document reflects that as well.


  [ @reply_to= ] 'reply_to'
  Is the value of the 'reply to address' of the email message. It accepts only one email address as a valid value. This is an optional parameter used to override the settings in the mail profile. This parameter is of type varchar(MAX). SMTP secuirty settings determine if these overrides are accepted. If no parameter is specified, the default is NULL.