Checkbox Help

[dbneedhelp]

I have a database with a contact list. In this contact list I have a “yes/no” check box that decides if that person is going to be e-mailed (chkEmail), an E-Mail block that displays the e-mail address (txtEmail), and a command button to send the E-Mail (cmdEmail). I want to be able to select multiple people and when I click the E-Mail command, have those people on the BCC: line of Outlook. After the e-Mail command has been clicked I want the checkboxes to reset to “no”.

chkEmail- “Yes/No” Checkbox
txtEmail- E-Mail address
cmdEmail- Opens Access

 

[pbaldy]

See if this gets you started:

http://www.granite.ab.ca/access/email/recordsetloop.htm