I receive an email with the order:

NAAM: Eersels
VOORNAAM: Vivian
EMAIL: vivian.eersels@wanadoo.be
ADRES: 22
POSTCODE + PLAATS: 2222
LAND: BE
TITEL: Lakentjes
ProductID: 53
PRIJS: 3.72
TOTAAL: 9.92



Ok, I want that these lines repeat: (Number of items ordered)

TITEL: Lakentjes
ProductID: 53
PRIJS: 3.72

This is the code:

"TITEL: " & cstr(CustomerOrderRS.Fields.Item("Colour") & Chr(13) & Chr(10)
&_
"ProductID: " & cstr(CustomerOrderRS.Fields.Item("ProductID") & Chr(13) &
Chr(10) &_
"PRIJS: " & cstr(CustomerOrderRS.Fields.Item("UnitPrice")& Chr(13) &
Chr(10) &_

How can I do that?

you need to have a loop for the items in the order... something like this <pre id=code><font face=courier size=2 id=code><b>do while not CustomerOrderRS.eof</b>

str = str & "TITEL: " & cstr(CustomerOrderRS.Fields.Item("Colour") & Chr(13) & Chr(10)
&_
"ProductID: " & cstr(CustomerOrderRS.Fields.Item("ProductID") & Chr(13) &
Chr(10) &_
"PRIJS: " & cstr(CustomerOrderRS.Fields.Item("UnitPrice")& Chr(13) &
Chr(10)

<b>CustomerOrderRS.movenext
loop</b></font id=code></pre id=code>

Joel Martinez [ joel@udzone.com ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/