Link to home
Start Free TrialLog in
Avatar of LJordanMS
LJordanMS

asked on

How do I send a hyperlink using xp_sendmail?

I am currently using xp_sendmail to send an email notification and iIn the email I have a link to a folder on the network.
The folder location is very long and for some of the folder names there are blank spaces in the folder names so the link wraps on to the next line.

Is it possible to create a hyperlink using xp_sendmail by coding something in message parameter of the xp_sendmail store procedure, when I do it the HTML code just shows it does render a link.  The office email software that we are using is Lotus notes
Avatar of hawks4ever
hawks4ever
Flag of United States of America image

Do you have sample code?  Using standard HTML should work -- <a href='somepage.html'>LINK</a>
Avatar of LJordanMS
LJordanMS

ASKER

Standard HTML doesnt work the it doesnt render the HTML code appears it doesnt create a link
Avatar of SysExpert
How long is the link ?

there may be 128 or 255 byte limitiations

have you tries a different emailer that has more options.

There are plenty of good command line email programs available.

ASKER CERTIFIED SOLUTION
Avatar of rdivilbiss
rdivilbiss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If I have <a href="http://www.google.com/">Google</a> that I am passing using xp_sendmail, how can I URL encode it? I have done it in ASP but not through xp_sendmail what would be the syntax to do that?
PS:

From http://forums.asp.net/p/760557/760594.aspx

Set @URL = (select REPLACE(url,' ','%20') from ....)