Mailing Customer Letters

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.
 
M

Mike Painter

BarryC said:
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.
Click to expand...

Start by adding a Yes/No field named "Printed"
You will use a query to select the letters and a similar query to mark them
as printed.
There are many ways and if you are doing bulk mail you should be sorting on
the ZIP code.

Here is one of the easiset.

SELECT TOP 200 ZIPCODE.[Zip Code], ZIPCODE.State
FROM ZIPCODE
WHERE ZIPCODE.Printed = False;
 
Top