Delete/Clean all deleted contacts [ Edited ]

[Petrovlis]

I have many deleted Contacts and I like to get rid of them in the Database.

I the past  I can remember some query/filter     with  ... deleted(o) = 1

How to do this ?

William

[ch1p]

If the contacts have been deleted using the delete option in ACT then run Check and Repair under Tools - Database Maintenance. Tick both boxes.

The only Query I can think of like the one you suggest where deleted items may still be visible would be inside SQL.

[Petrovlis]

I did Check and Repair, but  (within SQL  via Excel)  these "deleted" are still there... !  Can I delete via this (EXCEL  Sql link/connection ???

Otherwise, can I Export (CSV)   without the deleted Contacts, because they appear in a Thirdparty mailing program after Export/Import in thirdparty mailing prg.

Thanks, William

[ch1p]

I would not try to remove inside SQL as it may have unintended results.

I seem to remember that if you export from SQL with the CONTACT TYPE field included you can then use the query you mentioned (or similar)  to find and remove from Excel deleted records.