Hyperlinks not displaying in email

Help StudioX
, , ,
1

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.
2

@AA_queen427,

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

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

@AA_queen427

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

Cheers

4

Hi @AA_queen427

Give the links direclty do not use the formula

A spreadsheet shows a hyperlink in cell C2, created using the formula =HYPERLINK(B2,A2), with cell B2 containing "www.google.com" and cell A2 containing "AB." (Captioned by AI)
A spreadsheet shows a hyperlink in cell C2, created using the formula =HYPERLINK(B2,A2), with cell B2 containing "www.google.com" and cell A2 containing "AB." (Captioned by AI)672×256 8.5 KB

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
A table with three columns containing the text "AB" in bold in the first and third columns, and a hyperlink to "www.google.com" in the middle column. (Captioned by AI)
A table with three columns containing the text "AB" in bold in the first and third columns, and a hyperlink to "www.google.com" in the middle column. (Captioned by AI)781×183 3.73 KB

Hope this helps :slight_smile:

8

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:

image
image665×100 4.92 KB

9

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

image

10

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

11

@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

12

@AA_queen427,

Here you go a sample code:

The image depicts a workflow for automating the process of reading data from an Excel file, formatting it into an HTML table, and sending it via an Outlook email. (Captioned by AI)
The image depicts a workflow for automating the process of reading data from an Excel file, formatting it into an HTML table, and sending it via an Outlook email. (Captioned by AI)920×1028 55.2 KB

Input File:

The image shows a spreadsheet with columns for ID, Link, Title, Contact Name, Status, and Priority containing four rows of data. (Captioned by AI)
The image shows a spreadsheet with columns for ID, Link, Title, Contact Name, Status, and Priority containing four rows of data. (Captioned by AI)937×230 16.8 KB

Output Email:

This image shows an email from Ashok Karale to his team containing a table of sample data with ID, link, title, contact name, status, and priority columns. (Captioned by AI)
This image shows an email from Ashok Karale to his team containing a table of sample data with ID, link, title, contact name, status, and priority columns. (Captioned by AI)1592×936 45.5 KB

Code:
SendHTMLBodyEmail.zip (172.4 KB)