[thelist] CDO Mail - Looping inside

[Edd Partee]

Smart People:

I'm trying to send mail using CDO and ASP. My data is coming from a
database that contains items organized by Order Number. Each order
number can be associated with more than one item number. I want the mail
to come out like so:

strBody = strBody & "Order Number " ... database stuff, line breaks no
loop
strBody = strBody & "Customer Name " & ... no loop
strBody = strBody & "Item Number " & ... I want this one to loop 
strBody = strBody & "Item details" & ...  also looping
strBody = strBody & "Order Total" ... no loop 


I can get everything in place correctly, except the loop for the
different items. Can I put a loop inside the mail code itself, or do I
need to loop relevant things into a variable and then pull that in to
the mail code? I've tried (in my ASP newbie way) a few things, none of
which worked. Point me in the right direction.

TIA