Home Software Lorton Data – Duplicate address processing tips

Lorton Data – Duplicate address processing tips

1955
0

Proper Terminology for Duplicate Removal 

When requesting that duplicates be removed from your mailing list, it’s important to use proper terminology.  This will ensure that multiple pieces are not mailed to a particular address.

One Per Person – Matching is based on first name, last name, and address information.    

  • First names are standardized for matching purposes only. For example:  Bill matches with William, Peggy matches with Margaret, etc.
  • First names are matched to first initials.
    For example: J. Smith matches with John Smith
  • One record per unique first and last name and complete address will be retained.  
  • Priority can be used to specify which record should be retained.
  • Output data for retained records is not changed. 

One Per Last Name and Address – Matching is based on last name and address information.

  • Sometimes referred to as One Per Household
  • Residents with different last names at the same address are retained.
  • Most hyphenated last names are matched to non-hyphenated last names
    For example: John Smith matches with Nancy Nelson-Smith.
  • One record per unique last name and complete address will be retained. 
  • Priority can be used to specify which record should be retained.
  • Output data for retained records is not changed. 

 

One Per Address – Matching is based on address information only.

  • Last names are only considered on rural route addresses with no box number.
  • One record per complete address will be retained. 
  • Priority can be used to specify which record should be retained.
  • Output data for retained records is not changed.

 

The information for this post came from an email from Lorton Data.  This website is not responsible for the accuracy of the information provided.  If you are the owner of this content and wish it removed then please contact me using the comments section below and leave a return email address.

Previous articleVBA: Format a date field in MS Access
Next articleBlackberry Curve 9330 no option for personal email

LEAVE A REPLY

Please enter your comment!
Please enter your name here