Thanks for the info on adding the line number to the email. I added it to the sort after the order number and then put it inside the repeat calls and it the email still only puts in the info on the first line item. Here's the sql statment that I'm using....
SELECT dbo.oeordlin_sql.ord_no AS "ord_no", dbo.oeordhdr_sql.cus_no AS "cus_no", dbo.oeordhdr_sql.bill_to_name AS "bill_to_name", dbo.oeordlin_sql.item_no AS "item_no", dbo.oeordlin_sql.item_desc_1 AS "item_desc_1", dbo.oeordlin_sql.qty_ordered AS "qty_ordered", dbo.oeordhdr_sql.entered_dt AS "entered_dt", dbo.oeordhdr_sql.shipping_dt AS "shipping_dt", dbo.oeordlin_sql.line_seq_no AS "line_seq_no" FROM (dbo.oeordhdr_sql LEFT OUTER JOIN dbo.oeordlin_sql ON dbo.oeordhdr_sql.ord_no = dbo.oeordlin_sql.ord_no) WHERE dbo.oeordhdr_sql.status <> 'L' AND dbo.oeordhdr_sql.entered_dt = '{%Current Date%}' AND dbo.oeordhdr_sql.shipping_dt < dbo.oeordhdr_sql.entered_dt +4 AND dbo.oeordhdr_sql.status IN ( '1' , '4' , '6' ) AND dbo.oeordhdr_sql.selection_cd = 'C' ORDER BY dbo.oeordlin_sql.ord_no ASC, dbo.oeordlin_sql.line_seq_no ASC
In the email, I start with a little text including the order number then start the repeat. I then placed the line_seq_no, item_no, item_desc_1, and qty_ordered fields on the same line then end the repeat function.
To me, it seems like they need to add a grouping function.
Regards,
Marc