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
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
Do you have sample code? Using standard HTML should work -- <a href='somepage.html'>LINK< /a>
ASKER
Standard HTML doesnt work the it doesnt render the HTML code appears it doesnt create a link
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ....)
From http://forums.asp.net/p/760557/760594.aspx
Set @URL = (select REPLACE(url,' ','%20') from ....)