HELP with .HTMLBody: Display Hpyerlink in email body

S

sam

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><B>Information: </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.
 
B

Barb Reinhardt

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.
 
R

Ron de Bruin

See how I do it here

strbody = "<H3><B>Dear Customer</B></H3>" & _
"Please visit this website to download the new version.<br>" & _
"Let me know if you have problems.<br>" & _
"<A HREF=""http://www.rondebruin.nl/"">Ron's Excel Page</A>" & _
"<br><br><B>Thank you</B>"
 
J

Joel

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)
 
S

sam

Thanks for helping Ron,

When i do it your way, I go get the hyperlink displayed in the email body,
BUT the link displays as "C:\My Documents\FileNumber.Value" Here the
FileNumber is a text field in the userform which have different values
everytime. SO instead of "C:\My Documents\FileNumber.Value" I want "C:\My
Documents\abc 123" ; "C:\My Documents\abc 234" ect

here, abc 123, abc 234 ... etc are actual file names the files are saved with.

Hope I made it clear.

Thanks in advance
 
R

Ron de Bruin

Ok, I test it with a file name in A1
and for every space in my path I add %20


I use

LinktoFile = "C:\Users\Ron%20Desktop\Desktop\Mee%20Bezig\" & Range("A1").Value


And use it it like this

"<A HREF=" & LinktoFile & ">Ron 's Excel Page</A>" & _
 
S

sam

Thanks Joel, I got this to work. Can you help me with pulling data from
access into userform fields using ADO? I did post my query like you asked. I
would appreciate any help.

Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chart to email 3
HELP: email file path as a hyperlink in outlook body 9
The Dear x at the top is formatted as times new roman font...why?! 1
using vbCrLf in email body does not work with HTMLBody 2
Questions on Ron de Bruin's Excel Email Macro 4
Send email using vba code 3
Display File path as hyperlink in outlook 2
Hyperlink in Email Body 6

Top