Filtering Mailing Lists using Access and Outlook
Programming, Tips Tagged access, email, outlook, sending mail 14 Comments »In what is becoming a series, we'll further tweak our code to allow for filtering of the query.
In the original code, we open a query directly as a recordset. This fails if the query requires some parameters.
(I'm not going to demonstrate a way to get user input and use that as the parameter. You should be able to copy and paste the code from the original user input sections of the code and modify as needed.)
To start, let's discuss the query and it's parameter.
In our original code, the query was just pulling a list of email addresses. For this, let's filter that list of addresses by domain.
Read the rest of this entry »

