Inserting a hyperlink into an Outlook mail from Excel

Morning all,

I'm working on a little block of code (slightly simplified below) which generates a number of e-mails from Excel:

Please Login or Register  to view this content.

Which is fine, but I'd like the path to the file to be a hyperlink. In fact I'd really like the words "Test document" to be the hyperlink, pointing to the file in question.

I'm hoping this is really straightforward, I just don't work with Outlook often enough to be familiar with the object model. Can anybody give me a quick fix?

Turns out that one of my team, sitting about 6 feet away from me knew the answer:

Please Login or Register  to view this content.

So I'm sorted now.