Sometimes the user needs to change, supplement, transfer the list of contacts to the right person, transfer it to an additional device. Outlook has all the tools you need to do this conveniently.

How to transfer addresses from Outlook

How to export contacts

Data transfer methods differ depending on the version of your Outlook email client.

Export contacts from Outlook 2013

  1. To export data from Outlook 2013, open the program and in the "File" - "Open and Export" tab, select "Import and Export".
  2. The email client will suggest possible options... Click on the "Export to file" item.

    3. Select the folder you want to write the information to.

    Give a name to the object to be saved and click the "Finish" button.

You can check the new CSV file on your computer by opening it in Excel.

Export contacts from Outlook 2010

  1. Open Outlook 2010 and go to the File tab.

    Click "File" in the Control Panel at the top of the Outlook window

    2. The Outlook Options window will open. In the left horizontal menu, click on "Advanced".

    The "Export Wizard" will open, here select "Comma Separated Values ​​(Windows)", this is another name for the CSV file. Click Next.

  2. Select the folder where the contact information will be stored.
  3. Wait until the process of transferring information is complete.

If you use the contents of the migrated contacts in other mail client products, you will need the item "Outlook Data File (PST)".

Export contacts from Outlook 2007

  1. To transfer contacts from Outlook 2007, open the program and expand the File tab. In the list of functions, click Import and Export.
  2. The "Import Wizard" will open, which you will need to generate the document. Check "Export to file".
  3. In the window that opens, select "Comma Separated Values ​​(Windows)". Continue by clicking on the "Next" button.
  4. Designate the folder that will be the save location. Click on "Next".
  5. Wait for the end of the transfer process.

How to transfer contacts from Outlook to Excel

Regardless of which version of Outlook, after you transfer the CSV file to your computer, you can open it in Excel.

Don't be alarmed if you see blank cells in your document. These are the positions that were not filled when the contact was still in Outlook. Not every person prescribes all the information: about home phone, the name of the organization, or the job title of the contact.

After viewing the transferred file in Excel, do not save changes when you close. This can destroy the structure of the document and make it impossible to read.

How to import contacts in all versions of Outlook

  1. The process for adding a CSV file to mail will be the same for all versions of Outlook. This is done in the same way as export: "File" - "Open and Export" - "Import and Export". In the "Wizard" select "Import from another program or file."

  3. After choosing an action, click Next. Wait for the end of the transfer process.

Import Internet addresses and mail into Outlook of all versions

  1. To import contacts from Outlook, go to the "Import and Export Wizard" again. Select "Import from another program or file."
  2. In the window that opens, click "Import Internet Addresses and Mail".
  3. Choose from the two suggested import options "Outlook Express 4.x, 5.x, 6.x or windows mail».
  4. Click Next and wait while the contacts are imported.

Import from another program or file into any version of Outlook

  1. After selecting "Import from another program or file," you can add contacts from the Lotus Organizer utility, as well as information from Access, Excel, or a plain text file. Select the program from where you plan to add contacts.
  2. A window with a choice of parameters will appear. If you want to create duplicates, click on the item "Allow creating duplicates".
  3. Select the folder where you want to get the information.
  4. Designate where the data will be stored.

Video: instructions for transferring contacts

Where is the address book located in Outlook

All information about the address book, messages, calendars and notes is stored on the computer in an archived form. If you need to find, copy or move it, it will be useful to know in which folders the required PST file is located:

  • drive: / Users /<имя пользователя>
  • drive: / Users /<имя пользователя>/ Roaming / Local / Microsoft / Outlook;
  • drive: / Users /<имя пользователя>/ Documents / Outlook Files;
  • drive: / Users /<имя пользователя>/ My Documents / Outlook Files;
  • drive: / Documents and Settings /<имя пользователя>

In case of using IMAP, Microsoft Exchange or outlook.com, the place where your mail information is saved is in the server space. Data is recorded in PAB format. In this case, you can find them here:

  • drive: / Users /<имя пользователя>/ AppData / Local / Microsoft / Outlook;
  • drive: / Documents and Settings.

