And this is when I go outside and walk in front of oncoming traffic... If I may, I would like to use the fact that...

I figured it out and it works awesome!

Thanks anyway...

Anyone out there?

OK! I actually have this working to some degree, but depending on where I put the END, I get anywhere from one email to three emails or SIX emails! This...

I tried doing this... you can see where I am calling (or trying to setup and call the XML)... am I on the right track?

USE [DatabaseName]

GO

/****** Object: StoredProcedure [dbo].[usp_send_prodavail_email_ON-TIME]...

Something like this?

cust_cdemailitm_cdvsndesqty

ARMSJ59806email@yahoo.com 3399020BRY,3399-02END TABLE2

ARMSJ59806email@yahoo.com 3399020BRY,3399-02END TABLE2

ARMSJ59806email@yahoo.com 3399020BRY,3399-02END TABLE2

ARMSJ59807email@yahoo.com 3399020BRY,3399-02END TABLE2

ARMSJ59807email@yahoo.com 3399020BRY,3399-02END TABLE2

I am sorry, but I thought...

OK. Here is a sample of what I want. I made a "comment" in there between [[[ ]]]. I would like to list the items in a table format using...

Yes, Lowell. Thank you... I will get a sample up ASAP.

Not to be a pain, but I did post a sample of what I am looking for... it isis above.

And thank you SO much for your time!

Oh! That's a procedure from something different... I want to do the same thing, using some of that code, but I do not know how to handle the loop inside...

Gianluca Sartori (10/5/2011)

---

Based on your description of the problem, I don't think that db_mail is the right tool for this.

You'd better generate HTML reports with a reporting application (such as...

Here is something that I wrote for our delivery emails... I need something like this, however, like I had said before, I want to only send one email to the...

Gianluca Sartori (10/4/2011)

---

OK, and what is supposed to go into the e-mail body?

All the columns? If so, I think that the XML solution is not feasible: you would have to...

And here is some test data:

INSERT INTO EMAIL_TABLE_TEST

(DEL_DOC_NUM, MAX_DUE_DATE, INSERT_DATE, BO_SKU_COUNT, EMAIL, CUST_CD,

SHIP_TO_F_NAME, SHIP_TO_L_NAME, SHIP_TO_ADDR1, SHIP_TO_ADDR2, SHIP_TO_CITY,

SHIP_TO_ST_CD, SHIP_TO_ZIP_CD, SHIP_TO_H_PHONE, FNAME, LNAME, ADDR1,...

Ok. Here is the table:

USE [DatabaseName]

GO

/****** Object: Table [dbo].[EMAIL_TABLE_TEST] Script Date:...