Thread: Links in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Links in VBA

One possible way is to have the text written begin with "File:\\" as in:

<File:\\C:\My Documents\Test file.xls

Writing this into the body of an outlook message auto-creates a hyperlink.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Chadersmith" wrote:

Hi Guys,

I have been writing a macro where I have outlook sending an email. In the
body of the email I want to enter a network path link but I have not been
able to figure out how to have the text come up as a link. Any help is
appreciated.

Thanks,