Results 1 to 6 of 6

Thread: Import contacts in Outlook from Excel

  1. #1
    Join Date
    May 2008
    Posts
    36

    Import contacts in Outlook from Excel

    How to import a contact list from Excel to Outlook, not putting in only one contact list and not contact by contact?

  2. #2
    Dr. V Guest
    try using Excel 2000 and Outlook 2000 software .

  3. #3
    Join Date
    May 2008
    Posts
    36
    can you explain me the Method . im really nob in this things

  4. #4
    Dr. V Guest
    • When you are in the Excel file: add a column "Category" and put in "professional" or anything else, when it corresponds to a category in Outlook (if necessary, create front)
    • Then appoint its beach cell
    • Open Outlook Express


    If we do not want all these are scattered in "Contact" is created in it a specific folder and read the import procedure, but do not forget to mapping by clicking on the button " Custom Fields "and involve the scope category of file to the Outlook.

    • After the successful import, create a distribution list in this new folder containing the imported contacts
    • For "select new members" we will look in the folder contact sorting on the topic: all new displays
    • There is more to select the first and the last to hold the shift key: it selects all the
    • Click on "Add"

  5. #5
    Join Date
    Dec 2007
    Posts
    1,727
    The Import and Export Wizard in Outlook makes it easy to import contact information from an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) into your Outlook Contacts folder.

    1. In Outlook, on the File menu, click Import and Export.
    2. Click Import from another program or file, and then click Next.
    3. Click Microsoft Excel, and then click Next.
    4. In the File to import box, browse to find the Excel file (.xls) that contains the content you want to import.
    5. Click one of the following:
    • Replace duplicates with items imported
    • Allow duplicates to be created
    • Do not import duplicate items

    6. Click Next.
    7. In the folder list, click the Contacts folder where you want the imported contact information to go, and then click Next.
    8. To add or remove fields to determine the way the contact information is saved in the new imported file, click Map Custom Fields.

    Note The Map Custom Fields button in the Import a File dialog box might not be available when you try to import data from another program or file. In the The Following Actions Will Be Performed box, select the Import check box, and then the Map Custom Fields button is available.

    # In the From box, drag the field that you want to convert onto the Outlook field that is listed in the To box.

    Note The Name field doesn't appear in the To box, because Outlook reserves the first row of a named (name: A word or string of characters in Excel that represents a cell, range of cells, formula, or constant value.) range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) for field names. If the range that you import does not contain field names, the first row of data will be interpreted as field names and will not be imported as data. To make sure that all of the data in the named range is imported, use the first row for field names.

    * To see additional records in the From box, click Previous or Next.
    * To remove all mapping, click Clear Map.
    * To reset the original mapping, click Default Map.

    # To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the plus sign (+) next to Business Address.
    9. Click Finish.

  6. #6
    Join Date
    Nov 2008
    Posts
    1

    Re: Import contacts in Outlook from Excel

    I have tried Excel to Outlook software to import my contacts in Outlook from MS Excel File.

    This tool is simple and helped me in a great way..

Similar Threads

  1. How import contacts to Desire from excel
    By INDRASENA in forum Portable Devices
    Replies: 4
    Last Post: 19-01-2011, 05:05 AM
  2. Unable to import contacts in MS Outlook 2010
    By DIsha Char in forum Windows Software
    Replies: 4
    Last Post: 04-12-2010, 12:18 AM
  3. How to Import Ms Outlook contacts into Entourage
    By monsitj in forum Tips & Tweaks
    Replies: 1
    Last Post: 07-02-2010, 04:28 AM
  4. How to import outlook contacts to blackberry storm
    By Drogbaa in forum Portable Devices
    Replies: 7
    Last Post: 11-08-2009, 07:10 PM
  5. How to import google contacts in outlook
    By Akiraa in forum Windows Software
    Replies: 3
    Last Post: 19-05-2009, 10:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,615,088.72038 seconds with 17 queries