Question: In VS 2008 / SSIS, Send Mail task, in the ToLine how to you separate multiple email addresses?
When I enter multiple emails delimeted by semi-colons (e.g. firstname.lastname@example.org; email@example.com; firstname.lastname@example.org) I get the following warning:
The Address in the "To" line is malformed. It is either missing the "@" symbol or is not valid.
... and when I run it it returns this error message:
[Send Mail Task] Error: An error occurred with the following error message: "Unable to send to all recipients. System.Net.Mail.SmtpFailedRecipientException: Mailbox name not allowed. The server response was: sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1)".
BOL 'Send Mail Task Editor (Main Page)' says it is delimeted by semicolons, but that's not working.
I've tested this with a single email address and it works fine.
Thanks in advance.