Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Links: Re-establishing Links | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |