So, you’ve got an Excel document you want to import into your mailing list. Here is what needs to be done.

• 1. The first fields in the Excel Document must be in the correct format:
  • RowA-1: Email Address
  • RowA-2: Name
  • Row A-3: Is Active

I cannot stress the importance of making sure they are exactly “case sensitive” as listed above. Now you have 3 fields, you have the names and emails . The “Is active” is probably the only thing that might not be understood. The “Is Active” field is important because we try to meet everyones needs by offering list segmentation (if it is an important aspect of a company’s campaign). If you just have a strait up newsletter it does not apply to you, other than the fact that you do want the addresses active if you wish to mail to them. So for this sake Is active will be “TRUE”.

• 2. Now you have a file ready to import, select from the “File” main menu the “Save As…” option. At the bottom of the “Save As” window look for the Save as type option available and select “Text (Tab delimited) (*.txt)”. Remember where you saved this file.

• 3. Go to our site and login to yours. In the menu select Add-ons » Email Newsletter » Manage Lists » Edit A List » “the list you want to import to”

• 4. At the bottom of the page will be the file upload box. Click the “Browse” button, you do remember where you saved that file don’t you? Select your file and click “open”. Now click the “import” button. If you have been successful you will see “xxx Subscribers imported” in red. Thats all, to save yourself time take the layout of the document into consideration when having people sign up.

If you have list segmentation or would rather us handle this for you feel free to give us a call at 404-303-7404.