If you used a Microsoft Exchange Server account, the Offline Address Book is located at the following addresses:

  • drive: / Users /<имя пользователя>/ AppData / Local / Microsoft / Outlook;
  • drive: / Documents and Settings /<имя пользователя>/ Local Settings / Application Data / Microsoft / Outlook.

Create an address book in Outlook

After the address book has been created, you can add contacts to it.

How to add contacts to Outlook

Contacts store information about people. Only address can be entered Email or fill in more information, such as phone numbers, photograph of the person, mailing address, work address.

After creating a systematized contact folder, the program will find the one you need by the first few letters and automatically fill in the email address.

Add a contact from an email message

First you need to open the received message, right-click on the person's name and select "Add to Outlook Contacts". Fill in the required information according to the field names, then save.

Adding a contact from scratch

Video: instructions for adding contacts

How to create a mailing list in different versions of Outlook

For simultaneous sending to several subscribers at once, we recommend using the "Contact Group" tool.

Create a distribution list in Outlook 2013


Create a distribution list in Outlook 2010

In the main menu work program select Create Contact Group. Fill in important information and save.

Please select address book via "File" - "New" or use the command Ctrl + Shift + L

How many people a message can be sent at one time depends on the size of the name files. Roughly, the average number is 100 contacts.

Delete contacts in Outlook

In order to prevent contacts from being duplicated, when importing them in the "Import Wizard", do not forget to change the standard transfer options "Allow duplicates" to another item where the option to replace existing ones is offered.

If the contacts have already doubled, then you can remove them in the "Contacts list" by clicking on the "Phones" item. In the field that opens in front of you, you must select the duplicated contacts, and then press DELETE.

If you uncheck the "Automatically check for duplicate contacts" section in Contacts Options, Outlook will not track duplicate business cards when you select a person.

Main function Microsoft programs Outlook is a work with e-mail. In addition, it can act as a notebook and contact manager. Having familiarized himself with the ways of adding, deleting contacts and creating groups in the Outlook mail client, the user can customize the program as it suits him, and with its help he will stay in touch with friends and colleagues.

You can use the same contacts in Google Gmail and Microsoft Outlook without manually adding them to both locations.

In this article

Import contacts from Google Gmail to Outlook

Export contacts from Outlook to Google Gmail

Before you export contacts from Outlook, the differences between the Outlook address book and Outlook contacts are helpful. Both are part of Outlook. However, an address book is a compilation of lists of different addresses that Outlook can store, such as Internet LDAP directories, global address list (GAL), or other third-party address books. Contacts is just one of the address lists included in the address book. You can only export contacts directly from Outlook to Google Gmail.

    Open the tab File.

    Select item Parameters.

    Select item Additionally.

    In chapter Export press the button Export.

    In the window Import and Export Wizard choose Export to file and press the button Further.

    Please select Comma Separated Value (DOS) and press the button Further.

    In the folder list, select the contacts folder you want to export and click Further.

    Select a folder to temporarily save the file on your computer.

    Note: This file can be deleted after importing contacts to Google Gmail.

    Enter a name for the exported file and click Further.

    To add or remove fields to determine how contact information is saved in the new imported file, click Matching fields.

    Note: When trying to import data from another program or file, the Matching fields in the dialog box Export to file may not be available. In the dialog box the following actions will be performed check the box Export and then the button Matching fields available.

    More Help Custom Field Mapping

    1. In field from drag the box you want to convert the shape to the Outlook box specified in the box To whom.

      • To view additional entries in the " from", press the button Back to or Further.

        To remove all mappings, click Clear.

        To restore the original mappings, click Default.

      2. To display additional fields in field, click the plus sign (+) next to the box. For example to display fields Street and Business city, click the plus sign (+) next to Work address.

    Click the button Done.

    Log in with your account Google entry Gmail.

    In the left column, select Contacts.

    On the right side of the screen, click Import.

    In the dialog box Importing contacts press the button Overview.

    Select the file exported in step 10 and click Open.

    Click the button Import.

