Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / September 2004

Tip: Looking for answers? Try searching our database.

How do I delete 1000s of blank Outlook Contacts?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BaileyMom - 12 Sep 2004 22:27 GMT
I was trying to import records from Excel into Outlook and in the trial and
error before I got it done successfully I managed to generate literally 50
THOUSAND or so blank records in Outlook!  

Is there a fast way to delete them?  They are making it impossible to hot
sync my Outlook with my Palm.

Thanks in advance for help!
BaileyMom - 12 Sep 2004 23:01 GMT
OK, I figured it out myself and am posting to help anyone else who might
encounter the same problem.

I had been deleting them by marking the first, then holding the shift key
and selecting the last on a given page and hitting the delete key.  The
apparancy was that none were being deleted, because there were so many, but
in fact they were being deleted.  Problem was, doing it one page (screen
view) at a time would have taken weeks!!!

I turned on the Status bar and saw there were over 58,000 records (only
about 600 weren't blanks).  I selected the first, then using the scroll bar
slider, moved it about one column's worth and, holding the shift down,
selected the last one on the resulting page.  There were so many the
selection took a few seconds!  I then hit the "delete" key and kept my eye on
the count on the "Status Bar" the count went down by 10,000 or so!  So it was
working.  I repeated this until all the blanks were gone and I was back to
just populated records.  It only took a few minutes.

Hope this helps someone!

> I was trying to import records from Excel into Outlook and in the trial and
> error before I got it done successfully I managed to generate literally 50
[quoted text clipped - 4 lines]
>
> Thanks in advance for help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.