Author Topic: Importing users from aWeber - HOWTO  (Read 2289 times)

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Importing users from aWeber - HOWTO
« on: June 01, 2007, 11:40:37 am »
It seems aWeber decided to quote some fields but not others and it confuses ListMail. Here's what to do:

1. Load the .CSV file in Excel
2. Select the entire "A" column by clicking "A", at the top
3. Click "Data" in the toolbar and choose "Text to Columns"
4. Choose "Delimited" and click Next
5. Make sure under "Delimiters" only "Comma" is checked. Also make sure the "Text qualifier" is set to a double-quote. Click Next
6. If it asks anything, click Yes
7. Choose "File" in the toolbar, then "Save As" and choose *.CSV. The resulting CSV file should be able to be imported into ListMail.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting