----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Girdhar77 Message 1 in Discussion Hi , I am using SQL xp_sendmail extended stored procedure to send mails.The difficulty I am facing is the formating of the mail message content. I have declared a variable @msg varchar(1000). I want the mesage body should appear like below Dear xxxxx, xxxxxxxx,xxxxxx xxxxx xxxx xxxxxx xxxxxx xxxxx xxx Regards Administrator To be more precise , How to add a newline character . I tried this also @msg = 'Dear xxxxx' * @msg = @msg + 'xxxx,xxxx,xx xx xx' @msg = @msg + 'xxxxx' it's giving error on the 2nd line marked with ' * ' line This is very urgent.Any inputs would be greatly appreciated. Rishi ********************************************************************* Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. ********************************************************************* ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
