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

Similar Threads

Display File path as hyperlink in outlook 2
HELP: email file path as a hyperlink in outlook body 9
HELP with .HTMLBody: Display Hpyerlink in email body 8
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Hyperlink in Email Body 6
hyperlink in body of Email 7
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Email a file as an attachment in Outlook 2000 using Excel VB macro 11

Top