Post reply

Mailed reports strange behaviour quotation marks in mail address

  • December 24, 2014 at 2:23 am

    #293854

    We have an application that uses SSRS to send mail. But the format of the mail address changes somehow.

    The format when passed on to SSRS is "Nescio, Nomen" nomen.nescio@noreply.com but when the mail is sent it is changed into "Nescio, Nomen nomen.nescio"@noreply.com. So the quotation mark is moved backwards and the mail is not received. If we send it just to nomen.nescio@noreply.com it's ok.

    I can send mail from my own outlook to "Nescio, Nomen" nomen.nescio@noreply.com just fine.

    So somewhere along the line either SSRS passes it incorrectly to SMTP or SMTP changes the mail address.

    Any ideas?

  • December 24, 2014 at 6:28 am

    #1766324

    i'm under the impression that the email is supposed to be bracketed, and semi colon delimited when multiple addresses are involved, like this:

    "Nescio, Nomen" <nomen.nescio@noreply.com>;"The SQL Administrator" <admin@noreply.com>;

    I'm guessing that it gets passed as your string, and some parser does it'ts best guess and sends it anyway, but i think if you format it above, you get just an alias in the email From

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 24, 2014 at 6:57 am

    #1766329

    In the meantime we have found out with wireshark that the address is sent to SMTP correctly so with the quotation mark after Nomen: "Nescio, Nomen" nomen.nescio@noreply.com. Apparently the SMTP mail address validation rules decide it's better to put everything before the @ in quotation marks?

    All google searches turn up with nothing. We are using this same software in various other situations without any such problem. We have no access to the SMTP server but have raised the question at the representatives.

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

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