We help IT Professionals succeed at work.

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
Comment
Watch Question

Sr. BI  Developer
Commented:
Well you;re right, even on MSDN it's mentioned as semicolon, but it doesn't work.
http://msdn.microsoft.com/en-us/library/ms142165.aspx

Well because people always send to group e-mail, that's why nobody stressed it out, also as a work around you could use the CC and BCC, or even connect a second send mail task, or even use a script task to send your e-mail !!
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
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