Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display file path as hyper link in outlook email body | Excel Programming | |||
using vbCrLf in email body does not work with HTMLBody | Excel Programming | |||
how do you email a portion of a worksheet (range) as an insert into the body of an email? | Excel Programming | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |