CochiseCounty
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>'
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>'
ASKER
How should I set up to use master.dbo.xp_smtp_sendmai l ? I don't see xp_smtp_sendmail in master database
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
http://support.microsoft.com/default.aspx/kb/311231 == See Q10
EXEC master.dbo.xp_smtp_sendmai
@server = 'smtp.yourdomain.com',
@from = 'you@yourdomain.com',
@to = 'them@theirdomain.com',
@subject = 'HTML Testing...',
@type = 'text/html',
@body = @Suspense