• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

help with sending email via sql server 2000

edmicman

Golden Member
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!
 
Back
Top