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 = "(E-Mail Removed)"
.CC = ""
.BCC = ""
.Subject = "Hyperlink test "
.Body = "Hyperlink: " & "C:\Documents" & Me.FileName.Value

..Send


Thanks in advance

Hi Sam

Please stay in your original thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"sam" <(E-Mail Removed)> wrote in message newsFAF7F31-5EC5-4CEA-8510-(E-Mail Removed)...
> 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 = "(E-Mail Removed)"
> .CC = ""
> .BCC = ""
> .Subject = "Hyperlink test "
> .Body = "Hyperlink: " & "C:\Documents" & Me.FileName.Value
>
> .Send
>
>
> Thanks in advance

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 = "(E-Mail Removed)"
> .CC = ""
> .BCC = ""
> .Subject = "Hyperlink test "
> .Body = "Hyperlink: " & "C:\Documents" & Me.FileName.Value
>
> .Send
>
>
> Thanks in advance