I am working in Access 2003.I have a table of customers tblCustomer. I wish to filter my customers on the "DateLastEmailSent" field and send them a group email with product updates. I also wish to record the date when this email was sent in the "DateLastEmailSent" field. The email address is in the "EmailAddr" field. I would be selecting the customers on a date range for when the last email was sent i.e from date to date type query.
Is this possible and how might I go about it. Any help is appreciated. Thank you.