As you know, contacts can be transferred from one mailbox to another, as well as between Windows accounts. They can also be imported and exported from an email client. This will allow you to later transfer them to another computer or even to another application (such as Excel or Notepad). Today we will talk about how to transfer contacts from Outlook or import them into this program.

Import and export contacts from Outlook 2016, 2013

id = "a1">

In the two most relevant on this moment For mail client releases, the contact transfer procedure is very similar. First, about how importing contacts works in these two Outlook builds.

Import contacts to Outlook 2016, 2013

id = "a2">

Export contacts from Outlook 2016, 2013

id = "a3">

Now about how the procedure for exporting contacts works.

Import and export contacts from Outlook 2010, 2007, 2003

id = "a4">

Now let's see how the import of contacts works in the versions of the mail client 2010 and years.

Import contacts to Outlook 2010, 2007, 2003

id = "a5">

Export contacts from Outlook 2010, 2007, 2003

id = "a6">

That's it for the routine of transferring data to and from Outlook. All this works very conveniently thanks to tools such as data filtering and support for several formats of exported and imported objects.

Microsoft Outlook Express is a free basic email application. Mail messages and account information from Outlook Express can be imported into Microsoft Outlook.

In Outlook Express, there is one file for each mail folder. For example, the Outlook Express Inbox is represented by a single Inbox.dbx file. In contrast, in Outlook, each message is separate file... Knowing this, you can, if necessary, be able to find and copy the desired folder if Outlook Express and Outlook are installed on different computers.

To import mail messages, select the appropriate instructions depending on how Outlook Express and Outlook are installed (on the same computer or on different computers).

Outlook and Outlook Express are installed on the same computer

Outlook and Outlook Express are installed on different computers

To transfer messages using the Import and Export Wizard, you must first find and copy correct files from a computer where Outlook Express is installed to a computer where Outlook is installed.

Note: Copying Outlook Express data to a shared folder is not enough. You must copy the folder to the computer where Outlook is installed.

Copy Outlook Express Folder


Import Outlook Express Messages to Outlook

Import account name and settings from Outlook Express

    Choose one of the options below.

    • In Outlook 2010, the tab File select items Open > Import.

      In Outlook 2007, the menu File select item Import and export.

    Select option Importing parameters account Internet mail and press the button Further.

    Please select Outlook Express and press the button Further.

    Follow the rest of the instructions in the Import and Export Wizard.


Over the past couple of years, people have already begun to forget what Outlook Express is. But after the New Year, within the framework of the project to merge the companies, another 19 branches passed under our service (“what happiness has fallen”). In the process of integration, it became clear that people have whatever their heart desires, there are no policies, regulations or other instructions. One of these programs is Outlook Express (of course, there are also thunderbolts and other mail clients, but we haven't gotten to that yet). Accordingly, there was a problem when transferring mail to Outlook 2010.

The algorithm that we decided to use is not the fastest, but without problems:

We put Outlook 2010 on the same computer as Outlook Express.

In Outlook 2010, click the tab File, press the button Open, and then - Import.

Will open import and export wizard.

Select item Import from another program or file and press the button Further.

A list will appear Select the file type to import:... Which option should you choose?

If you are using Outlook Express or Windows Mail, select Outlook Express 4.x、 5.x、 6.xorwindows mail and press the button Further.

In the window that opens, you are asked to select a mail client from which the import will be performed. The application has already been selected earlier. Does this mean that you need to press the button Further?

Yes. The window may indicate otherwise software, however, you must first select Microsoft Outlook Express or Microsoft Mail Windows, and only then press the button Further.

From this point on, you will need to verify that the information imported from the account is correctly specified in the wizard. In this case, you need to confirm the name that is used as the sender's name. It is indicated in the field display name... If it is correct, you can press the button Further... If you need to change the name, do so and click Further.

Then check your email address.

Check your mail server details.

Check your login information.

Check your account connection method.

This completes the verification of the settings.

After pressing the button Done another dialog box opens.

This means that the import of account settings is complete. Then the import of e-mail messages and contacts is carried out. If you press the button Yes, import will start.

This completes the actual setup.

Good job everyone !!!