Hyperlinks not displaying in email

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.

@AA_queen427,

While preparing html email body put your link in this tag.

<a href="https://forum.uipath.com">Click here</a>

@AA_queen427

After reading data or in excel directly ass the anchor tag around the link

Cheers

Hi @AA_queen427

Give the links direclty do not use the formula


It works if you give the link direclty & not use the formula as you can see i tried, we got the link direclty but when i use hyperlink formula on AB it did not appear

Hope this helps :slight_smile:

Hi. My excel table looks like below and in excel, column 2 shows the hyperlinks. In the email, they are not hyperlinks. The email just shows as regular text string. The data in the excel table is pulled from a webpage and will change every time the data is pulled using the automation. Is there a way to get the excel links in Column 2 to show as hyperlinks in the email without having to manually adjust it?

Excel showing link as hyperlink:

This is what it looks like in the email with no hyperlink.

image

I tried this before and it displayed in the email with the anchors written out instead of showing as hyperlink, i.e.

@AA_queen427

After reading the datatable

Use like below in assign

Dt.Columns("ColumnName").Expression = "'<a href""=' + [ColumnName] + '"">Click</a>'"

then convert to html table

cheers

@AA_queen427,

Here you go a sample code:

Input File:

Output Email:

Code:
SendHTMLBodyEmail.zip (172.4 KB)