HomeSoftwareServicesForumsLinksContact us
  SqlAnswersMail Release Notes


Version: 3.3.0.0
6/15/2007
Service release. Misc. bug fixes, enhancements.

Download Setup

New Features 
Data-driven @sender_email parameter
It's now possible to use <sql></sql> structure to populate @sender_email parameter with data from the database. It's also possible to use {FieldName} construct when doing a mail-merge from a database query.
No quotes option
Previously, SqlAnswersMail put double-quotes around each field in a CSV attachment. A new parameter has been added, @quote_all, which is TRUE by default. By setting this parameter to FALSE, SqlAnswersMail will only put double-quotes around those fields that require to be surrounded by double-quotes by the CSV specification. 
Sending via a specific mail server
Up to now, it was possible to define two mail servers in the SqlAnswersMail Configuration utility. At run-time, SqlAnswersMail tried to send email via the primary mail server and, if it failed, tried to send email via the secondary mail server. It was suggested that it should be possible to define the mail server via a parameter to the sp_sendSAM call.
 
A new optional parameter, @mail_server, has been added to sp_sendSAM. This parameter is empty by default, so it will not break existing code written around SqlAnswersMail. Prior to using this parameter, it's necessary to set up a Mail Server profile using the SqlAnswersMail Configuration utility. The name of the profile can then be passed in the @mail_server parameter. 
Suppress datetime in a queued email
Previously, when using queuing, each sub-email contained a header with a subject line and a datetime stamp. A new checkbox called Suppress Header has been added to the SqlAnswersMail Configuration, Queuing tab. By switching this textbox to TRUE, you can now suppress headers in queued email. 

 

  No existing issues have been resolved in this release