Duplicates on mailing lists

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I am helping out a nonprofit that is trying to remove
duplicates from a couple of lists. I have some ideas on
how to do this but would appreciate any ideas anyone might
have or snipets of code I could use to simplify the
process. Any suggestions or help would be appreciated.
Thanks. Michael
 
Michael

Define "duplicates"...

Would you (or the nonprofit) consider the following to be duplicates:

John Smith 12345 Elm St
John Smith 12345 Elm Street
J. Smith 12345 Elm St SW
J. J. Smith 12354 Elm St
J. Smith, Jr. 12345 Elm Street

If there's a chance that you are considering "close enough", rather than
what Access will do ("exact match"), you can create a query that sorts all
the entries by what you believe to be "duplicated", and have someone's
eyeballs and brains resolve duplicates.
 
Back
Top