Friday, June 8, 2012

How to Import Excel into Outlook 2007

Import Excel into Outlook 2007 Both Excel and Outlook are Microsoft programs. Excel is a spreadsheet program and Outlook is popular email management software. Suppose, if you have contacts in Microsoft Excel spreadsheet and you want to import them into outlook 2007, then you can easily do that. Follow the given steps to import excel contacts into outlook 2007.

Exporting from Excel

  • Open your Excel sheet. If your spreadsheet contains column description, such as name, email address and so on (otherwise fill first row, in each column like name, address etc.), then save this file into a folder with a specific name like-“contacts” and select the Save Type as CSV (Comma delimited). Just remember the folder location.

Import into outlook:

Step1: 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.

Step2: Right-click the Contacts folder, and then click New Folder, type a name for the new folder, and then click OK.

Step3: On the File menu, click Import and Export, click Next, click Comma Separated Values (Windows), and then click Next.

Step4: 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.

Step5: 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.

Step6: Click the Contacts folder, or other contacts-type folder that you have created, to import into, and then click Next.

Step7: 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.

If you want to get technical support on Microsoft outlook , you can reach online technical support service desk of V tech-squad at their Toll Free No +1-877-452-9201.

See also:Microsoft Outlook Won't Open
               How to Add a Mailbox to Outlook 2010

No comments:

Post a Comment