Imagine you are working with an organization and you received an Excel file that contains a list of new client contacts, now you have to group all of these contacts to a single Outlook Distribution List. So what will you do?
Because collecting and sharing of contacts is an essential part of the corporate world. But, there are lots of people face the problem while getting them into there email client. Then, they start searching queries like how to import Excel spreadsheet into Outlook Distribution List?
Well, then no need to worry about because in this article we are going to discuss How to create a Distribution List in Outlook 2016 from Excel in simple ways.
But, before starting let’s discuss some of the terms which are used in the article:
Excel – Microsoft Excel is a software which used to create a spreadsheet, which contains data in tabular form. Excel create various file format like CSV/ XLS/ XLSX/ XLSM/ ODS/ OTS and many more.
Outlook Distribution List – Just like the WhatsApp group distribution list is a group of Outlook, it is used to send emails to a group of people without entering the recipient of each email address. It also knows as Contact Groups.
Import Excel file into Outlook Contact Group/ Outlook Distribution List
There is no manual method available to convert Excel file to Outlook Distribution List. So professionals use an automated way to complete this task.
Convert Excel Spreadsheet to Outlook Distribution List – Best Solution
Excel to vCard Converter is the best-automated software to resolve queries like how to turn an Excel spreadsheet into an Outlook Distribution List.
Follow the steps below for importing an Excel file into Outlook Distribution List:
Step 1 – Click on the Browse button and select the Excel file then click on the Open button
Step 2 – After that, the software will show you all the content of the selected file
Step 3 – Now, click on the Next button to continue the conversion process
Step 4 – To match the Excel with Outlook attributes to choose the Outlook attributes
Step 5 – Now, match the fields in this way :
• First Name –>> First Name
• Last Name –> Last Name
• Email –>> Email Address
Step 6 – After, matching the field, click on the Add button. Then the software will show you all the matched attributes.
Step 7 – in this step there is two option available:
• Allow Empty Email address to be Imported – This option allows to convert contacts with empty email addresses fields.
• Single vCard File for All Contacts – This option creates a single vCard for all contacts and creates individual VCF for each contact.
So, choose the options you want to import Excel spreadsheet into Outlook Distribution List.
This software supports all versions of vCard i.e. v2.1, v3.0, v4.0.
Step 8 – Select the desired location on your system and click on the OK button.
Step 9 – Now, click on the Convert button to start the conversion.
Step 10 – Software will create a separate vCard file for each contact file and save them at your location.
Step 11 – After this, open MS Outlook and choose the File menu from the navigation panel
Step 12 – Click on Open & Export option to begin import Excel file into Outlook Contact Group process
Step 13 – Then select an option Import a vCard file and choose Next button
Step 14 – After that, you need to choose a vCard file that you want to import
Step 15 – Click on Next button to complete the task
This is How to Create Distribution list in Outlook
Step 1 – On the Home page of Outlook, click on Address Book option to open your Address Book
Step 2 – Now, select Contacts from the list of Address Book
Step 3 – Open the File menu and click on New entry
Step 4 – Under the Select the entry type option, click New Contact Group
Step 5 – Under Put this Entry option, click In The Contacts
Step 6 – Now, click on OK button to complete the process
Now, you know How to create a Distribution List in Outlook 2016 from Excel simply and smartly. So, you just need to follow the steps which are mentioned above to complete the task.