Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Importing into Outlook Contacts from Excel

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to import a spreadsheet filled with names, addresses and numbers from Excel into my Contact file. When I go through the steps using the wizard in Outlook, it tells me that I need to go to my Excel spreadsheet and select the range of data that I want to import. I need to know how to do that. Does anybody know???

  2. #2
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This basically means select all of the information you have.

    If your first entry begins in A1 and the last entry's information ends in F5, just click in A1 and hold down the button. Drag the mouse until all of your information is selected and let go.

    Hope this helps,
    Kristy

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the tip. I used the wrong word though. It asks to Name the range of data you want to import. The Excel spreadsheet has to be closed before it can be imported, so, just selecting the data doesn't work.

  4. #4
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok. Well, to name a range, you still have to start out by selecting your information.

    There is a little box with a dropdown arrow right above column A that tells you what cell your cursor is in. That is the "name box." Click in there and name it contacts or whatever you wish.


    Kristy

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried that. I named the ranges, example column A I named "Names" and selected all the names under it and column B I named Address, etc. When I went to import into Outlook it imported each cell as an individual contact. So, I had one contact that had just a name in it and another contact that had just an address in it. How do I get the names, addresses and number in the same contact and create one contact for each row of information?

  6. #6
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried to do this, but Outlook here at work won't let me. Something wasn't installed.

    Anyway, I think that might have something to do with how you named it. Try selecting everything at once (not column by column)and give it one name, so you only have one big range.

    Let me know if it works!
    Hope it helps,
    Kristy

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I wish you could get to it! You have to have the disk to install it. Anyway, I tried that too. I selected a single row and called it "Contacts" and when I went to import it, it asked me to match the fields with the field in the Outlook Contact file. I did that and everything seemed to go ok, but when I went to try and find the contact I just imported I couldn't find it anywhere! I did a find search, I looked in each alphabet, but it's not there. I imported it, but I just don't know where I imported it to! I think I'm going to throw out my computer!

  8. #8
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hmm. I wish I could help you more, but apparantely I can't

    There is a new page for Microsoft Office in general here. There's a forum there, too. Maybe they can help you a little better than we can here!

    Good luck!
    Kristy

  9. #9
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for all your help!

    Soo close, but yet soo far.......

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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