help with sending email via sql server 2000

edmicman

Golden Member
May 30, 2001
1,682
0
0
I wrote a stored procedure that would send a response to someone after requesting information via a form. Here's the chunk of code:

set @Subject = 'Thank you for contacting us!'
set @Body = 'Thank you for your interest. Your information request has been received. A representative will contact you shortly and will arrange to provide you with the information you desire.' + CHAR(10) + CHAR(13)
set @Body = @Body + CHAR(10) + CHAR(13)
set @Body = @Body + 'In the meantime, a copy of our brochure is available at http://www.ouraddress.com/brochure.pdf .' + CHAR(10) + CHAR(13)
set @Body = @Body + CHAR(10) + CHAR(13)

exec sp_send_cdosysmail 'marketing@ouraddress.com', @EmailAddress, '', '', @Subject, @Body

BEGIN
select @CurrentDate=getdate()
UPDATE Inforeq SET Acknowledged=@CurrentDate WHERE [ID]=@ID
END

I use the sp_send_cdosysmail procedure and everything works fine. The problem, which I just noticed today, is that in Outlook it apparently isn't displaying the second line of the body text, which has our link in it. It worked in my old email client, Eudora. So is there something where Outlook isn't recognizing the line breaks or something? Can I "view source" in Outlook? Any ideas? Thanks!