Convert string data type to Hyperlink in HTML email

[Sck]

I have an Access database the creates an email with HTML formatting with body of the email populated based on a query result. One of the results is a text string that is a link to a specific location on a server. in the email that is created, i want the path/link to be a hyperlink so the receiver can just click on it. I dont have ability/rights to change the field type in the table so that is not an option. below are the parts of the code that i am tying to use.

Dim SEvd as string
Dim hyp As Hyperlink

SEvd = rst!SEvidence
Set hyp = "#" & rst!SEvidence & "#"

EMAIL BODY HTML section for hyperlink
Review Folder: <b><a href = " & hyp.Address & ">" & SEvd & "</a>" & "</b>. <br><br>" & _



it is erroring out on the Set statement with Object Required error

rst!SEvidence contains something like \\xacv\testeval\mg\ as the string.

I understand why but i dont know how to "fix" it.

any help is appreciated

[orange]

You may get some assistance from this article/sample.

[Micron]

SET is for objects only so the message is saying you haven't created one. Hyperlink is a property of string data type.
Dim your variable as a string and make it = the string.
Do follow the link as it looks like good info (you'll also see that a string variable is used for the hyperlink).