February 21, 2010 at 10:28 am
Hi All,
I have a stored procedure in SQL Server 2000 which is used for sending emails to the user using the system stored procedure (cdo_send_sysmail).The body of the email is created with the combination of static text in stored procedure and dynamic data retrieved from the database.The problem is that when email is send to the user the body of the email in outlook breaks at line number 72 automatically and the formatting of the mail is distorted.How do i address this issue so that the format of the mail is retained.
February 21, 2010 at 3:20 pm
You may want to consider an alternative approach that does not rely on MAPI and an outlook client.
Have you considered SMTP?
Please reference the following links in which there is information concerning formatting the body:
http://support.microsoft.com/kb/312839
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html
I hope this helps.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 21, 2010 at 3:25 pm
dibenduc 96312 (2/21/2010)
Hi All,I have a stored procedure in SQL Server 2000 which is used for sending emails to the user using the system stored procedure (cdo_send_sysmail).The body of the email is created with the combination of static text in stored procedure and dynamic data retrieved from the database.The problem is that when email is send to the user the body of the email in outlook breaks at line number 72 automatically and the formatting of the mail is distorted.How do i address this issue so that the format of the mail is retained.
Also, pleas pay attention to which Forum you are posting in. This is a SQL Server 2008 forum, whereas you should be posting in one of the SQL Server 2000,7 forums.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply