How do I import a CSV file into a specific Contact Group in Outlook 2010?

Posted on 2011-05-02
Last Modified: 2012-05-11
I am running Outlook 2010. I have created a contact group inside my main contacts folder. I want to import a csv file directly into that specific contact group. I go through the import process (File>Open>Import...) and when it asks me what the destination folder is, I can only choose the contacts folder, not a specific contact group within the contacts folder. Is there any way to import a csv file directly into the contact group? I don't want to import my list into the contacts folder and have to sort through them into the contact group afterwards. That would be quite time-consuming. Thank you!

The part I get stuck at...
Question by:Philip_Stancil
    LVL 23

    Accepted Solution

    I'm not sure that importing a CSV file into a Distribution List (contact group) can be done without some VBA involved. But there is a real easy way to do what you're trying to accomplish.

    We will need to create a new Contact folder in Outlook, and we'll make it a subfolder of the Contacts folder itself. This new subfolder can be deleted after we're done with the objective of populating the Distribution List.

    First, make sure the Folder List view is selected in Outlook and that you are clicked on to the Contacts folder (so you can see your contacts in the right-side window). Next go to File > New > Folder. Name the folder (in the Name field) Test and you will see the Folder contains dropdown box below says Contact Items. Click OK after you're done.

    Now on the Folder List, you will see your Contacts folder with another contact folder beneath it called Test.

    Next, you will import the CSV file to the Test contact folder. When going through the import process, just be sure to select the folder at the Select Destination Folder screen. After the import is complete, you will see the contacts from the CSV file have populated the Test folder and these contacts are isolated from your main Contacts folder.

    Finally, you will go back to your main Contacts folder and you will open the Distribution List that needs to be populated. With the Distribution List open, click the Select Members button, then go to the Show Names from the dropdown list and select the Test contact list listed here. Below, the contacts that were in the CSV file are listed, and you can select the first contact in the list and then click the SHIFT + End keys on your keyboard to select them all at once. After they are all selected, click the Members button below to add them to the Distribution List, and then press the OK button once you have finished.

    You should see that all of your contacts from the Test contact folder have now populated the Distribution List like you needed. You can delete the Test contact folder whenever you want afterward.

    Author Closing Comment

    The solution worked perfectly. Only issue is that the step-by-step seemed to be for use in Outlook 2007, not 2010. I was unable to follow the specific steps and had to use Google to figure out the 2010 steps.
    LVL 23

    Expert Comment

    by:Brian Gee
    Sorry about that... I should've read more carefully to get you the Outlook 2010 instructions. Thank you for accepting my resolution in light of my oversight.

    Author Comment

    Thank you for the help! I had a client who was looking to me to provide a solution and I couldn't find anything on the web offering the solution like you did. You saved me tons of time and gave me a happy client!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
    Outlook Free & Paid Tools
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now