Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP: email file path as a hyperlink in outlook body sam Excel Programming 9 November 3rd 09 09:46 PM
Display File path as hyperlink in outlook sam Excel Programming 2 November 2nd 09 10:26 PM
How to link to an Excel file when sending an email in Outlook? BFree Excel Discussion (Misc queries) 2 May 1st 06 11:43 AM
Outlook email url in body kevinho[_3_] Excel Programming 2 August 26th 05 12:48 PM
Late Binding to Outlook from Excel: Outlook modifies email body Lenny Wintfeld Excel Programming 0 December 12th 04 04:03 PM


All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"