local lcEmails lcEmails = "" select Cients scan for NOT empty( e_mail ) lcEmails = lcEmails ; + iif( empty( lcEmails ), "", ";" ) ; + alltrim( e_mail ) endscan select OtherTable replace bulk_mail with lcEmailsI just missed adding the previous email in each loop.