Auto Update

B

BarryC

I have a table with customer address data. I would like to create a form
where a person can enter the amount of letters they would like to mail out,
say 200. Is there a way I could do that and have the table update so the next
time we want to send letters the next batch of customers (say the next 300)
is mailed out. Thank you.
 
R

Rick B

Barry:

You just asked this at 10:30.

No need to repost every hour. When someone knows the answer, they will post
it.

In short, what you need to do is update the records with the last time a
letter was sent, and find the oldest ones.

What if you have two types of letters and each letter needs to go to all the
users? If it were me, I'd have another table where I create a record with
the 'letter name or type' and the client number, and the date. Then you can
find clients that DID NOT get a certain letter and you can pul 100 or 200 of
them.
 
Top