Closed
Create Excel File and Attached to Email
Hi , is there any method we could create excel file and attach to the email?
***Edited by Moderator Marije to add Capability tags***
Posted: 2 years ago
Infosys Limited
Infosys Limited
IN
Please try to explore the scheduled reports which would suffice your requirement.
https://docs-previous.pega.com/reporting/87/scheduling-reports
Posted: 1 year ago
Cognizant
Cognizant
US
@WeiPingT - Once the data is on the pagelist using Report Definition or any other means the same data source needs to be passed to the EmailNotification as "Param.AttachmentPage" page. Below steps could be performed -
Once done use Property-Set method to append the below to the attachment Page -
AttachmentPage.pyAttachments(1).pyName -> "FileName" AttachmentPage.pyAttachments(1).pyType -> "xlsx" AttachmentPage.pyAttachments(1).pyDecode -> "true" AttachmentPage.pyAttachments(1).pyData -> local.filedata