Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 02-02-2010
Member
 
Join Date: Mar 2009
Posts: 19
Importing contacts from an Excel file

hello,

I want to import my outlook contacts a list of email addresses i have in an Excel file, How can i do this? please let me know the step wise procedure because i haven't done it before.

Thanking you...
Reply With Quote
  #2  
Old 02-02-2010
Member
 
Join Date: Oct 2008
Posts: 172
Re: Importing contacts from an Excel file

Firstly it is necessary that in Excel you put in the headers (Name, email, etc etc ...) and especially that you have named the area to import. Attention no merged cells or other close contact with seizures of 2 different lines, it must file either a very simplistic containing only data. Then in File Menu, Import and export.
Reply With Quote
  #3  
Old 02-02-2010
Member
 
Join Date: May 2008
Posts: 4,080
Re: Importing contacts from an Excel file

To import contacts from a CSV file or from Excel into Outlook:
  • In File -> Import and Export
  • select the desired file.
  • Select the Outlook folder you want to import the contacts to. This will usually be your Contacts folder.
  • Click OK.
  • Now click Finish.
Reply With Quote
  #4  
Old 02-02-2010
Member
 
Join Date: Sep 2005
Posts: 1,306
Re: Importing contacts from an Excel file

In Excel

Select ALL the import data and the row headers, click in the "Name" Excel (where the address appears pointer cell A1), type (not too strong) any name and press [Enter]. Save the file and exit Excel.

In Outlook

File Menu, Import and export, Import from another program or file, Next, Microsoft Excel, Next, Browse to select the file, Ok Choose the options you want no-duplication, Next, Choose destination folder, Next, Check the box that you named above and click the button Custom Fields so as to match your headers to Excel with the field names in Outlook.
Reply With Quote
  #5  
Old 02-02-2010
Member
 
Join Date: Jan 2008
Posts: 3,751
Re: Importing contacts from an Excel file

In 99% of cases, you have a field in Excel is called "Name" and Outlook does not involve the proper scope of contacts.

By default, the Name field Excel is associated with HEADING "Name" column that contains itself the "Name" field, the latter you must use or lose contact names when importing. Drag the field Name the left column on the field Name the right hand column (not the topic that includes a [+] or [-] before !!!), once all the associations made, click OK then Finish to start importing.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Importing contacts from an Excel file"
Thread Thread Starter Forum Replies Last Post
Importing a text file in vba in Microsoft Excel Kaesav MS Office Support 4 24-01-2012 05:16 PM
Need help in Importing Google Contacts into iCloud on iphone 4s Sru S Portable Devices 7 25-12-2011 10:08 AM
Importing contacts to NITroid Bejan Daroowala Portable Devices 3 12-02-2011 09:04 PM
Error while importing data to excel file Rutajit Windows Software 3 07-05-2009 11:38 PM
Importing Contacts from Outlook CSV to Vista Contacts rocktrng Vista Help 6 22-12-2007 06:21 AM


All times are GMT +5.5. The time now is 03:21 PM.