Solved

How do I send a hyperlink using xp_sendmail?

Posted on 2007-03-30
9
576 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
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 29

Accepted Solution

by:
rdivilbiss earned 125 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
uploading image to a profile page 1 29
Zimbra opensource backup 10 43
Javascript to allow login/password authorization 4 29
Put shading on half of picture 8 23
Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now