How to scrape hypertext from web and paste it in mail body with hyper link, so that clicking on text will open desire web page?

Hello All,

Can you give any suggestion about the scenario given below?

Scenario:

  1. Scraping data from web where one text field contain hyperlink

  2. Will scrape data and save in a CSV/Excel file with the hypertext contain the hyperlink( if the text is clicked then the desire page will open)

  3. Paste the hypertext in mail body so that if someone click on the text the desire page will open

Please give suggestion, Requirement of point 3 is urgent!! Thank you in advance!!

hi @PraloyMisra
in mailbody, paste link as below format and check isHtml property.
<a href="YourLink"> YourLink</a>

Thank you [Mr.StarLord_AO],
This is one way, but the problem is I need to scrape the url too from web and for each item have to manipulate the HTML link and then have to append in mail body. I was thinking about any easy solution for this?
And How to add hyperlink if we save in excel?
Appreciate your cooperation!!
–Praloy Misra

@PraloyMisra,

Collect all the links in data table, and add this in mailbody, paste link as below format and check isHtml property.
<a href="YourLink"> YourLink</a> as @Mr.StarLord_AO said as it looks like

<a href="YourLink1"> YourLink1</a>
<a href="YourLink2"> YourLink2</a>

I guess this will work.