Display file path as hyper link in outlook email body

S

sam

How can I display this as hyper link in my email body?

"c:\My Documents\" & Me.FileName.value

I am not able to display the whole thing as a link as there are spaces between
"My" and "Documents"

I have posted this earlier and they suggested me to user html body, But can
someone point where to find info on html body?

Note: "c:\My Documents\" & Me.FileName.value - is a location where the file
is saved with the "FileName.value" field that is on the userform.

THanks in advance
 
R

Ron de Bruin

Have you try this

.Body = "file://Yourcomputer/YourFolder/Week2.xls"

If there are spaces use %20
.Body = "file://Yourcomputer/YourFolder/Week%202.xls"
 

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