Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP: email file path as a hyperlink in outlook body | Excel Programming | |||
Display File path as hyperlink in outlook | Excel Programming | |||
How to link to an Excel file when sending an email in Outlook? | Excel Discussion (Misc queries) | |||
Outlook email url in body | Excel Programming | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming |