How do I quickly delete over 50,000 blank entries from Contacts?

[ynezllapa]

I accidentally imported an entire Excel spreadsheet, including about 65,000
blank entries into my Contacts database. Is there a quick way to remove them?
I don't have enough memory to just highlight them and delete them all at
once, so I am just doing it about 100 at a time and it is slow going.

 

[Diane Poremsky [MVP]]

do you have enough memory to use a group by view and delete the group?
Assuming you can find a field to group by that removes the good contacts
from the group....

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/



Subscribe to Exchange Messaging Outlook newsletter:
(e-mail address removed)

 

[Joel Leonhardt]

Could you temporarily increase your virtual memory? Remember to change the
memory back afterwards. You would probably need to reboot for each change.

Start -> Control Panel -> System -> Advanced -> Virtual Memory

Use the suggestion from Diane Poremsky if you can. It would be much faster
than this one.