Link to home
Start Free TrialLog in
Avatar of canuckconsulting
canuckconsultingFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Embed SSRS report in body of SMTP Email

We have an .Net application which connects with SQL Server 2012 Standard SSRS to generate a report in Word format.  It then emails this document as an attachment to the user using  System.Net.Mail.SmtpClient.

What we need to do is instead have this report set as the body of the email.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of canuckconsulting

ASKER

I tried that some time ago Eric but struggled with the supported MHTML format that SSRS supports.  I wasn't able to set this to MailMessage.body and have it work.  What did you do to get it to work?
I never tried with a SSRS generated report but with a real Word document. I have used Aspose Words (http://www.aspose.com/products/words/net) to transform my .docx into a HTML document.
Got it.  So my focus should be getting the report into HTML and then using that.
This worked great  Note to get the output in HTML (not MHTML) the Reporting ServicesRsReportServer.config file needs to be updated to support HTML4.0.

Thanks!