Passing Malformed email address to Send Mail Task

• SQLSeTTeR

  SSCertifiable

  Points: 5481

  More actions

  February 5, 2015 at 2:10 pm

  #300860

  Hello all. I am implementing a fax solution (Right Fax) and pulling email information from a table and passing into a variable. In order to send out a fax via email, the syntax is in the following example below:

  Example:

  To send a fax from Outlook to Jane Doe at 555-1212, enter:

  [RFAX:Jane Doe@/FN=555-1212]

  When the following syntax gets passed into the Send Mail Task, into the "To" line and the package is executed I'm receiving the following.

  [Send Mail Task] Error: An error occurred with the following error message: "The specified string is not in the form required for an e-mail address.".

  [Send Mail Task] Warning: The address in the "To" line is malformed. It is either missing the "@" symbol or is not valid.

  I realize its a malformed email address. Does anyone know of any work-around? Is it possible to create a group and instead of the fax syntax pass the group name? Or alias the name somehow? Any input is much appreciated.

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  February 5, 2015 at 3:40 pm

  #1775912

  This is a duplicate post. Active thread can be found here:

  http://www.sqlservercentral.com/Forums/Topic1658159-3412-1.aspx

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001