Post reply

Passing Malformed email address to Send Mail Task

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply