Mail Shot Database Problem

Hey everyone

I have made a very simple marketing database that will be used to input addresses and print the labels to go on the envelopes. I have categorized the addresses, and using a simple query I can print the addresses of just one category.

The only problem is currently there is nothing to tell us when we last sent a mail shot to any of the addresses so there is nothing stopping us from sending the same marketing material to the same person twice. Normaly this wouldn’t be a problem because you would mailshot the whole category in one go and the write down somewhere that that category was done on said date. But being a small company we cant just stop everything else to do this.

Any one got any suggestions on how I can keep track of whats been sent to who and when?

Thanks for any help
Dan