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 6 - Dynamic Queue
| Description |
Suppose you have a large procedure that sends out a number of notifications to
your Marketing department. The problem is that your end users are annoyed and
confused by so many emails and you wish you could consolidate your
notifications into fewer emails.
With dynamic queuing from SqlAnswersMail, you can queue notifications throughout
the procedure and then at the end of the procedure send out one consolidated
email to each recipient.
When you click the Add To Queue button, three messages are added to a dynamic
queue called SalesReport. When you click the Run Demo 6 button, the queue you
just created is processed.
|
| Email |
|
| Add to queue code |
exec sp_sendSAM
@recipients=provided in form,
@subject='Message 1',
@message='This is message 1 that was added to the SalesReport queue',
@queue='SalesReport'
exec sp_sendSAM
@recipients=provided in form,
@subject='Message 2',
@message='This is message 2 that was added to the SalesReport queue',
@queue='SalesReport'
exec sp_sendSAM
@recipients=provided in form,
@subject='Message 3',
@message='This is message 3 that was added to the SalesReport queue',
@queue='SalesReport'
|
| Email |
|
| Process queue code |
exec sp_sendSAM
@call_mode='RUNQUEUE',
@queue='SalesReport'
|