Iam looking to write a code that grabs a link from an excel list and puts it into an email body. the link would change based on who I am sending the email on behalf of. Those I’m sending on behalf of are in Colum A and the links are in Colum G

I have defined as such

‘public SharefileLink as String
‘SharefileLink = Application.WorksheetFunction.XLookup(Sender, Sheets(“LinkList”).Range(“A1:A9000”), Sheets(“LinkList”).Range(“g1:g9000”))

‘strbody = “blah blah blah. &_
”
‘SharefileLink &_ “
”
‘Thank you”

This is showing me the text for link, but it is not a clickable link. I need to send multiple at a time, and I need it to say “upload here”

Because the link changes I cannot use the A Herf, or if I can I can’t figure it out.

Any suggestions?