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 11 - Sending RTF/Word attachment
| Description |
This demo emails query results in RTF/Word format. To run the demo, please
provide an email address to send the results to and click on the Run Demo 11
button. |
| Email |
|
| SQL Code |
exec sp_SendSAM @Recipients= provided in form, @Subject= 'Demo email from SqlAnswersMail - Word attachment', @Message='This message contains an RTF/Word attachment generated by SqlAnswersMail from query results. For more information, visit www.sqlanswers.com.', @Query='select top 20 CustomerID, ContactName, ContactTitle, CompanyName from Northwind..Customers /*<title>These are Northwind customers</title>*/;
select EmployeeID, FirstName, LastName, City, Country from Northwind..Employees /*<title>These are Northwind employees</title>*/', @Attach_Results= 'True', @Attachment_Format= 'DOC'
|