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
Tulin20m

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
-many_chapter_admins.jpg   -mapping_access_role_to_dept.jpg  
My System SpecsSystem Spec
.
11 Sep 2010   #2
prabz

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
Thread Forum
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
Importing contacts
I exported my Windows Live Mail address book (contacts) in the cvs file....they only give you two options to do this.....there is no WAB option.....I have TONS of folders (groups) and 2,900 contact emails.......when I import the cvs backup file into my other computer Windows Live Mail....it takes...
Browsers & Mail
Importing Outlook Express contacts to Windows Live Mail
Hi, I've read the other threads regarding my problem, but still can't figure out what to do. I backed up my files before installing Windows 7, and have an "Outlook Express" folder. However, I can't figure out how to import the contacts I had saved in my address book in Outlook. The Outlook...
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 12:19.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App