how to import contacts into outlook from excel file

#How to import contacts into outlook from excel file how to
#How to import contacts into outlook from excel file pdf

Outlook Import Wizard will help you turn any file (Excel, Word, PDF etc.) on your PC into an Outlook attachment Selected option allows import files of any type to Outlook. All of this can be done to a certain degree using out-of-the-box Outlook functionality, but if you are looking for a truly elegant solution of this problem, you need Outlook Import Wizard. You may also want your frequently used documents to be stored within a PST file and possibly be password-protected along with your contacts and correspondence. For instance, if you have a lot of standard document templates or price lists that you send to multiple recipients on a regular basis, you may want them all to be physically located in one of your Outlook folders for ease of access and communications. However, there are many situations where an ability to quickly locate, open or forward a specific attachment would come in extremely handy. You could only tell if there was an attachment in a message by looking for a small paper clip icon next to its name, which made the search for a specific attachment quite time-consuming and confusing. With Outlook Import Wizard you can easily transfer files saved from Excel to Outlook or from Word to Outlook, even PDF to Outlook or any other file.įile attachments have always been part of corresponding email messages. The final result is a Contact Group directly created from an Excel list.Learn how Outlook Import Wizard can assist you in converting a set of files on your PC into Outlook attachments, thus becoming a convenient Outlook backup tool and allowing you to keep your frequently used files in a mail folder of your choice. Provide a name for your Contact Group and save it.Press OK to close the Select Members dialog and to return to your Contact Group.If done correctly, each address will be listed on its own line. Instead of selecting your members from your list of contacts, click in the text field next to the “Members” button and press CTRL+V to paste the copied content from Excel.Click on the Add Members dropdown button and choose: From Outlook Contacts….The keyboard shortcut for this is: CTRL+SHIFT+L

In Outlook, create a new Contact Group or Distribution List (the name depends on your version of Outlook).

Press CTRL+C to copy the selected cells.

In either case, make sure you do not select the row containing the headers. Optionally, you can also select the column containing the names.

In Excel, select the addresses from the column containing the email addresses.

Copy & Paste straight from Excelįor this method, it is already sufficient if you have a column in Excel with just email address but having an additional column with names can make the list prettier. However, there is a much quicker and direct method as well. One method is to import them as individual contacts first, create a distribution list out of them and then delete the individual contacts again.

How can I import them as a new Distribution List instead?

#How to import contacts into outlook from excel file how to

I know how to import these as individual contacts but I don’t need that. I have an Excel document with a list of e-mail address.