View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default HELP: email file path as a hyperlink in outlook body

Email format? Is it RTF, HTML, or plain text?

Instead of the Body Property, how about the HTMLBody Property?

..HTMLBody = "<p<a href=" & Chr(34) & "C:\My Documents\" &
Me.FileName.Value & Chr(34) & "My File</a</p"

--JP


On Nov 2, 12:29*pm, sam wrote:
Hi All,

I am trying to send a file path as a hyperlink in outlook once user clicks
"Submit" on an excel userform.

I am able to send the path, but the hyperlinking doesnt work on all of the
path, maybe because of a space in the file name?

Here is what I have so far..

With OutMail
* * * * .to = "
* * * * .CC = ""
* * * * .BCC = ""
* * * * .Subject = "Hyperlink test "
* * * * .Body = "Hyperlink: *" *& "C:\Documents" & Me.FileName.Value

.Send

Here Me.FileName.value is the actual file name that it will be saved with..
The file name has a space somethign like "abc 123"

Hope I made it clear.

Thanks in advance