?
Solved

How do I send a hyperlink using xp_sendmail?

Posted on 2007-03-30
9
Medium Priority
?
593 Views
Last Modified: 2013-12-18
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
Comment
Question by:LJordanMS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 3

Expert Comment

by:hawks4ever
ID: 18824245
Do you have sample code?  Using standard HTML should work -- <a href='somepage.html'>LINK</a>
0
 

Author Comment

by:LJordanMS
ID: 18824811
Standard HTML doesnt work the it doesnt render the HTML code appears it doesnt create a link
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 18824906
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 29

Accepted Solution

by:
rdivilbiss earned 500 total points
ID: 18829414
>>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
 

Author Comment

by:LJordanMS
ID: 18837418
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
 
LVL 75

Expert Comment

by:Michel Plungjan
ID: 19563429
PS:

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

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

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article outlines some of the reasons why an email message gets flagged as spam on a recipient's end.
In this tutorial viewers will learn how to style elements, such a divs, with a "drop shadow" effect using the CSS box-shadow property Start with a normal styled element, such as a div.: In the element's style, type the box shadow property: "box-shad…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question