Importing contacts from Excell file

Discussion in 'Microsoft Outlook BCM' started by pcserra, Mar 3, 2010.

  1. pcserra

    pcserra Guest

    Outlook 2007 - I´m trying to import contacts from an excell file. I have 1000
    contacts on the file but Outlook only imports about 114. I´ve tried several
    times and not always the same contacts are imported. What could be happening?
    How can I import all the files in the excell file? Is there a limit?
     
    pcserra, Mar 3, 2010
    #1
    1. Advertisements

  2. On 3/2/2010 8:22 PM, pcserra wrote:
    > Outlook 2007 - I´m trying to import contacts from an excell file. I have 1000
    > contacts on the file but Outlook only imports about 114. I´ve tried several
    > times and not always the same contacts are imported. What could be happening?
    > How can I import all the files in the excell file? Is there a limit?

    There are no limits.

    Are you importing into regular Outlook or are you trying to import into BCM?

    This is a BCM-specific group.

    Regardless, the procedure is as follows:

    1. Export an existing contacts folder as a CSV file
    2. Open the CSV in Excel
    3. Place your cursor in the A2 cell and press Ctrl-Shift-End
    4. Press Del

    You now hve a blank template that Outlook will import into contacts
    without issues.

    Now match your data to be imported with the columns in this file, save
    the file as a CSV, and import it into Outlook.
    --
    Leonid S. Knyshov
    Crashproof Solutions
    510-282-1008
    Twitter: @wiseleo
    http://crashproofsolutions.com
    Microsoft Small Business Specialist
    Please vote "helpful" if I helped you :)
     
    Leonid S. Knyshov // SBS Expert, Mar 3, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    1
    Views:
    476
    Guest
    Feb 18, 2006
  2. Guest
    Replies:
    1
    Views:
    335
    Leonid S. Knyshov
    Apr 7, 2006
  3. Guest
    Replies:
    3
    Views:
    391
    Burcu Kinay [MSFT]
    Apr 13, 2007
  4. Charles

    copy contacts in campaign to excell

    Charles, Jun 8, 2008, in forum: Microsoft Outlook BCM
    Replies:
    0
    Views:
    178
    Charles
    Jun 8, 2008
  5. mmullin
    Replies:
    6
    Views:
    684
    Luther
    Feb 10, 2009
Loading...

Share This Page