Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gperque
Starting Member
7 Posts |
 Posted - 2007-07-23 : 17:25:57
|
| I'm using the "sp_send_cdosysmail" stored procedure in my queries to send e-mails in SQL Server 2000. Is it possible to create a hyperlink within the e-mail being sent and what is the format?Thanks in advance,Glenn |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-23 : 17:27:41
|
| Have you tried HTML?Peter LarssonHelsingborg, Sweden |
 |
|
|
gperque
Starting Member
7 Posts |
Posted - 2007-07-23 : 17:43:00
|
| I'm using HTML as the e-mail format. Here is a sample line of code I'm using when trying to create the link.SELECT @sHTML = @sHTML + '\\ninfpetsp001\shared\access_databases\gperque_A&G\doc1.doc |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-23 : 17:44:57
|
| Where are the <a href="link here">Text</a> thingies?Peter LarssonHelsingborg, Sweden |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-23 : 17:46:01
|
| SELECT @sHTML = @sHTML + '<a href="' + \\ninfpetsp001\shared\access_databases\gperque_A&G\doc1.doc + '">Click here</a>'Peter LarssonHelsingborg, Sweden |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-07-23 : 17:49:39
|
| I don't use sp_send_cdosysmail, so you can take this suggestion with a grain of salt, but I think you need to specify HTMLBody instead of TEXTBody in the code. EDIT: just googled for the sproc name and found this. search down the page for the HTMLBody info http://aspalliance.com/550_Sending_SQL_Notifications_via_CDOSYS_-ec |
|
|
|
gperque
Starting Member
7 Posts |
Posted - 2007-07-23 : 18:11:43
|
| Peter Larsson, your solution worked.Thank you,Glenn |
|
|
|
|
|
|
SQL Server 2000 e-mail