
How to measure the effectiveness of your distribution list Once the import is complete, you’ll be able to select your distribution list when creating your next email campaign. Once the next window opens up, you’ll want to browse through your documents, locate your CSV file, and then follow the prompted Import Wizard steps. Once you’ve activated the program, click “File” and scroll down to the “Import” option. Once you’ve got your saved CSV document, you’ll want to begin by opening your Address Book application. Importing email addresses from Excel to Apple Mail This will allow you to align everything the way you want. Make sure you then choose the option “comma separated values,” before clicking “Next.” Once you’ve found the CSV file with your email addresses, you’ll go under “Options” and choose whether or not you want to replace any duplicate contacts or simply choose not to import duplicates.Ĭlick “Next” and choose “Contacts” and, from there, you’ll be asked a few other questions to map your CSV file columns to fit your Outlook contact fields.

You’ll then choose the option to “Import from another program or file,” and then click on “Next.”


Next, you’ll select “Open & Export,” which will then allow you to choose “Import/Export” files and settings. Importing email addresses from Excel to OutlookĪt the very top of your Outlook page, you’ll want to click and open the “File” dropdown menu. Source: Super Office How to import email addresses from excel to a distribution listĪfter you have created a saved CSV document in Excel and are ready to import these documents into your chosen ESP, you’ll take the following steps. These distribution lists are essential to your marketing team because they can be used to create email campaigns that are personalized to the readers. An email distribution list can be segmented into any number of categories, including: In email marketing, a distribution list is known more commonly as the email list, and the process of dividing these lists up is known as list segmentation. The good news is that there are simple ways to import your email addresses from Excel to a distribution list. However, once you’ve collected those email addresses and entered them into your Excel document, how do you get them into your email service provider’s distribution list? Collecting and sharing email addresses with your email marketing team is an essential part of the digital marketing process.
