Order Confirmations

26 Jul 2006 5:41 PM

MBSNewbie

Hi All,
I'm a newbie to SQL so I hope I don't sound too bad here.
I have just configured SQL Mail to automatically send e-mail confirmations
to our clients when orders are placed. I have been searching the web to try
and see how to set the E-mail Template and to automatically send these to the
customers every half hour.
I found instructions on xp_sendmail, but I'm not sure how to Add my own
wording to the document in addition to the customer order details. I'm aslo
not sure how to send individual e-mails based on the Select statement.
Let's say the table contains: Customer Number, Customer Name, Order Number
Item, Total & E-mail Address.

I'd appreciate any help, please let me know if I can clarify my dilemma.

Thanks in advance for understanding that I'm new and trying to pick this up.

27 Jul 2006 6:27 AM

Ed Murphy

On Wed, 26 Jul 2006 10:41:02 -0700, MBSNewbie
<MBSNew***@discussions.microsoft.com> wrote:

>I have just configured SQL Mail to automatically send e-mail confirmations
>to our clients when orders are placed. I have been searching the web to try
>and see how to set the E-mail Template and to automatically send these to the
>customers every half hour.
>I found instructions on xp_sendmail, but I'm not sure how to Add my own
>wording to the document in addition to the customer order details. I'm aslo
>not sure how to send individual e-mails based on the Select statement.

This seems like a good starting point:
http://www.sqlmag.com/Article/ArticleID/48597/sql_server_48597.html