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, |
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, |
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