how to import contacts into outlook 2007 from excel

Using 'Import and Export Wizard', CSV file and MS Excel we can achieve our target and add all email senders or recipients as contacts. But some smart techniques can be utilized to do this and this will not require any extra gadget or toolbox. If you drop a field on the wrong Outlook field, drop it again on the correct field and Outlook will remove it from the other field.MS Outlook does not provide any direct way of saving of adding contacts from senders' or recipients' list as contacts.Use these same steps with Contacts, choosing a Contacts folder (obviously).To import into either, create a calendar folder for the import and move the appointments after the import. You cannot import into a public folder calendar or secondary Exchange mailbox.You can import calendar data into any calendar folder in any *.pst or your mailbox.

Outlook 2007 uses the Excel 97-2003 *.xls format, not the Excel 2007 *.xlsx file format.Outlook 2013 and up can only save as a CSV file.Press Next when ready and finish the import.If you aren't using the field names that Outlook uses, you'll need to map your fields to Outlook's fields.Just make sure you select the correct named range. If you export to Excel to get the field names, you'll see two named ranges when you import. Select the Calendar (or Contact) folder.Save the workbook as an Excel 97-2003 workbook.(Include the field names in your selection.) Select your used data range and type a name in the field to the left of the address bar.If you have data in cells that you are not going to import, create a named range: Save the workbook as Comma Separated Values (CSV).This is the easiest way for most users to import an Excel worksheet trouble-free and we recommend using CSV format when possible.

If you are importing all of the data in the worksheet, save the workbook in CSV format.

How to import contacts into outlook 2007 from excel