Outlook 2003, import contacts from Excel

Discussion in 'Windows Desktop Systems' started by gpan123, May 9, 2006.

  1. gpan123

    gpan123 OSNN One Post Wonder

    Messages:
    4
    hi,

    I try to import contacts from Excel but I get an error message
    (the records are in columns, each column a field)...

    In addition I tried something else:
    1) I create a record in Contacts
    2) Export this in a Excel file
    3) Pasted the records from my file
    4) Import in Outlook
    5) PROBLEM. Only the first record was imported

    to overcome this I created 180 Contacts and again steps 2,3,4,5
    and it was ok....

    This doesn't seem right is there any other way, method. Some rules and conditions i should know?
     
  2. technokid88

    technokid88 Part of a System Folding Team

    Messages:
    741
    Location:
    In a world without windows
  3. gpan123

    gpan123 OSNN One Post Wonder

    Messages:
    4
    I tried those steps (there is no other way) but in my case it doesn't seem so simple.
     
  4. technokid88

    technokid88 Part of a System Folding Team

    Messages:
    741
    Location:
    In a world without windows
    Not sure why it didn't work, dont know about any other way of doing it
     
  5. madmatt

    madmatt Bow Down to the King Political User

    Messages:
    13,312
    Location:
    New York
    In Excel, are you using unformatted text and saving the information as a CSV?
     
  6. fitz

    fitz Just Floating Along Staff Member Political User Folding Team

    Messages:
    4,076
    Location:
    Chicagoland
    it would probaby be a little more helpful if you gave us the error message that came up..
     
  7. gpan123

    gpan123 OSNN One Post Wonder

    Messages:
    4
    the error message i get in the first case is about "name ranges"

    no, i don't use CSV...

    all cells are in General format
     
  8. gpan123

    gpan123 OSNN One Post Wonder

    Messages:
    4
    listen to this!!!! Strange.!!???

    I export a category in an Excel file, and send it to a friend. He made some changes and delete some Columns....

    ...and guess what? I couldn't import the new file (with allow duplicates ON)