SQL Server Performance

E-Mail delivery comment formatting

Discussion in 'SQL Server Reporting Services' started by skillmaker, Sep 16, 2005.

  1. skillmaker New Member

    Delivery via e-mail works fine. Reports being delivered as Excel attachments to e-mails works great. Now for the nit-picking problems to arise...

    -------------------------
    I entered text into the comments field of the subscription form to be used as the body of the e-mail. The text entered was (exactly):
    -------------------------
    Your monthly report is attached.

    To access more detailed information log on to www.business.com and enter the Clients Only section. Forgot your user name and/or password? Reply to this email and we will provide one for you.

    For questions or comments please email customer.service@business.com or call us toll free at 888-880-9999.

    THANK YOU FOR YOUR BUSINESS!

    -------------------------
    So far, so good, EXCEPT that the recipients get the **following** text as the body of the e-mail:
    -------------------------
    Your monthly report is attached. To access more detailed information log on to www.business.com and enter the Clients Only section. Forgot your user name and/or password? Reply to this email and we will provide one for you. For questions or comments please email customer.service@business.com or call us toll free at 888-880-9999. THANK YOU FOR YOUR BUSINESS!
    -----------------------

    (Note, in above examples, dashed lines have been added for clarification, and are NOT part of the text being used in the comment field). Line feeds disappear and text arrives as one solid paragraph. HELP! What do I need to do to have the comments appear as entered, rather than as a single block of unformatted text?

    I can't seem to find any references to this comment field and it's use in the e-mail body. No documentation. Any real-world experience out there?

    Thanks!

Share This Page