04-01-2017 12:35 AM - edited 04-01-2017 12:36 AM
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 ?
04-01-2017 02:55 AM
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.
04-01-2017 03:08 AM
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.
04-01-2017 03:55 AM
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.