Importing into Outlook Contacts from Excel

Shantel · Mar 21st, 2002, 11:52 AM

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???

Von Pookie · Mar 21st, 2002, 12:01 PM

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,

Shantel · Mar 21st, 2002, 12:16 PM

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.

Von Pookie · Mar 21st, 2002, 12:20 PM

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.

Shantel · Mar 21st, 2002, 01:08 PM

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?

Von Pookie · Mar 21st, 2002, 01:59 PM

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,

Shantel · Mar 21st, 2002, 02:10 PM

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!

Von Pookie · Mar 21st, 2002, 02:29 PM

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!

Shantel · Mar 21st, 2002, 02:32 PM

Thanks for all your help!

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

Mar 21st, 2002, 12:01 PM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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 How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Mar 21st, 2002, 12:20 PM	#4
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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 How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Mar 21st, 2002, 01:59 PM	#6
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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 How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Mar 21st, 2002, 02:29 PM	#8
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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 How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 11:52 AM	#1
Shantel New Member Join Date: Mar 2002 Posts: 5	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???

Mar 21st, 2002, 12:16 PM	#3
Shantel New Member Join Date: Mar 2002 Posts: 5	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.

Mar 21st, 2002, 01:08 PM	#5
Shantel New Member Join Date: Mar 2002 Posts: 5	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?

Mar 21st, 2002, 02:10 PM	#7
Shantel New Member Join Date: Mar 2002 Posts: 5	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!

Mar 21st, 2002, 02:32 PM	#9
Shantel New Member Join Date: Mar 2002 Posts: 5	Thanks for all your help! Soo close, but yet soo far.......