ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Links in VBA (https://www.excelbanter.com/excel-discussion-misc-queries/239764-re-links-vba.html)

Chadersmith

Links in VBA
 
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,

Luke M

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,


Chadersmith

Links in VBA
 
Thanks Luke,

"Luke M" wrote:

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,



All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com