SendEmail Script Examples: Difference between revisions
Jump to navigation
Jump to search
(306899) |
No edit summary |
||
| Line 1: | Line 1: | ||
This page contains script examples for the [[ | This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23SendEmail|SendEmail]] script command. | ||
The following example will send an e-mail message with two attachments to multiple recipients. | The following example will send an e-mail message with two attachments to multiple recipients. | ||
Revision as of 07:43, 7 February 2018
This page contains script examples for the SendEmail script command.
The following example will send an e-mail message with two attachments to multiple recipients.
(SELECT 'EmailFrom', 'example.from@address.com') UNION ALL (SELECT 'EmailTo', 'recipient.one@address.com,recipient.two@address.com,recipient.three@address.com') UNION ALL (SELECT 'EmailSubject', 'Example E-mail') UNION ALL (SELECT 'EmailBody', 'QPR ProcessAnalyzer example script started running.') UNION ALL (SELECT ''EmailAttachmentQuery', 'SELECT * from #EmailAttachmentParameters') UNION ALL (SELECT 'SmtpServer', 'localhost') --#SendEmail
Where the #EmailAttachmentParameters table contains following data:
| Name | Content | Media type | Creation time |
|---|---|---|---|
| Example attachment picture | Picture.jpg | image/jpg | 2016-04-22 12:00:00 |
| Example attachment xml file | Example.xml | text/xml | 2016-04-22 12:00:01 |