Using Send Mail to send one email for each record to email address in that record.
Send Mail is not performing as expected. The simple scenario is in a two-field test table, each record in the found set contains an email address to where the email must be sent, and a second field contains the email body. Send Mail is configured to use the SMTP server feature. The table contains 4 records.
When "One email using data from the current record" is checked, each email address (one per row) has emails from each other records sent to it. When the "multiple emails (one for each record in found set)" is checked, each email gets each other addresses emails.
This scenario is too easy for it not to work. What I simply want is one and only one email going to one email address, for each record, and no emails sent to anyone else.
What am I doing wrong or not understanding.