Excel / Outlook - Hyperlink Problems

[Muttley]

Hi

I am trying to write code that will a) allow a user to save a file (in this case, an Excel Spreadsheet to a common directory and b) Generate an email via Outlook 2000 to interested parties with a hyperlink to the above file location.

I'm having problems with actually making the string show as a hyperlink - can get it to appear on the .body part of the email as text, but no more.

I'm using syntax as follows:
.body = "Blah" & strFileName & "Blah"

Where strFileName = "file://" and the filepath

What am I doing wrong...!!! Please help!!

Thanks!

 

[Klae]

waht is the filepath you are using?

Klae You're only as good as your last answer!

 

[Muttley]

Server\Dir\subdir\subdir\subdir\Refunds200401.xls

So that when the text appears in the body email it looks like: file://Server\Dir\subdir\subdir\subdir\Refunds200401.xls

I've tried removing the "file://" part and enclosing in angled brackets but does not work.

Cheers

 

[Muttley]

Would you believe....just need to send the stupid thing and it appears formatted in the received message.

Doh!

Thanks anyway