A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , , ,

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





 
 
Thread Tools Display Modes
  #1  
Old March 7th 06, 02:34 PM posted to microsoft.public.outlook.contacts
ynezllapa
external usenet poster
 
Posts: 1
Default How do I quickly delete over 50,000 blank entries from Contacts?

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.
Ads
  #2  
Old March 7th 06, 03:07 PM posted to microsoft.public.outlook.contacts
Diane Poremsky [MVP]
external usenet poster
 
Posts: 4,804
Default How do I quickly delete over 50,000 blank entries from Contacts?

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/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"ynezllapa" wrote in message
...
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.



  #3  
Old March 7th 06, 04:20 PM posted to microsoft.public.outlook.contacts
Joel Leonhardt
external usenet poster
 
Posts: 9
Default How do I quickly delete over 50,000 blank entries from Contacts?

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.


"ynezllapa" wrote:

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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I eliminate duplicate entries in my Contacts folder RevDuncan Outlook - Using Contacts 1 March 4th 06 03:12 PM
Delete blank Contacts when Outlook lockedup Know enough 2B dangerous Outlook - Using Contacts 9 February 22nd 06 01:18 AM
Quickly linking emails to their contacts in Outlook 2003 XP Scott Johnson Outlook - Using Contacts 0 February 1st 06 12:22 AM
How do you hide blank fields in outlook contacts Theb55 Outlook - Using Contacts 0 January 26th 06 11:06 PM
How do I see my contacts when writing a new email? It is blank. Nanci Outlook - Using Contacts 1 January 21st 06 09:57 PM


All times are GMT +1. The time now is 07:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Mortgages - Loans - Project management - Loans - Remortgages