Are you wanting to the same email to multiple email recipients?
Find out which delimitter works with your email software:
address1, address2, address3,...
address1; address2; address3;...
Depending on the structure of your database there are several different ways to put such a list into a single field and then specify this field as the email address in the Send Mail action or script step.
It can be done in a script or it may even be possible to do it in a calculation field.
#Perform a find to find all the records that contain an email address to which you plan to send the email
Go To Record [First]
#In the next step change ; to , if you need to use that delimitter for your email software
Set Variable [$EmailList; Value: $EmailList & "; " & YourTable::YourEmailField]
Go To Record [next; exit after last]
Set Field [YourTable::YourGlobalSendField; Right($EmailList; Length($EmailList) - 2 /* strip off the leading "; " */]
#Now you can use YourTable::YourGlobalSendField as your specified field to send out your email
No need to copy or paste - the Send Mail script step can do this.
In the Send Mail script step options, you can specify to create: One email using data from the current record; Multiple emails (one for each record in found set).
The first option, creating one email using data from the current record, is a little misleading. You actually can send one email using data from each record in the found set for the to, CC and BCC email fields, as they each have the option "Collect addresses accross found set". The only limitation with this approach is the subject and body will be identical for all recipients.
The second approach will create one email for each recipient. This approach allows you to change the subject and body with record specific information.