merging files for email

[Mark Goldfarb]

I would like to send an email to my customers who have outstanding balances. I need to include these fields: firstname,orderbalance$$,customerlogin_1 and the text of the email. How do I make this happen? I have been able to do the sendmail script and have the correct email address inserted with the correct subject but I have not been able to make the body contain what I need.

Thanks for the help

[Vaughan]

Make a single calculation field that concatenates all the text together. Use this calc field as the body of the text.