P
Paul Ponzelli
I'm trying to build a concatenated string of email addresses from a selected
group of records in a subform. My purpose is to send an email to a group of
contacts whose check boxes have been selected by a user.
I'm currently using the SendObject method of the DoCmd object to send the
email to a single recipient, but I need to loop through the subform records
that are checked to build the concatenated string containing the addresses
of all contacts in the selected group.
Assuming that my objects are named as follows:
Main form: frmProjects
Subform control: ctlContactsSub
Subform: frmContactsSub
Email field in subform: txtEmail
Checkbox field in subform: chkInclude
Can someone Please tell me how to loop through those subform records so I
can concatenate the email fields in the checked records?
Thanks in advance,
Paul
group of records in a subform. My purpose is to send an email to a group of
contacts whose check boxes have been selected by a user.
I'm currently using the SendObject method of the DoCmd object to send the
email to a single recipient, but I need to loop through the subform records
that are checked to build the concatenated string containing the addresses
of all contacts in the selected group.
Assuming that my objects are named as follows:
Main form: frmProjects
Subform control: ctlContactsSub
Subform: frmContactsSub
Email field in subform: txtEmail
Checkbox field in subform: chkInclude
Can someone Please tell me how to loop through those subform records so I
can concatenate the email fields in the checked records?
Thanks in advance,
Paul