how to add hyperlink to outlook body message

[sspreyer]

hi all

any ideas on how i can add hyperlink to outlook body message from excel

here my code i have highlighted in red the path i would like to add to the message as a hyperlink

thanks all in advance

Please Login or Register  to view this content.

cheers

shane

[gyclone]

You need to wrap your link in html, like so:

Please Login or Register  to view this content.

[sspreyer]

thanks for your help but i'm getting a compile error expected expression

cheers

shane

[gyclone]

Whoops. You need to put the html code in quotes and escape out the quotes inside.

Please Login or Register  to view this content.

If that doesn't get it, I'll probably need you to upload a sample, so I can see what all is happening.

[sspreyer]

gyclone thanks you so much you legend!!!!!!! one quick question i see the path is written twice does this mean i can change one of them to show "shane" in text as hyperlink instead of the path or is there reason it shown twice thank again for your help

Please Login or Register  to view this content.

cheer

shane

[gyclone]

You can absolutely do it that way. Check out these links for better descriptions than I could give as to the construction of the "<a>" tag: http://w3schools.com/html/html_links.asp and http://w3schools.com/html/html_elements.asp.