How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 37653
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I just created an excel list from my customer report list in

This answer was rated:

I just created an excel list from my customer report list in quickbooks. The excel list has two columns: Name and Email address. I would like to add this complete list (about 50 names) to my outlook contact list as a group listing. I have no clue how to do this.
Hi there and welcome
To do this, you will need to do the following
Select File | Import and Export... from the menu in Outlook.
Make sure Import from another program or file is highlighted.
Click Next >.
Now make sure Comma Separated Values (Windows) is selected.
Click Next >.
Use the Browse ... button the select the desired file (the excel file from Quicken).
Choose Do not import duplicate items.
Click Next >.
Select the Outlook folder you want to import the contacts to. This will usually be your Contacts folder.
Click Next >.
Click Map Custom Fields ....
Make sure all columns from the CSV file are mapped to the desired Outlook address book fields.
You can create new mappings by dragging the column title to the desired field.
Any previous mapping of the same column will be replaced with the new.
Click OK.
Now click Finish.
Once the import is complete, the contacts are than in outlook. To group these so that they are all in one group, please follow the instructions on the below link.
You are than complete.
If you have any difficulties, please do not hesitate to let me know so I can assist you further.
Thank you
Richard and 2 other Microsoft Office Specialists are ready to help you