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 7 - Zip & Password-Protect

Description

SqlAnswersMail supports zip compression. You can specify whether you want to zip each file individually or combine all the files into a single attachment. You can also specify an extension to be used instead of .ZIP for cases when a mail server blocks zip files, and you can protect your zip files with a password.

In this example, SqlAnswersMail will send a zipped attachment with an extension and a password provided. If the password field is left blank, then the zip file will not be password-protected.

Email
Extension
Password
 
SQL Code
exec sp_sendSAM
@recipients=provided in form,
@subject='SqlAnswersMail - Compressed Attachment Demo',
@message='Attached is a compressed text file generated by SqlAnswersMail. For more information visit www.sqlanswers.com',
@zip_attachments='true',
@attach_results='true',
@query='select top 20 * from northwind..customers',
@zip_definition='//file/@extension=provided in form;//file/@password=provided in form'
               

Free Trial of SqlAnswersMail