Thanks so much for your help Jason. I didn't expect to hear from you at 6:30am PDT!
I'd like the message to get sent to all records in the recordset. I used the recordset to set the to field, but it only sent to the first recipient in the list.
If there's a tutorial or you tube video on this, I'd be happy to study it there.