Posted by George Pitcher on 10/21/57 11:15

Hi guys,

I'm doing something dumb but I can't see it.

The basic premise is:

sql search of orders sorted by customer
set g_customer_id to ''
loop through resultset
if customer_id not same as last record's customer_id (g_customer_id)
get customer email details
set up message header if this is the first record for a customer
set item details
else
set item details
set g_customer_id to customer_id
endif
send email
end loop

The problem is that as a sample I have two records from one demo customer
(me) and I can only get my email to handle one record - either sending
separate records for each record or one email covering the last record only

Its as if I should have another inner loop

Any tips

MTIA

George

[Back to original message]