S
sam
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 = "(e-mail address removed)"
.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
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 = "(e-mail address removed)"
.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