Help with Access 97 mail merge query suggestion

[circuit slave]

Hi, I wanted to know if someone might be able to suggest how best to
create a query for an ongoing mail merge. Here's the deal: I work for
a non-profit organization which received donations on a regular basis.
So I need a query that will pull the individual donors three weeks from
the time of their deposit ( i.e., entry date in the database) for
mailing out tax letters. Now, I know how to do that, just add 21 days
from the date of entry, but what I want is to run this query anytime
without having repeats or duplicates.

Now this is an ongoing mailing, in other words each day I am inputting
donors. So, say, one day I input five or ten donors, and then nothing
for a few days and then again a week later I input more donors.

I want to be able to run this query any day, like say every Monday, for
instance, and pull any and all donors whose entry date has already
passed the three-week mark.
I just don't the query to pull the same or get duplicates every time I
run it.

Is this possible? thanks !

Thanks !

 

[Geoff]

Perhaps create a date field for "DateTaxLetterSent". After a batch of the
letters have been sent, run an Update query to enter the date sent. Adjust
the query that selects people needing letters to exclude those who already
have a date in the new field.

Geoff

 

[circuit slave]

Thanks, Geoff! That makes sense : )

Perhaps create a date field for "DateTaxLetterSent". After a batch of the
letters have been sent, run an Update query to enter the date sent. Adjust
the query that selects people needing letters to exclude those who already
have a date in the new field.

Geoff