Import 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. For more on exporting contact lists, see Export Contact Lists in Express Email Marketing.
Certain keywords are blocked when importing emails into EEM. The intent is to keep EEM from importing emails that are most likely group/distribution emails addressed to more than one recipient (that is, spam). If you want to include addresses containing these keywords, you'll need do it manually through the sign-up form.
Email address keywords blocked from import | |||
---|---|---|---|
admin | abuse | all | billing |
compliance | devnull | dns | everyone |
feedback | ftp | help | hostmaster |
info | inoc | inquiries | investorrelations |
ispfeedback | ispsupport | jobs | list |
list-request | maildaemon | marketing | news |
nobody | noc | null | phish |
phishing | postmaster | press | privacy |
registrar | root | sales | security |
service | spam | subscribe | support |
sysadmin | tech | trouble | undisclosed-recipients |
unsubscribe | usenet | uucp | webmaster |
www |
NOTE: It might seem like addresses containing these keywords can be added successfully since there won't be an error message. But if you check and don't see those addresses imported, then they were blocked.
Import 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 Manage.
- 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.
Import 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 Manage.
- 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.