Sample Code illustrating looping through a DAO recordset

This code is attached to a command button on a form. On the form are the fields txtProgress which displays various messages as well as lblStatus which displays a record count of the progress.

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