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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
problem after importing from Excel
I imported names from an Excel spreadsheet to Outlook. Something has gone
horribly wrong! I now have 32,750 blank contacts in my Contacts folder. The legitimate contacts from the spreadsheet, which number about 15, are not in the Address Book since I hadn't imported the email addresses yet. HOW do I fix this? |
Ads |
#2
|
|||
|
|||
problem after importing from Excel
"LAV" wrote in message
... I imported names from an Excel spreadsheet to Outlook. Something has gone horribly wrong! I now have 32,750 blank contacts in my Contacts folder. The legitimate contacts from the spreadsheet, which number about 15, are not in the Address Book since I hadn't imported the email addresses yet. HOW do I fix this? Why did you import the Names at a different time to the email addresses? Why not import them all at once? Did you export a contact from Outlook to check that your Excel spreadsheet was in the same format? Did you name the range in Excel? |
#3
|
|||
|
|||
problem after importing from Excel
I can answer all your questions by saying I clearly did not know what I was
doing. I went to Help in Excel to find out how to export from Excel to Outlook and thought I was following the directions. I didn't know how to do 2 columns at once, so I took the first column, A, called it "names" and followed the directions in Help. "Gordon" wrote: "LAV" wrote in message ... I imported names from an Excel spreadsheet to Outlook. Something has gone horribly wrong! I now have 32,750 blank contacts in my Contacts folder. The legitimate contacts from the spreadsheet, which number about 15, are not in the Address Book since I hadn't imported the email addresses yet. HOW do I fix this? Why did you import the Names at a different time to the email addresses? Why not import them all at once? Did you export a contact from Outlook to check that your Excel spreadsheet was in the same format? Did you name the range in Excel? |
#4
|
|||
|
|||
problem after importing from Excel
"LAV" wrote in message
... I can answer all your questions by saying I clearly did not know what I was doing. I went to Help in Excel to find out how to export from Excel to Outlook and thought I was following the directions. I didn't know how to do 2 columns at once, so I took the first column, A, called it "names" and followed the directions in Help. OK. So what you need to do is do delete all the wrong contacts in Outlook. if you use the "Categories" view then you should be able to select them all at one go. Then, either export an existing contact (or create one if you haven't got any) to Excel and check that the worksheet you want to import from is of the same format. Then, in the worksheet you want to import, select all the data, and give that range name. then, in Outlook, do File-Import. HTH |
#5
|
|||
|
|||
problem after importing from Excel
Thanks Gordon. I really appreciate your help.
In Contacts, while looking at the view by Category, I do not see where I have the ability to select anything. There seems to be only the ability to change how the contacts are sorted (i.e. icon, attachments, flags). I calculated that if I manually deleted one entry per second it would take about 9 hours of continuous deletion. Please don't suggest THAT option! But seriously, is there a way to copy my contacts to another place, delete the entire list, then reinstate my saved contacts? "Gordon" wrote: "LAV" wrote in message ... I can answer all your questions by saying I clearly did not know what I was doing. I went to Help in Excel to find out how to export from Excel to Outlook and thought I was following the directions. I didn't know how to do 2 columns at once, so I took the first column, A, called it "names" and followed the directions in Help. OK. So what you need to do is do delete all the wrong contacts in Outlook. if you use the "Categories" view then you should be able to select them all at one go. Then, either export an existing contact (or create one if you haven't got any) to Excel and check that the worksheet you want to import from is of the same format. Then, in the worksheet you want to import, select all the data, and give that range name. then, in Outlook, do File-Import. HTH |
#6
|
|||
|
|||
problem after importing from Excel
Ps. I should also mention I have Vista and Microsoft Office 2003.
Thanks again! "Gordon" wrote: "LAV" wrote in message ... I can answer all your questions by saying I clearly did not know what I was doing. I went to Help in Excel to find out how to export from Excel to Outlook and thought I was following the directions. I didn't know how to do 2 columns at once, so I took the first column, A, called it "names" and followed the directions in Help. OK. So what you need to do is do delete all the wrong contacts in Outlook. if you use the "Categories" view then you should be able to select them all at one go. Then, either export an existing contact (or create one if you haven't got any) to Excel and check that the worksheet you want to import from is of the same format. Then, in the worksheet you want to import, select all the data, and give that range name. then, in Outlook, do File-Import. HTH |
#7
|
|||
|
|||
problem after importing from Excel
"LAV" wrote in message
... Thanks Gordon. I really appreciate your help. In Contacts, while looking at the view by Category, I do not see where I have the ability to select anything. Sort by Name, so all the blank contacts are in one block. Click on the top contact (highlight it), then scroll down to the bottom of the block, and click on the bottom contact using Shift-Click. If you do this right, that will select ALL the contacts in between the two. Then hit "Delete". HTH |
#8
|
|||
|
|||
problem after importing from Excel
Thank you!!
You are a GENIUS!!!!!!!! LAV "Gordon" wrote: "LAV" wrote in message ... Thanks Gordon. I really appreciate your help. In Contacts, while looking at the view by Category, I do not see where I have the ability to select anything. Sort by Name, so all the blank contacts are in one block. Click on the top contact (highlight it), then scroll down to the bottom of the block, and click on the bottom contact using Shift-Click. If you do this right, that will select ALL the contacts in between the two. Then hit "Delete". HTH |
#9
|
|||
|
|||
problem after importing from Excel
"LAV" wrote in message
... Thank you!! You are a GENIUS!!!!!!!! LAV YW! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing from Excel | phd | Outlook - Using Contacts | 12 | November 19th 08 08:46 PM |
Problem importing excel files into outlook contacts | RobinSuz | Outlook - Using Contacts | 2 | July 30th 07 01:24 AM |
Problem importing ZIP codes from Excel 2002 into Outlook 2003 cont | PWN2 | Outlook - Using Contacts | 1 | July 11th 07 08:35 AM |
problem importing Excel into outlook | Dory | Outlook - Using Contacts | 2 | April 5th 07 06:48 PM |
Importing from Excel | phd | Outlook - Using Contacts | 0 | July 9th 06 10:20 PM |