HomeSoftwareServicesForumsLinksContact us
Overview  |  Download  |  Online Demo  |  Licensing  |  Release Notes
  SqlAnswersMail - Online Demo

Demo 1 - Email HTML | Demo 2 - Email PDF | Demo 3 - SQL to PDF | Demo 4 - Embedded Queries
Demo 5 - Prescheduled Queue | Demo 6 - Dynamic Queue | Demo 7 - Zip & Password-Protect
Demo 8 - Mail Merge | Demo 9 - Content Path | Demo 10 - Excel Workbook | Demo 11 - Word/RTF

Demo 2 - Sending results in PDF format.

Description This demo emails a resultset in PDF format. Notice the use of the @sizetocontent parameter that forces the paper size to extend to fit all the content without line breaks. PDF documents are compressed using an industry-standard Flate compression, which makes it a perfect option for sending large resultsets. To run the demo, please provide an email address to send the results to and click on the Run Demo 2 button.
Email
SQL Code
exec sp_SendSAM
     @subject='Demo email from SqlAnswersMail',
     @recipients=provided in form,
     @message='This is a demo email message from
               SqlAnswersMail. The results are generated
               in PDF format. Notice how you can size paper
               to content, so even information from a "wide"
               table such as Northwind.Orders can be presented
               in a neat PDF report. For more information
               please visit www.sqlanswers.com.'
,
     @attachment_format='PDF',
     @attach_results='true',
     @pdf_definition='//doc/@sizetocontent=1',
     @query='select * from Northwind..Orders
               /*<title>Northwind Orders</title>*/'

               

Free Trial of SqlAnswersMail