Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    export to Outlook (2000)

    I have an excel worksheet with about 30 row --names, addresses, etc that I want to import into Contacts. My column headings match up with the names in Outlook. It imports only the first row on my excel sheet. Any suggestions?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: export to Outlook (2000)

    You need to save the Excel worksheet as a CSV (Comma Separated Values) file. If you haven't done this, use File|Save As and then tab down in the lower combo box until you get to CSV file. Tell Excel you want to carry on when it warns you that you'll lose lots of features. HTH
    Gre

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: export to Outlook (2000)

    Do these 2 MS articles help:
    Import contacts from Excel to Outlook

    How to Import and Export Text Data with Outlook
    With this you would export excel as text data.
    Steve

  4. #4
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: export to Outlook (2000)

    thanks--that worked great. Now, any ideas why all the information except the email addresses imported?

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: export to Outlook (2000)

    If you are still having trouble with the e-mail addresses, go back to the original XLS file. Open it and make sure that the e-mail addresses are showing as text (no hyperlinks). If necessary, try highlighting the column, copying, and then choosing Edit|Paste Special|Values. If it then "auto-magically" converts them back to hyperlinks again, immediately press CTRL+Z. Then try the CSV routine all over again. HTH
    Gre

  6. #6
    Star Lounger
    Join Date
    Oct 2004
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: export to Outlook (2000)

    I did one of the steps sugested in the article that suggested creating a new folder and exporting it to make sure the column heading were correct. I changed email to e-mail and did the CSV again and it worked great. Thanks to everyone for all the quick helpful responses! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •