Your loop script will work. You are presumably looping and setting the '$MailAddress' variable to be the mail address of the next record. Set it to be:
$MailAddress = $MailAddress & ";" & MailAddress [of this record]
In other words, build it up as itself, with the next record's mail address appended on the end (with an appropriate mail address separator in between).
thanks for your help!
I have done as you said and it does create a list of email addresses in the global field but when in comes to executing the send mail script it doesn't work. I have tried setting the "To" field in the "send mail" ss with a variable and have also set it to the global field, but either way it just opens up entourage without creating an email (I have purposely not set the "send mail" ss to perform without dialog so that it gives me the oportunity to edit the email before sending). I'm wondering if there is an issue with using global fields and the send mail script step??
I would attach a screen shot of the script i wrote but there is no way (that I can see) of adding an attachement at this point.
Let's go back a step - did the email work the way you wanted it to under your original set-up? If you only had one record in the found set then your original loop would only have generated one address anyway.
If that didn't work, you may as well get the emailing working with one address from a stored field. Then move on to making it work with the same address address typed into a global field. Then move on to several addresses typed into a global field. Then move on to generating the global filed with the looping script.
No point in worrying over the latter parts of that if it doesn't work for the former steps.