Question
2
Replies
266
Views
Posted: June 26, 2017
Last activity: August 30, 2017
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: http://help.openspan.com/80/Components/Microsoft_Excel.htm. Then review the outlook documentation: http://help.openspan.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://pdn.pega.com/community/product-support/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.