Using Query to send auto reminder e-mails?

R

Richard

We have customers that we need to remind on a six month basis that it's time
to change their air filter. I was told that if we either imported an Excel
spreadsheet with the contact info (i.e., name, e-mail address, reminder date,
etc.) that a query could be performed in Access to find all those files and
return them in a report. I then want to send everyone within that query an
e-mail with a pre-designed template stating that it's time to replace their
filter.

I'm pretty new to Access so any help or directions would be great.
 
Top