ListMailPRO Email Marketing Software Forums
ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: DW on June 01, 2007, 11:40:13 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