how to import contacts into outlook 2013 file in use error

Importing Contacts from Excel to Outlook 2013: A Step-by-Step Guide

Are you tired of manually adding contacts to your Outlook address book? Do you have a large list of contacts stored in an Excel spreadsheet that you want to easily import into Outlook? If so, you're in luck. Microsoft Outlook provides an option to import CSV files instead of Excel workbooks with multiple sheets, making the process much simpler.

The first step is to save your Excel file as a comma-separated value (.csv) file. This may seem like a small task, but it's crucial for importing your contacts into Outlook successfully. To do this, follow these simple steps:

Step 1: Export Your Excel File as CSV

---------------------------------

Once you have saved your Excel file as a .csv file, you can proceed to the next step. In this step, we will manually import your spreadsheet that contains both business and personal contact information into an Outlook distribution list.

Import Email Addresses from Excel to Outlook Distribution List – Manually

-------------------------------------------------------------

To import email addresses from Excel to Outlook distribution list manually, follow these steps:

1. Open Outlook and go to the 'Contacts' folder.

2. Click on the 'New Contact Group' button in the 'Home' tab.

3. Enter a name for your contact group and click 'OK'.

4. In the 'Members' box, click on the 'Add Members' button.

5. Select 'From Outlook Contacts' and then choose the contacts you want to add from the list.

6. Click 'OK' to add the selected contacts to the distribution list.

After managing your data in a desired manner, you can import email addresses from Excel to Outlook distribution list using this method.

-------

In conclusion, importing contacts from Excel to Outlook 2013 is a relatively simple process that can be completed manually or automatically depending on your needs. By following these steps, you can easily merge multiple files with emails, delete duplicate items, update fields simultaneously, combine various contacts using formulas and other options.

How to import contacts into outlook 2013 file in use error