How do I Export contacts from Outlook in bulk?

How do I Export contacts from Outlook in bulk?

Click People. Click Manage > Export contacts. Select “All contacts” or select a folder of specific contacts. Click Export.

Is there a way to Export Outlook contacts to Excel?


  1. Open Outlook Desktop.
  2. Click File > Open & Export.
  3. Click Import/Export. (See figure below.)
  4. Click Export to a file under Choose an action to perform.
  5. Click NEXT. You will be taken to the Export to a File wizard.
  6. Click NEXT.
  7. Choose the desired Contact Folder to export from.
  8. Click NEXT.

How do I automatically Export contacts in Outlook 2016?

You can always add any address by right-clicking on it and choosing Add to Outlook Contacts. You can use VBA to create Contacts from messages in the selected folder or automatically add recipients from outgoing messages to Contacts.

How do I transfer my Outlook contacts to another computer?

How to transfer Outlook Address Book from one system to another?

  1. Launch Outlook.
  2. Select File>Open & Export>Import/Export.
  3. Click on Export to a file.
  4. Click Next and select Comma separated values.
  5. Select Contacts.
  6. Remember to save the file in .csv extension.

How do I extract the global address list from Outlook?

In the Outlook application, go to File > Open & Export > Import/Export. In the Import and Export wizard, select Export to a file and click Next. In the Export to a file wizard, select Comma Separated Values and click Next. Next, under the Contacts section, select the GAL folder and click Next.

How do I Export a distribution list from Outlook?

Step 1: Save Distribution List as Text file

  1. Open Outlook,
  2. Click the Distribution List you want to export.
  3. Click “File, Save As…”
  4. On the “Save As” window, select “Text Only (*. txt)” in the “Save As Type” drop down on the bottom.
  5. Name the file, for example list01. txt, and then save it on the local machine.

Where are Outlook contacts stored?

PST file
Since the release of Microsoft Office 2007, all Outlook contacts are stored in a PST file. Copying your Outlook account’s PST file to another computer or drive is important so you have backup copy all of your important business contacts.

How do I automatically save email addresses in Outlook?

In Outlook, click File > Options. Select the Mail tab. Scroll roughly halfway down until you see Send messages. Ensure the Use AutoComplete List to suggest names when typing in the To, Cc, and Bcc lines box is checked.

How can I Export my Outlook Contacts to Gmail?

Export your contacts from Outlook to Google Gmail

  1. Click the File tab.
  2. Click Options.
  3. Click Advanced.
  4. Under Export, click Export.
  5. In the Import and Export Wizard, click Export to a file, and then click Next.
  6. Click Comma Separated Value (DOS), and then click Next.

How can I export my contact list from Outlook?

To export the contact list of an account in Outlook, you can refer to the steps below: 1. In Outlook on a PC, choose File. 2. Choose Open & Export > Import/Export. 3. Choose Export to a file.

How do you export contacts from people?

1. Go to the People webpage, and sign in with your account if not already. 2. Click/tap on Manage on the toolbar, and click/tap on Export contacts. 3. Choose to export All contacts or only contacts from a specific folder in the Contacts from this folder drop menu for what you want, and click/tap on Export.

How do you import contacts to Microsoft Outlook?

Open the Applications Launcher and select People. Select Manage > Import contacts. Select Browse. Select the CSV file, then select Open. In the Import contacts dialog box, select Import. Your contacts are uploaded and imported to your email account. When the process is finished, select Close.

How to export email addresses from Outlook?

Method 2 of 3: On Windows Desktop Open Outlook. Double-click the Outlook icon, which resembles a blue and white envelope with a white “O” on it. It’s in the upper-left corner of the Outlook window. Doing so prompts a pop-out menu. Click Open & Export. Click Import/Export. Select Export to a file. It’s at the bottom of the window. Click Comma Separated Values, then click Next.

Share this post