No, export/import is overkill.
If you're using FM12 you can just collect the relevant email addresses in a number of different ways:
- if relationships and TOs already exist you can use GTRR to build the found set and then send the email (remember that the Send Mail script step has an option for "multiple emails: one per record in the found set"
- if no relationships exist you can do a scripted find to produce the same found set and send the email
- or do an executeSQL to collect the email addresses in a variable and loop through that to send out one email per collected email address
Thanks for the great advice!