Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |