Using MS Access (2003) quite regularly for a lot for mailshots, and when there's say a couple of hundred more address's to put on the database, I then input those address's, do the mailshot and then, to ensure that the same people don't get the same thing again, I usually apply a filter, something like a tick in the relevant column means that the person has already received something before, so don't send again!! (It's ok, all of the recipients have requested the info!).
BUT, the problem is, after each mailshot, going through the db to put the ticks in the correct column, is not too bad when there's just a few 100, but there's projects coming up, where they're in the 1,000's.
Has anyone found a way to solve this please ?
Any help much appreciated.
Chris