Importing Existing Customer Lists in Express Email Marketing
To expedite the creation of your Express Email Marketing® Contact base, update your Contact list by importing a previously compiled customer list. Express Email Marketing notifies you by email when it has finished updating your list.
Importing Text or .CSV Files
You can import an existing list of Contacts into Express Email Marketing using a .TXT or .CSV file.
To Import Text or .CSV Files
- Log in to your Account Manager.
- Click Express Email Marketing.
- Next to the account you want to use, click Launch.
- Click Contacts, and then click Import List.
- Watch the opt-in video, and read and indicate Agree for each of the following terms to import your Contact list:
- I am a known sender
- I accept the bounce limit
- I will not send
Spam
- Click Browse, locate and select the file you want to import, and then click Import File.
NOTE: Only .TXT and .CSV files can be imported and the data columns must be separated by tabs, commas, colons, or semicolons.
- Complete the following:
- Does your file contain column headings? — Select Yes to carry over existing headings from the original file.
- Do you want to overwrite existing Contact records? — Select Yes to replace existing Contact information with new data. This can remove any information your Contacts have added to their profile on their own. Select No to add only new Contacts.
- Contact Field — Map the correct Contact field to the corresponding column value using the drop-down menu.
- Interest Groups — Import the Contacts into existing interest groups. Or, create a new group to target email campaigns later.
- Click Finish.
Importing Excel Files
Although Express Email Marketing does not directly support the import of Excel® files, you can copy data from Excel and paste it into the Import Contacts box. If you have a large amount of data, it might be best to save the data as a CSV-formatted file, then use the CSV import process.
To Import Excel Files
- Log in to your Account Manager.
- Click Express Email Marketing.
- Next to the account you want to use, click Launch.
- Click Contacts, and then click Import List.
- Watch the opt-in video, and read and indicate Agree for each of the following terms to import your Contact list:
- I am a known sender
- I accept the bounce limit
- I will not send
Spam
- Copy and paste your Excel file into the Copy and Paste box. (Tip: Separate your date into columns based on data such as first name, last name, email address, etc.)
- Complete the following:
- Does your file contain column headings? — Select Yes to carry over existing headings from original file.
- Do you want to overwrite existing Contact records? — Select Yes to replace existing Contact information with new data. This can remove any information your Contacts have added to their profile on their own. Select No to add only new Contacts.
- Contact Field — Map the correct Contact field to the corresponding column value using the drop-down menu.
- Interest Groups — Import the Contacts into existing interest groups. Or, create a new group to target email campaigns later.
- Click Finish.
If you get an error while importing, make sure the file is formatted correctly. For more information, see What are the formatting guidelines for importing files in Express Email Marketing?
