Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display File path as hyperlink in outlook
How can I display file path as hyperlink in outlook body?
I have a userform that saves the userinputs in a new excel file at location "C:\My Documents\User Files" when user clicks "Submit" I want to email the users with the path of the file as a hyperlink, so user can click on the link in the email body and navigate to that file. Here is what I have so far. But i guess the spaces between the folder names and file name is an issue to get it work as link With OutMail .to = " .CC = "" .BCC = "" .Subject = "Hyperlink test " .Body = "Hyperlink: " & "C:\Documents" & Me.FileName.Value ..Send Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display File path as hyperlink in outlook
Hi Sam
Please stay in your original thread -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "sam" wrote in message ... How can I display file path as hyperlink in outlook body? I have a userform that saves the userinputs in a new excel file at location "C:\My Documents\User Files" when user clicks "Submit" I want to email the users with the path of the file as a hyperlink, so user can click on the link in the email body and navigate to that file. Here is what I have so far. But i guess the spaces between the folder names and file name is an issue to get it work as link With OutMail .to = " .CC = "" .BCC = "" .Subject = "Hyperlink test " .Body = "Hyperlink: " & "C:\Documents" & Me.FileName.Value .Send Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display File path as hyperlink in outlook
Again, you'll have to enter the html to get the hyperlink. Once you figure
it out for the other question, this will be answered as well. HTH, Barb Reinhardt "sam" wrote: How can I display file path as hyperlink in outlook body? I have a userform that saves the userinputs in a new excel file at location "C:\My Documents\User Files" when user clicks "Submit" I want to email the users with the path of the file as a hyperlink, so user can click on the link in the email body and navigate to that file. Here is what I have so far. But i guess the spaces between the folder names and file name is an issue to get it work as link With OutMail .to = " .CC = "" .BCC = "" .Subject = "Hyperlink test " .Body = "Hyperlink: " & "C:\Documents" & Me.FileName.Value .Send Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP: email file path as a hyperlink in outlook body | Excel Programming | |||
Hyperlink in cell to path/file name | Excel Programming | |||
Hyperlink to File name and path VBA Excel | Excel Discussion (Misc queries) | |||
How to I display the full path of an hyperlink in MS Excel 2000? | Excel Discussion (Misc queries) | |||
How do I display the full file path for a hyperlink in Office 2003 | Excel Discussion (Misc queries) |