Have a question?
Sales & Support
Navigation
- How to save my excel file into .CSV?
- How to find unsubscribed contacts
- How do I view a list of all Unsubscribed email accounts?
- Is there a way to send a single newsletter to seperate contact lists without generating duplicates if individuals are members of both lists?
- How can I easily change my contacts from Text to HTML?
- Can Mail Marketer automatically add an Unsubscribe link if one isn't included?
- How can I create my own unsubscribe link with my own words?
- How do I re activate a contact that has already been unsubscribed?
- What are custom fields and why/how would I use them?
- How to create a contact list?
- How to import contacts from a file?
- Adding contacts to list one by one?
- I am trying to import a contact list into Mail Marketer and am receiving errors when I know the data is correct. What could be causing this?
- If I send the one email to multiple contact lists and some one unsubscribes, what contact list are they removed from?
- I am trying to import a contact list into Mail Marketer but keep getting errors stating that the file could not be loaded.
- Is it possible to resend an email to a contact list but only to the contacts that have joined after I sent it first?
- How do I view a list of all Unsubscribed email accounts?
- Sending Emails Based on Subscriber Segmenting
- How are unsubscribes handled in Mail Marketer? Are they deleted or marked as Inactive?
- Can Mail Marketer send one email to multiple lists?
- Can I make multiple copies of my contact lists?
- How to export active/bounced/unsubscribed contacts to a file
- How to export opened / unopened contacts to a file
- What is a suppression list?
- Delete bounced / unsubscribed contacts from a list
How to import contacts from a file?
If you already have a list of contacts in a file on your computer, you can upload that file into the system and add the contacts to your new contact list. To start, you will need to export your contact list from your other mailing program. You should export your contact list into a CSV (comma separated value) file. A CSV file will contain a list of your contacts details in a line-by-line format, such as:
user1@site.com,MALE,Y,20030101
user2@site.com,FEMALE,N,20031014
user3@site.com,MALE,N,20020706
Move your mouse over the "Lists" tab and click the "Import Contacts" option in the left, as shown below:
This will start the "Import Contacts" wizard. Choose the contact list you want to import contacts to and click the "Next >>" button.
The example import file above includes three records, and each record is separated with a new line. Each record contains four fields, and each field is separated with a comma. The CSV file will typically have a .CSV or .TXT file extension. Start by clicking on the "Browse..." button in the form to select your CSV file from your hard drive:
To import contacts from a file, click the "Browse..." button to choose the file.
If your import file contains a line of headers like this:
EMAIL,SEX,EMPLOYED,DATE
user1@site.com,MALE,Y,20030101
user2@site.com,FEMALE,N,20031014
user3@site.com,MALE,N,20020706
...
... make sure you tick the "Yes, this file contains headers" checkbox. Click the "Next >>" button to proceed to the next step.
You will now be asked to map the fields from the imported file to the fields in the system. Simply click the dropdown box next to each field that was found in the file and match it up to the field in the system. Here's an example for an import file that included "Sex" and "Age" custom fields:
Click the dropdown next to each imported field to map it to the appropriate field in the system.
Click the "Next >>" button when you are done. Finally, click the "Start Import" button. Your contacts will be imported one by one and the popup window that appears will show you how many contacts have been imported and how many remain. You will see a final report when all contacts have been imported:
The final screen will tell you how many contacts were imported. It will also tell you if your contact file contained bad data.