[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 605
  • Last Modified:

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
0
LJordanMS
Asked:
LJordanMS
1 Solution
 
hawks4everCommented:
Do you have sample code?  Using standard HTML should work -- <a href='somepage.html'>LINK</a>
0
 
LJordanMSAuthor Commented:
Standard HTML doesnt work the it doesnt render the HTML code appears it doesnt create a link
0
 
SysExpertCommented:
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.

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
rdivilbissCommented:
>>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.

You'll need to URL encode the href.

\\server\folder one\whatever\

becomes \\server\folder%20one\whatever\

which doesn't break the HTML of the href.
0
 
LJordanMSAuthor Commented:
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?
0
 
Michel PlungjanIT ExpertCommented:
PS:

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

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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now