Closed
Solved
Outlook and Excel
How to get data from worksheet in excel and put that data in the body of outlook in table format
You will need to use the Microsoft Office Connectors. First review the documentation on the Excel Connector: https://help.roboticautomation.pega.com/80/Components/Microsoft_Excel.htm. Then review the outlook documentation: https://help.roboticautomation.pega.com/80/Components/How_to_use_the_Email_Component.htm and I will also point out that Outlook supports HTML bodies and it can be setup as described in this pdn post:
https://collaborate.pega.com/question/sendread-html-data-body-outlook-mail
Then design your automation to pass the excel data as a html table to the body of the outlook email. It may be easier to format the data to a html table in a c# script.
Accepted Solution
I have resolved that through scripts,
Question Solved
Question
Question
Discussion
Question
Question
Question
Question
Question
Question Solved
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.