Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Importing Contacts to Outlook

08 Sep 2010   #1

Windows 7 Something something
Importing Contacts to Outlook


I am having difficulty importing excel data into a contact list. Perhaps you can help me with my immediate problem or my overall goal.

The immediate problem: It makes a new contact for every piece of data. So, for instance, I would like to import one contact for every contact in the excel sheet. For every contact, I would like to put their administrative role, such as "Chapter President." I have mapped that to "Department," as shown in this screenshot. When Outlook makes the contact file, rather than make one contact with one person's first name, last name, and administrative role as department, it makes a new contact for every chapter admin, with no other detail than "Chapter Admin." It also makes one contact for every first name with not other details - so there are like, three "Julies" with no other information. What is happening?

Overall goal (all I want to do!): At the very least, I would like to email every contact from the excel spreadsheet at once. Ideally, I would like to be able to email all my "Chapter Presidents" at once, or all the parents of all these students at once, or all the students and parents at a certain high school at once. But it seems as though to add a new contact I will have to add a new contact one-by-one, since they are not already in my global address list. That is infeasible with hundreds of contacts total. Please, help! Also, this solution needs to be simpler than some crazy "CSV" format thing. I have wasted so much time at work struggling with this!

Thank you!

P.S. If you have any other ideas of any other forums I should post this on, your recommendations are much appreciated!!!

Attached Thumbnails
Importing Contacts to Outlook-many_chapter_admins.jpg   Importing Contacts to Outlook-mapping_access_role_to_dept.jpg  
My System SpecsSystem Spec
11 Sep 2010   #2

Windows 7 Ultimate 64bit


Overall goal (all I want to do!): At the very least, I would like to email every contact from the excel spreadsheet at once.

You can try Mail Merge feature using Excel.
My System SpecsSystem Spec

 Importing Contacts to Outlook

Thread Tools

Similar help and support threads
Thread Forum
Importing Windows 7 Contacts to Outlook 2016
I found the tutorial in this forum called, "How to Import Windows Contacts into Outlook 2010." It all looked very much like Outlook 2016, so I followed the same steps to import my Contacts list from Windows 7 Contacts to Outlook 2016. Everything seemed to go okay, but I cannot find them in...
Microsoft Office
Trouble importing exported Outlook contacts
I have Office 365 on a desktop and am having trouble importing a Contacts list I exported a few days ago. Am using Outlook 2016 on Windows 7. If I import the csv file, the contacts/address book are all blank. I looked at the csv file under Excel and it is blank until way down the sheet...
Microsoft Office
Outlook 2010 problem importing contacts
Hi I have Office 2010 which came bundled with Outlook. What I am trying to achieve is to trasnfer my iPhone contacts to my Outlook on my PC. I go through the iTunes contact sync and in iTunes I select Outlook as the option to sync with. After iTunes tells me the sync is complete, no contacts appear...
Microsoft Office
Importing contacts from Outlook to Live Mail
Is there a simple way to import email contacts from Outlook to Windows Live Mail?
Browsers & Mail
Importing contacts from outlook into ms fax win7
The import wizard only imports outlook express contact in wab file format. All my contact are in outlook in pst file. Can one convert or something?
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 00:21.
Twitter Facebook