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

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.