Including an Hyperlink on email

Hi everyone,
I have put together a macro that will launch the Outlook and copy some of the data on my excel sheet.
I am struggling with the Hyperlink though. It does not seem to bring the hyperlink on the Outlook message.
Can you help me? Thanks.

Cell C3 = the link
Cell C4 = Friendly name

Cell C8= Friendly name with hyperlink.

I've attached my sample spreadsheet.
And this is my code, hope someone could have a look please?

Please Login or Register  to view this content.

Appreciate any help, thanks again