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 5 - Prescheduled Queue

Description

You can define a queue and a schedule, so then you can use the @queue parameter to add messages to this pre-scheduled queue.

In this example, we setup a queue called HalfHour that runs every 30 minutes. When you click the Run Demo 5 button, a message is added to this queue. When the queue is processed, all messages queued for a particular recipient are consolidate into one message and sent out.

We recommend that you click the Run Demo 5 button a couple of times in order to add more than one message to the queue, so you can observe how SqlAnswersMail consolidates multiple messages into one email.

Email
SQL Code
exec sp_sendSAM
@recipients=provided in form,
@message='<p>This is a demo message that was added to the
<i>HalfHour</i> queue</p><p>For more information
visit <a
href="http://www.sqlanswers.com">SqlAnswers.com</p>'
,
@format='html',
@queue='HalfHour'
               

Free Trial of SqlAnswersMail