View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default HELP with .HTMLBody: Display Hpyerlink in email body

To help yousolve your problem you can open a new word document. Then paste
your hyperlink in to the word document and save a HTML. then you can open
the HTML with notepad to see the tags Bard described. You can copy the path
location from a window explorer window. Make sure the window explorere has
the address bar visible (View - Toolbars - Address Bar)

"Barb Reinhardt" wrote:

IIRC, you need to put something like this in your code

<a href="http:mypath"http:mypath</a

It's been a while since I did anything in html.
--
HTH,

Barb Reinhardt



"sam" wrote:

Hi All,

I want to display the file path as hyperlink in my email body, I tried using
.HTMLBody and usging "%20" where theres a space but then when i send the
email i see a "%20" in my email body. Here is what i have for outlook
.HTMLBody

strbody = "<H3<BInformation: </B</H3 <br" & _
" Name: " & Me.Name.Value & "<br" & _
"Email: " & Me.Email.Value & "<br" & _
"Date: " & Me.DatePreparedTextBox.Value & "<br" & _
"LP Path: " & "C:\My Documents\" & Me.FileNumber.Value &
"<br" & "<br" & _

ALSO, I am saving the file with a field name from the form(thats why
Me.FileNumber.value is the part of the path as the file is saved with this
name).
And that field name too has a space in between.
Such as "ABC 123"

SO the patch would look like: "C:\My Documents\ABC 123"
and I want to display this as a hyperlink, so the user can just click on the
link and open up the file.


Thanks in advance.