Community
Showing results for 
Search instead for 
Do you mean 
Reply

Delete/Clean all deleted contacts

Copper Contributor
Posts: 90
Country: Netherlands

Delete/Clean all deleted contacts

[ Edited ]

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

Bronze Elite Contributor
Posts: 1,409
Country: United_Kingdom

Re: Delete/Clean all deleted contacts

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.

Copper Contributor
Posts: 90
Country: Netherlands

Re: Delete/Clean all deleted contacts

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

Bronze Elite Contributor
Posts: 1,409
Country: United_Kingdom

Re: Delete/Clean all deleted contacts

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.