Insert Lookup Table into Outlook Email
All,
I have an automation where I would like to insert a lookup table containing a list of File Directories collected earlier in the automation to be pasted into an email.
For example I would like:
------------------------------------------------------------------------------
Hi XXXXX
Please see new files saved in the below locations
<Lookup table>
Folder Path 1
Folder Path 2
Folder Path 3
Thanks
-------------------------------------------------------------------------
Can someone recommend how I would do this / if this is possible? I have a work around which I could do within Excel however I am trying to avoid this solution.
Pegasystems Inc.
US
It really depends on how you want to display the table. An email using the Outlook Connector can display plain text email, HTML email, or rich text format email. Depending on the format is how you'd convert the lookup table (or more accurately, the DataTable inside the lookup table). To get to the DataTable, there is a GetTable method on the lookup table that returns the DataTable. You would probably want to pass this through a C# script to format it as desired. There isn't a connector or anything that would do this formatting for you; it is really a programming task.
Infosys
IN
You have to format the email body in script using c# code and return the string, assign this string value to outlook body and apply email body format as htmlbody.
https://collaborate.pega.com/question/table-display
https://collaborate.pega.com/question/display-variable-value-html-table-format-using-c