Variation 1: Basic Email Bursting

SELECT Vendor_id AS "KEY",
       'DefaultInvoiceReport.rtf' TEMPLATE,           -- Fusion Report template name
       'en-US' LOCALE,                                -- Locale
       'PDF' OUTPUT_FORMAT,                            -- Output format (PDF, RTF, etc.)
       VENDOR_NAME OUTPUT_NAME,                        -- Output file name
       'EMAIL' DEL_CHANNEL,                            -- Delivery channel
       'to@vendor.com' PARAMETER1,                     -- To Email address
       'cc@vendor.com' PARAMETER2,                     -- CC Email address
       'from@company.com' PARAMETER3,                 -- From Email address
       'Invoice Subject' PARAMETER4,                  -- Email Subject
       'Dear Vendor, please find attached invoice.' PARAMETER5, -- Email Body
       'TRUE' PARAMETER6,                              -- Attachment value ('true' attaches the PDF)
       'replyto@company.com' PARAMETER7,             -- Reply-To
       NULL PARAMETER8                                 -- BCC (optional)
FROM VENDORS;

Variation 2: Split By Department, Deliver By Manager

SELECT Department_ID AS "KEY",
       'DeptInvoiceReport.rtf' TEMPLATE,
       'en-US' LOCALE,
       'PDF' OUTPUT_FORMAT,
       'Dept_' || Department_ID OUTPUT_NAME,
       'EMAIL' DEL_CHANNEL,
       Manager_Email PARAMETER1,                      -- To Email address
       NULL PARAMETER2,                               -- CC Email address
       'from@company.com' PARAMETER3,                -- From Email address
       'Department Invoice' PARAMETER4,             -- Email Subject
       'Please find your department invoices.' PARAMETER5, -- Email Body
       'TRUE' PARAMETER6,                             -- Attachment
       NULL PARAMETER7,                               -- Reply-To
       NULL PARAMETER8                                 -- BCC
FROM Departments;

Variation 3: Save Output Disabled

SELECT Employee_ID AS "KEY",
       'PayslipReport.rtf' TEMPLATE,
       'en-US' LOCALE,
       'PDF' OUTPUT_FORMAT,
       Employee_Name OUTPUT_NAME,
       'EMAIL' DEL_CHANNEL,
       Employee_Email PARAMETER1,                     -- To Email address
       NULL PARAMETER2,                               -- CC Email address
       'payroll@company.com' PARAMETER3,             -- From Email address
       'Your Payslip' PARAMETER4,                    -- Email Subject
       'Please find attached your payslip.' PARAMETER5, -- Email Body
       'TRUE' PARAMETER6,                             -- Attachment
       NULL PARAMETER7,                               -- Reply-To
       NULL PARAMETER8,                               -- BCC
       'FALSE' SAVE_OUTPUT                            -- Do not save output in report history
FROM Employees;