locked
Html Layout Problem While Adding Html file to Outlook 2013 RRS feed

  • Question

  • Hi,

    My SSRS report format squashed while sending it to outlook. I used SQL Server Business Intelligence Studio 2012 to develop the SSRS report and Outlook 2013 for mailing. Please find the attached screen shot which I am getting in outlook.

    Thanks in Advance.

    Regards,

    Eins Antony.


    Tuesday, November 4, 2014 2:45 PM

Answers

All replies

  • Is that in a <Table> ?
    Tuesday, November 4, 2014 2:47 PM
  • Hi Patrick,

    Actually I didn't put any table in the report. The report contains only two text boxes, also the report has a border.

    Please see the screen shot of design view of same report:

    Regards,

    Eins Antony

    Wednesday, November 5, 2014 12:58 PM
  • Looking at the output in outlook, the page shrank and squished the box. You should try to set the objects width explicitly. Use the properties window. Also check for properties such as 'Word Wrap' and 'Can Grow'.

    Ideally, you would provide the HTML to outlook, rather than relying on SSRS to generate it.

    Wednesday, November 5, 2014 2:21 PM
  • Hi Enis,

    Did you create the subscription to send the HTML report to email? What is the render format of the report, HTML or MHTML?

    Please also check if you have scrollbar in the email. if you have the issue can relate to the page size much bigger than the body size 

    Thursday, November 6, 2014 10:47 AM
  • Hi Eins Antony,

    According to your description that you have an report which you have created the subscription to send to email, but in the email the report shrink to the left, right?

    The layout issue can be caused by the new version of the Outlook, Outlook 2007 and later version have very limited support for HTML and CSS that is built into Word to display HTML email messages . Basically Outlook 2007  and later version uses MS Word HTML Rendering Engine (Which Makes Web Archive Report Looked Jacked Up) to display an e-mail and will ignores extra space, when MSHTML from Internet Explorer processes the table cell, MSHTML from Internet Explorer displays as much space as possible.

    Note Earlier versions of Microsoft Office Outlook use MSHTML from Internet Explorer to display e-mail, so in the Outlook 2003 you will not have this issue.

    Details information for your reference:
    http://support.microsoft.com/kb/935399
    http://www.sitepoint.com/microsoft-breaks-html-email-rendering-in-outlook/
    Similar thread for your reference:
    https://social.msdn.microsoft.com/Forums/en-US/97e8c12e-f64d-427f-a712-c53e68121f28/column-widths-in-email-sent-as-mthml-web-archive-format

    If you still have any question, please feel free to ask

    Regards
    Vicky Liu

    • Marked as answer by Charlie Liao Wednesday, November 12, 2014 1:58 AM
    Thursday, November 6, 2014 12:59 PM