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 / August 2007

Tip: Looking for answers? Try searching our database.

Import Contacts from Excel into Outlook 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kathy.DD - 31 Jul 2007 14:54 GMT
I'd like to import my contacts from Excel and created a file with about 1000
contacts.

Outlook just imports the first contact.

Can anybody help me?

Thank you.
Gordon - 31 Jul 2007 16:03 GMT
> I'd like to import my contacts from Excel and created a file with about
> 1000
[quoted text clipped - 5 lines]
>
> Thank you.

have you named the range in excel?
Kathy.DD - 01 Aug 2007 06:42 GMT
> have you named the range in excel?

At first thank you for your answer.

I don't know the meaning of your question.

First I exported a contact from Outlook into Excel. This sheet I used for my
new contacts. I tried to import this file into Outlook but just the first
contact was taken over.
Gordon - 01 Aug 2007 08:06 GMT
>> have you named the range in excel?
>
[quoted text clipped - 6 lines]
> new contacts. I tried to import this file into Outlook but just the first
> contact was taken over.

You need to name the range in the Excel spreadsheet.
Have a look here:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=281
Chet - 01 Aug 2007 04:00 GMT
Kathy,
Yes, it's a real problem.   I finally got it done but I don't know how I did
it so, unfortunately I can't help.

You will get typical answers like what Gordon sent.  Maybe he knows what
that means, but I don't.
Good luck getting an answer that says 1st do this, 2nd do this, etc., i.e.
rote instructions that work.  This is one of the most obtuse,
user-unfriendly things I've tried in 10 years of computing.  The people who
know the answer seem to be hiding it with unhelpful, non-detailed responses.
I don't know why.

Good luck.

C

> I'd like to import my contacts from Excel and created a file with about
> 1000
[quoted text clipped - 5 lines]
>
> Thank you.
Gordon - 01 Aug 2007 08:22 GMT
> Kathy,
> Yes, it's a real problem.   I finally got it done but I don't know how I
> did it so, unfortunately I can't help.
>
> You will get typical answers like what Gordon sent.  Maybe he knows what
> that means, but I don't.

then look up Naming Range in Excel help. It's all there......
Kathy.DD - 01 Aug 2007 08:38 GMT
Sorry, but I don't know the meaning of Range in German... The Excel help of
my German Office 2007 is not really helpful.
Jocelyn Fiorello [MVP - Outlook] - 05 Aug 2007 05:30 GMT
Kathy, just for future reference, you can find German-language Office
newsgroups by pointing your browser to
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx and
navigating under the "German" header in the left-hand pane.

Signature

Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***

> Sorry, but I don't know the meaning of Range in German... The Excel help of
> my German Office 2007 is not really helpful.
Sue Mosher [MVP-Outlook] - 01 Aug 2007 14:04 GMT
From the Excel 2007 Help topic "Use Names to Clarify Formulas," topic ID HV10147120 (I don't know if the IDs are the same in German as in English, but you can do a quick search in Help to find out), here's how to add a name to a range of selected cells:

1. Select the cell, range of cells, or nonadjacent selections that you want to name.
2. Click the Name box at the left end of the formula bar.
3. Type the name you want to use to refer to your selection. Names can be up to 255 characters in length.
4. Press Enter.

Save the worksheet as an .xls file to import into Outlook.

Or, skip naming the range and save the worksheet as a comma-delimited text (.csv) file, then use that file for the import.

Signature

Sue Mosher, Outlook MVP
  Author of Microsoft Outlook 2007 Programming:
    Jumpstart for Power Users and Administrators
   http://www.outlookcode.com/article.aspx?id=54

> I'd like to import my contacts from Excel and created a file with about 1000
> contacts.
[quoted text clipped - 4 lines]
>
> Thank you.
 
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.