Hyperlink in the vba

[aattas]

I need to know if i can use hyperlink in my auto email body.
this is my code:
.Body = " Task Number:: " & rs!MUAMALANO & vbCr & _
" Expiration Date : " & rs!expirydate & vbCr & _
" Subject : " & rs!SUBJECT & vbCr & _
" The email is auto generated and requires your immediate action on the overdue items shown above, go to TTS for update !"

Either i use the MUAMALANO as the hyper link to a DB or any text.

Any help is highly appreciated

 

[June7]

Have to use .HTMLBody and HTML code tags. Fairly common topic.

.HTMLBody = " Task Number : " & rs!MUAMALANO & vbCr & _
" Expiration Date : " & rs!expirydate & vbCr & _
" Subject : " & rs!SUBJECT & vbCr & _
" The email is auto generated and requires your immediate action on the overdue items shown above, go to TTS for update ! " & _
"<a ref='file path here'>link description here</a>"

 

[aattas]

Wow,
It really works

Thank you thank you thankyou.

Love you!