asked on

Hyperlink in email message

I would like to set up my email that sent from xp_sendmail to include a hyperlink, so when people receive the email, they can click the link and it open a web page. here is what I set up, but in the email, there is no hyperlink show up, the '<a href="http://ateca4epgnt001/SuspenseTracking/ViewOpenSuspenses.aspx">View Open Suspenses</a>' show up instead. Please help. THanks

SELECT @Suspense = @Suspense + 'Internal Suspense Date: ' + Internal_Suspense_Dt + CHAR(13)
                  + 'External Suspense Date: ' + Suspense_Dt + CHAR(13)
                  + 'Title: ' + Title + CHAR(13) + 'Comments: ' + Comments + CHAR(13) + 'Assignee: ' + Assigned_To + CHAR(13)
                  + 'Response POC: ' + Response_POC + CHAR(13) + 'Responsible party: ' + Responsible_Party + CHAR(13)
                  +'<a href="http://ateca4epgnt001/SuspenseTracking/ViewOpenSuspenses.aspx">View Open Suspenses</a>'

ruperts

Try the below -- although by default xp_sendmail doesn't support HTML emails..

http://support.microsoft.com/default.aspx/kb/311231 == See Q10

EXEC master.dbo.xp_smtp_sendmail
@server = 'smtp.yourdomain.com',
@from = 'you@yourdomain.com',
@to = 'them@theirdomain.com',
@subject = 'HTML Testing...',
@type = 'text/html',
@body = @Suspense

CochiseCounty

ASKER

How should I set up to use master.dbo.xp_smtp_sendmail ? I don't see xp_smtp_sendmail in master database

ASKER CERTIFIED SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CochiseCounty

ASKER

I follow the instruction and when I try to execute a sp to send email. I receive this error message
Cannot load the DLL xpsmtp80.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).

I checked in my Binn folder, the file xpsmtp80.dll is there.