Display File path as hyperlink in outlook

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

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 address 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
 
Back
Top