How to Import Mailing / Contact List from Excel Sheets to Outlook?

If you contained list of contacts in Microsoft Excel spreadsheet and want to access it through Microsoft Outlook or to other application that may access Address Book. Then use an Import feature.

To Import Excel File in Outlook First Export It into CSV Format

Open Excel Files that contain mailing list and save it into CSV format.
OR Right click on excel file and choose Rename option.
Change the extension of excel file from .xlsx to .csv.

Import Contact list into Outlook 2003 & 2007

STEP 1

If you are importing contacts into existing folder then skip step 3. To create few folders in Outlook, click Folder list on view menu, unless Folder list is open already.

STEP 2

Right click on Contact folder and then click New Folder, type name for new folder and then click Ok.

STEP 3

On the "File" menu, click "Import and Export" >> "Next" >> "Comma Separated Values" >> "Next".

STEP 4

Click on the "Browse" button to select the file.

STEP 5

Select the "File" and Click on "OK" button.

STEP 6

If the file has been imported in the new folder, then the option setting is unnecessary as there are no duplicates, If not select the logical selection. Check Allow duplicates box if you are not assured and click Next.

STEP 7

If is found that the column name in first row of spreadsheet was not map correctly to Outlook fields, then click "Map custom field" to verify.

STEP 8

Note: If Map custom field is not unavailable, you can choose non contact type folder to import into. Click Back then select the correct folder. It not satisfied with mapping, click Ok to close "Map Custom Field" dialog box and click "Finish".

Note: If you want to send a particular email to a set of contacts than create a Distribution list by following the given below steps:

STEP 1

Go to the "File" menu, select "New", then "Distribution List".

STEP 2

Create a "name" for the list, then click "Select Members" button.

STEP 3

Know select Member list and click on Ok.

STEP 4

After "selecting a member list", click on the "save and close" button to save distribution list.

Import Contact list into Outlook 2010 & 2013

STEP 1

Create new folder in MS Outlook 2010.

"Right click" on Contact folder, then "New Folder", type a name for "new folder" and then click "OK".

STEP 2

Now click on "File" tab in Ribbon, and then "Open" on menu.

STEP 3

Click "Import" tab, "Import and Export Wizard" opens>>"Import to a file" >> "Next" >> "Comma Separated Values" >> "Next"

STEP 4

Click on "browse" button to select the file.

STEP 5

If the contacts has been importing into a new folder, then the Option setting is unnecessary as there are no duplicates. If you are importing contacts into existing folder then select the logical selection, Click on "Allow duplicates" if not assured, and click "Next".

STEP 6

Click "Contacts folder" that you have created and then "Next".

STEP 7

If you are assured that the column name in first row of spreadsheet will map correctly to Outlook field, then click "Map custom field" to verify.

STEP 8

Drag the information from "Left to Right" panel according to the desire from incoming file to Outlook and then click "OK".

STEP 9

Click "Finish" button.

Note: If you want to send a particular email to a set of contacts than create a contact group in Outlook 2010 by following the given below steps:

STEP 1

Go to the "Home" tab and click on the "new Contact group".

STEP 2

"Add a name" and after that click on "add members button" to add members in the new created group.

STEP 3

After clicking on the add members button you will get three options: "From Outlook Contacts", "From Address Book", "New Email Account".

STEP 4

Now select the "1st option" and "double click on contact" which you want to add in the group and after that click "OK" button.

STEP 5

Now click on "Save and Close" button to save group.