canuckconsulting
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.
What we need to do is instead have this report set as the body of the email.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
Got it. So my focus should be getting the report into HTML and then using that.
ASKER
This worked great Note to get the output in HTML (not MHTML) the Reporting ServicesRsReportServer.con fig file needs to be updated to support HTML4.0.
Thanks!
Thanks!
ASKER