Hi!
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!
Hi!
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
Cheers
Cheers