Display File path as hyperlink in outlook

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
 
B

Barb Reinhardt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top