Data Quality Tools, Mailing Software, Lists, NCOA, Data Enhancements
Shopping Cart Cart | Newsletters | Search
Call 1-800-Melissa Products      Solutions Professional Services Downloads Support Resources Lookups Company
 

 


 

FAQ

How do I delete duplicate records in MAILERS+4 from my Access Database?

To delete duplicate records from your access database you must first insert a DUP ERROR field into your file with a length of one. Once you have the DUP ERROR field in your list, go to the FORMAT FIELDS feature underneath the FILE menu. Format this field as DUP ERROR on the DUPCHECK TAB at the top of the format screen. After you have formatted your DUP ERROR field click on OK and go to the DUPLICATE CHECK feature under the LIST MENU.

When you are done running the DUPLICATE CHECK on your list the software will append a component of "D" for duplicate into the DUP ERROR field. These records are now marked for deletion within your list. To permanently delete these records click on the PACK feature underneath the DATABASE MENU. There will be a check in front of DUPLICATES on the PACK screen. Click on the pack button and MAILERS+4 will erase your duplicates.