I have the following calculated field that returns the Line Items for an order. When I use the SEND MAIL script step with email client option if there is more than 1 line item in the result then the rest of the items get cut off. Data viewer displays the results correctly. If I change the pilcrow to a pipe or comma all the results will display on one line. Is there another delimiter I can use to get the email results to wrap?
$wo = _kp_Order ID ;
$table = GTN( OrderLine::OrderID );
$field = GFN( OrderLine::description ) ;
$where = GFN( OrderLine::OrderID );
$items = ExecuteSQL ("SELECT " & $field &" FROM " & $table &" WHERE " & $where &" = ?" ; "," ; "¶"