I have a query post_turn_wheeldiameters that is sent by using a macro and the command EMailDatabaseObject, entering the email addresses in the To box
Ideally I would like to select recipients from a second query contacts_email_post_turn_dias2, where the field is email_post_turn_dias and the table is contacts_email_post_turn_diameters1. The field would have the value True.
Is this possible, unfortunately I have little experience of VBA.
Any help much appreciated, thanks