One Email to multiple Addressees using SendMail? Help Please....

May 10, 201213 yr

I have 36 records in a found set, each with an email address. I have created a script with the intention of presenting a single blank email email to the user with all of the email addresses from this found set in the BCC field, and with a 'no reply' email address in the To field. The intended result is a single blank email presented to the user with all the email addresses from the found set put together in its BCC field so that one single email can be created and sent out to all of the BCC addressees.

However, on executing the script, my email client produces a blank email for every single record - all 36 of them. Like confetti. All over the screen. It's like winning that Solitaire game, when all the cards bounce all over the screen!

I've checked and re-checked my script, but can't see where I'm going wrong. Probably something incredibly simple that I can't spot. So could someone who knows this scenario please offer some help?

This is my script:

1. Show Custom Dialogue "Send Email":"This action will bring up a blank email form with all the email addresses in the 'BCC' field so that you can send them all an email. You will need to type the message into the form before sending.¶¶Are you sure you want to do this?"

2. If [Get ( LastMessageChoice ) = 1)]

3. SendMail (via email client: create one email using data from the current record: to 'no reply' : BCC email_field, collect addresses across found set checked: Subject 'Standard Text'; Message 'Type your email message here'

4. Else If [Get ( LastMessageChoice ) = 2)]

5. Revert Record / Request

5. EndIf

6. Exit Script (I was hoping that this would break any unintended loop to stop the confetti, but it hasn't).

If this is wrong, how should the script / SendMail be configured in order to present only one SINGLE email to the user with all the email addresses from the found set in the BCC field?

Thanks in advance