Hi. Can someone help me to show hyperlinks within an excel table in an email?
Currently, I have a table in Excel that includes a list of hyperlinks along with other data. When I follow the below steps and send the table in an email, the email shows the links as regular text even though the excel sheet shows the hyperlinks.
Steps in my automation:
- I use Write Cell activity to write =HYPERLINK(“MyURL”) so the links show as hyperlinks in the excel table.
- I format as table, then use Read range activity to read the sheet with the table and save as a variable.
- I use Create HTML Content activity to map the read range variable to a table value and add that value in the email body write up.
- Lastly, I use outlook send mail activity to send an email containing the create html content variable.