Jim Horn
asked on
SSIS Send Mail Task, ToLine, Help says deliminate emails with semi-colon ( ; ) but am getting error message
Hi All
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. me@you.com; jack@foo.com; barternder@lounge.com) 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.SmtpFailed RecipientE xception: 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.
Jim
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. me@you.com; jack@foo.com; barternder@lounge.com) 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.SmtpFailed
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.
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This would be lower mainenance anyways, as when group members change it's an Exchange/Outlook task and not a SSIS package edit/deploy task.
Thanks for the workaround.
Jim