Link to home
Start Free TrialLog in
Avatar of Jim Horn
Jim HornFlag for United States of America

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.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.
Jim
ASKER CERTIFIED SOLUTION
Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jim Horn

ASKER

Sounds like a plan, I'll ask the client to create a group for me.  
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