but we would like to publish their names with their email addresses. The email address format we want is We will start by selecting the cell in the column next to the cell containing the name:Ģ. In this scenario, we have a list of the people that exist at Fake Corp.

Instead of manually typing out all of the email addresses yourself, make Excel do the work for you. CSV file, then click Upload.Have you ever had a list of items in Excel that you wanted in a different format, but you didn’t want to spend the next few days or hours manually typing them into different columns or copying and pasting until your fingers bled? For example, let’s say you have a list of people’s names that you would like to turn into email addresses.

In, go to People, click Start import (listed under Import Contacts), then either choose the appropriate service you’re importing from, or select Other and locate the CSV file you’d earlier created.Ĭlick Choose file, locate your. If you’re exporting a contacts list that you intend to import into the Outlook email program on your computer, click Export for Outlook 20. If you’re exporting a contacts list that you intend to import into another webmail account (for instance, if you’re moving to Gmail)or for Windows Live Mail, click Export for and other services. In, go to People, then click Manage (at the top of the page). The process is similar across most webmail accounts, such as Gmail or. To import contacts, follow the same steps, but Import the file.

Select Comma Separated Values (.CSV) and save the file. To export contacts manually from Windows Live Mail, for example, open the program, click Contacts, then Export. You then import this same file into a new email account to populate its Contacts list. Your email account can do this for you quickly and easily. To copy your contacts from an email account, you need to create a simple file (a little bit like an Excel file) called a Comma Separated Value (CSV) file.

Create outlook email list from excel