PREMNAIR'S Blog

"..Unnatural work produces too much stress.."

Import contacts into Outlook from Excel

Exporting from Excel

  1. If row 1 of your spreadsheet contains column descriptions, such as “Name,” “E-mail Address,” and so on, skip to step 3. If it does not, add one that does by right-clicking the 1 to the left of the first row, and then clicking Insert.
  2. In the new blank cells at the top of each column, type a description for that column, such as “Name,” “E-mail Address,” “Company,” “Phone Number,” and so on.
  3. On the File menu, click Save As.
  4. Choose a folder to save to from the Save in drop-down list, type a name for the file, such as “Contacts,” in the File name box, and in the Save as type drop-down list, click CSV (Comma delimited).
  5. Make a note of the folder location, and then click SAVE.

Importing into Outlook (older versions)

  1. If you are importing into an existing Contacts folder, skip to step 3. To create a new folder in Outlook, click Folder List on the View menu, unless the Folder List is open already.
  2. Right-click the Contacts folder, and then click New Folder, type a name for the new folder, and then click OK.
  3. On the File menu, click Import and Export, click Next, click Comma Separated Values (Windows), and then click Next.
  4. If the file that is displayed is not the correct file, click Browse, browse to the folder noted in step 3, and then double-click the file to select it.
  5. If you are importing into a new folder, the Options settings is irrelevant because there are no duplicates. If not, choose the most logical selection. Click Allow duplicates if you are not sure, and then click Next.
  6. Click the Contacts folder, or other contacts-type folder that you have created, to import into, and then click Next.
  7. If you are not sure that the column names in the first row of the spreadsheet will map correctly to the Outlook fields, click Map custom fields to verify them.

    NOTE: If Map custom fields is unavailable, you have chosen a non-contact-type folder to import into. Click Back, and then choose the correct folder. If you are satisfied with the mapping, click OK to close the Map Custom Fields dialog box, and then click Finish.

Importing into Outlook 2010

  1. If you are importing into an existing Contacts folder, skip to step 4.
  2. Create a new folder in Outlook 2010
  3. Right-click the Contacts folder, click New Folder, type a name for the new folder, and then click OK.
  4. Click the File tab in the Ribbon, and then click Open on the menu.
  5. Click on Import tab. The Import and Export Wizard opens.
  6. If the file that is displayed is not the correct file, click Browse , browse to the folder that is mentioned in step 3, and then double-click the file to select it.
  7. If you are importing into a new folder, the Options settings are irrelevant because there are no duplicates. If you are not importing to a new folder, choose the most logical selection. Click Allow duplicates if you are not sure, and then click Next .
  8. Click the Contacts folder or another contacts-type folder that you have created, and then click Next.
  9. If you are not sure that the column names in the first row of the spreadsheet will map correctly to the Outlook fields, click Map custom fields to verify them.
Advertisements

April 19, 2012 - Posted by | Mails, Microsoft, Office, Office 2010, Office 365, Outlook, Outlook Webapps, Software |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: