How To Copy Email Addresses From Excel Into Outlook For Mac

How To Copy Email Addresses From Excel To Outlook
How To Copy Email Addresses From Excel Into Outlook For Macs
How To Copy Email Addresses From Excel Into Outlook For Mac Shortcut
How Do I Copy Email Addresses From Excel To Outlook

While handy for backing up or transferring your Outlook for Mac data to another Outlook for Mac installation, this format isn’t compatible with third party apps such as Apple Contacts. Export Outlook Contacts to VCF. The solution is to use another method that will produce VCF files (or vCard), a contact file format that is supported by a. You can copy one or multiple emails as attachments of another email easily with the Forward as Attachment feature in Outlook.Please do as follows: 1.In the Mail view, open the mail folder containing emails you will copy as attachments, and then select them in the Mail list. Note: Holding the Ctrl key, you can select multiple nonadjacent emails with clicking them one by one; holding the Shift.

Even in times of Facebook and WhatsApp, e-mails still play an important role. Especially in the business world, electronic messages continue to be an indispensable means of communication, and distribution lists and newsletters are still among the simplest tools for contacting a large user group with the least possible effort. The central component of e-mail traffic is a client including an address book in which all relevant contact data can be stored.

In the ranks of these mail clients, Microsoft Outlook has been a key player for more than two decades – also thanks to great freedom in contact management. The integrated import/export wizard, for example, enables you to easily import existing lists of contacts into Outlook. How is an address import prepared, and which steps are necessary?

Hosted Exchange with IONOS

How do you copy email addresses from excel to outlook

The prefect solution for your business! Get the world’s leading email and calendar solution together with secure hosting from a single source!

Free domain

Importing contacts into Outlook: Step-by-step instructions for desktop clients and web app

Importing Outlook contacts: What are the requirements?

There are different reasons why it is useful to import contacts into Outlook: Typically, you’ll have external lists of contacts that you would like to import into your Outlook address book. However, it’s also possible that you’ll want to import contacts that you have previously exported from Outlook – for example, to create a backup or because you want to change the version. In the latter case, the contact list already exists in the required import format CSV (the values in this file are divided by separators). If you have your own contact list, e.g. in the form of an Excel spreadsheet, you must first save it in CSV format before you can import it into your Outlook address book.

In order to protect your privacy, the video will not load until you click on it.

Saving your spreadsheets as a CSV file

All common spreadsheets such as Microsoft Excel, OpenOffice, or LibreOffice Calc offer the option of saving workbooks as CSV files. For Excel users, for example, this works as follows:

In the first step, click the worksheet that contains the contact information that you want to import into the Outlook address book. Then navigate to the “File” tab and click “Save As.”
Decide where you want to save the file and open the menu in the “File Type” field by clicking the small, downward-pointing triangle icon.
Locate and select “CSV (delimited).” Finally click “Save.” Excel will inform you that some features of the workbook will be lost (due to the switch to CSV format), which you accept by clicking “OK.”

Importing contacts into Outlook: Step-by-step instructions for desktop clients and web app

If you have the contacts you want in CSV format, you can immediately start importing them into your Outlook address book. You do not need any additional software for this. The import/export wizard of Microsoft Outlook is integrated by default, and supports the import without external tools or plugins. Depending on the current version of Outlook and whether you are working with the desktop or the web client, the procedure differs slightly. We have summarized the import process in the different editions of Outlook below for you.

How to import contacts in Outlook 2016 and 2013

Users of newer Outlook versions can find the import/export wizard in the “File” menu. The first step is to open it via the tab of the same name:

In the left menu bar, navigate to “Open & Export,” where you start the wizard by clicking on “Import/Export.”

In the start menu of the import/export wizard you can select various actions. The action “Import from another program or file” required for the import is already marked by default, so that you only have to press the “Next” button.

Before you click “Next,” you have the option of selecting one of three import variants:

How To Copy Email Addresses From Excel To Outlook

Replace duplicates with items imported: If a contact already exists in Outlook, the listed information for this contact is discarded and replaced by the information from the import file.
Allow duplicates (default option): If a contact already exists in Outlook, the import/export wizard creates a duplicate of this contact. Later, you can combine the information in the address book or remove the desired version.
Do not import duplicate items: If a contact already exists in Outlook, the information to import it is discarded.

Irrespective of the selection made, you will be prompted to specify the destination folder in the following menu. Search for the entry “Contacts” and click on “Next.”

After a final click on “Finish”, Outlook starts the import process.

Importing contacts in Outlook on the web – how it works

You can also import new contacts into your Outlook address book in Outlook on the web. To do this, log on to the web application and then click the small people icon in the toolbar in the bottom left:

In the next step, go to the “Manage” button and select the “Import contacts” entry.

Subsequently, the import menu opens in which you should specify the source of the contacts. As an alternative to Outlook, Gmail, Yahoo Mail, and Windows Live Mail are available as starting points. So if you want to import contact lists from one of these three e-mail services, you have the chance to do so at this point. For the CSV file we use in this tutorial, we need the import option “Outlook 2010, 2013 or 2016”:

Now click “Browse” and specify the location where the CSV file with the new contact information is located. Then start the import process via the “Upload” button.

How to import contacts in Outlook 2010

Outlook 2010 also has a feature to import contacts. However, as the user interface of the Microsoft e-mail client has changed over the years, the path to the import/export wizard differs slightly from how it works in the newer versions of Outlook. The following step-by-step guide shows you how to import contacts in the 2010 edition:

Select the “File” tab and click on “Open” there. Finally, use the “Import” button to start the import/export wizard.
Look for the action “Import from other programs or files” in the list, click on it and confirm your selection with “Next.”
Specify “Comma Separated Values (Windows)” as the file type to import, and then the location where the CSV file is stored. As with imports in Outlook 2013 and 2016, you can also specify in this menu whether duplicate address entries are to be allowed or not allowed.
Select the “Contacts” folder to which you want to add the new address information and start the process by clicking on “Finish.”

In order to protect your privacy, the video will not load until you click on it.

Related articles

HomeEmail ApplicationImport Email Addresses From Excel To Outlook Distribution List: Guide

Excel files are one of the most convenient ways to store contact information. These files allow users to merge multiple files with emails, delete duplicate items, update fields simultaneously, combine various contacts using formulas and other options. After managing data in a desired manner, one can import email addresses from excel to Outlook distribution list. But, the main question is HOW?

Well, if you are stuck in the same situation and searching solutions for the same, then this article is just meant to you. Here, we will show you how to export contacts from Excel to Outlook address book, using two simple techniques.

Import Email Addresses from Excel to Outlook Distribution List – Manually

You can import your spreadsheet that contains business as well as personal contact information to Outlook distribution list manually. The complete procedure is divided into three major steps:

Step 1. Convert Excel Workbook into CSV

The simplest way to export Excel file to Outlook contacts is to save the Excel file as comma separated value (.csv). It is so because MS Outlook provides an option to import CSV files instead of Excel workbook with multiple sheets. Below is how to convert an Excel workbook to CSV to import email addresses from Excel to Outlook distribution list:

Open excel workbook that you want to import to Outlook distribution list
Click File and select Save As
Select a location to save the resultant file
Click on the drop-down arrow next to Save as and highlight CSV (Comma delimited) (*.csv). Click Save
After this, Excel will tell you that the selected file does not contain workbooks with multiple sheets. Well, this is a limitation of CSV and it will not affect the original workbook (.xlsx file)
Click OK
Now, Excel will warn you that some features in worksheet might be lost while saving it as CSV. Just ignore this as it a limitation of CSV file
Hit the Yes button to save current excel workbook as a CSV file and the original workbook (.xlsx file) will be closed
Close output CSV.

You have now converted your Excel workbook contacts as CSV file and you can directly import Excel CSV file to Outlook Contacts to import email addresses from excel to Outlook distribution list.

Step 2. Import Output CSV to MS Outlook

Launch Outlook and click on File tab
Select Open & Export and click on Import/Export
Highlight Import from another program or file and hit the Next button

Note. If Outlook is asking to enter a password but, you have not set a password then, just click on Cancel to continue further.

Select Comma Separated Values option and click Next
From Options, choose the required option from replace duplicates, create duplicate contacts or not import duplicates
Hit the Next button and browse a destination location to save contacts. Contacts will be selected by default however, if it is not selected then, scroll up or down to find it. Also, you can select a different folder or make a new one.
Hit the Next button
Check Import “MyContacts.csv” (name of your file) option

Note. It is strictly recommended that do not hit the Finish button as you have to “map” email address and other columns in CSV to contact fields in Outlook while you import email addresses from excel to Outlook distribution list manually. Mapping helps to import CSV contacts into Outlook in the desired way.

Step 3. Map CSV File Columns to Outlook Distribution List

In Outlook, click on Map Custom Fields button and it will prompt Custom Fields wizard
In From section, you will get a box that includes column names from CSV file you are going to import
Under To, you will get the standard fields of Outlook contacts. In case if a field matches a column of CSV, you will get your column in Mappedfrom
Fields Name, First Name, Last Name are standard Outlook contact fields. Hence, if the contact information in CSV has any of those contact name then, you can proceed
Now, you have to do some manual mapping to import email addresses from excel to Outlook distribution list. For instance, in the imported file, the person’s cell phone is in the column named “Cell Ph”. It will not have the same match in MS Outlook. However, you can get a suitable match in Outlook just by following below given instructions:
Scroll down and click on Other Address that has add sign (+) and click on it
Expand it and you will get a match, Mobile Phone
In the left pane, drag the Cell Ph and drop it on the Mobile Phone in the right pane. After this, you will find that the Cell Ph is appearing next to the Mobile Phone in Mapped from column
Drag one value at a time and drag rest of the values from left pane to respective Outlook fields in the right pane. For instance, you can drag the Address to either Business Street, Home Street. Well, it depends upon the type of address for contacts
After all, this hit the Finish button. All your contacts will be imported to Outlook
In order to check the imported email address and other contact information, open Outlook 2016 and click on People from the navigation bar.

Automatically Import Email Addresses From Excel To Outlook

SysTools Excel to Outlook Converter is a powerful and direct way to import email addresses from excel to Outlook distribution list in bulk. The software export contacts from Excel to Outlook in batch and directly configure/ save excel contacts to Outlook contacts folder. It allows to load and preview the data stored within an excel spreadsheet. With this, users can create a distribution list in Outlook for all excel contacts. It allows to exclude duplicate contacts while exporting excel contacts to Outlook and supports all versions of Windows OS. Importing email addresses from Excel to Outlook involves the following steps:

Download and run Excel to Outlook Converter

Hit a click on Browse button and select the Excel file from which you want to import contacts

The software will preview all the content of browsed XLS file

Click on Next to proceed further
Now, you have to match the Excel fields with Outlook attributes to import email addresses from excel to Outlook distribution list.