Add unique hyperlink to outlook email based on sender


I am trying to add a unique hyperlink based on the email receiver for sending through outlook. The receivers and hyperlinks are in an excel file. I am stuck on how to do this so any help is appreciated!


If you need to send for all…

Then read the data into datatable and use for each row in datatable which will loop through each row

Then use send email inside loop… with to as currentrow("email").Tostring and hyperlink value as currentrow("link").ToString

Else if you want for any specific persons ased on some input then usw filter datatable activity and filter on the column email and get the hyperlink

Filter “email” = “emailyouwanttofilter”

Dt.Rows(0)(“link”).ToString will give you the link