ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display file path as hyper link in outlook email body (https://www.excelbanter.com/excel-programming/435976-display-file-path-hyper-link-outlook-email-body.html)

Sam

Display file path as hyper link in outlook email body
 
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

Ron de Bruin

Display file path as hyper link in outlook email body
 
Have you try this

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

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


--

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


"sam" wrote in message ...
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



All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com