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

Hi,

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
 
 

Quote:

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
Reply

 Importing Contacts to Outlook




Thread Tools



Similar help and support threads for2: Importing Contacts to Outlook
Thread Forum
Solved Outlook 2010 problem importing contacts Microsoft Office
Solved Importing Contacts to WLM Browsers & Mail
Importing contacts from Outlook to Live Mail Browsers & Mail
Importing contacts from outlook into ms fax win7 Microsoft Office
Importing contacts Browsers & Mail
Importing Outlook Express contacts to Windows Live Mail Browsers & Mail

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 09:41 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33