Export Mailing List from ECommerceTemplates ECT to Constant Contact
May 30th, 2014If you use eCommerceTemplates and want to export the mailing list into Constant Contact, you can follow these steps. Make sure you have explicit permission from folks before you send them bulk emails!
1. Export from ECT store (Mailing List, Action: Dump Entire Mailing List)
2. Convert CSV file to XLSX (because CC needs this)
(Option: Break fullname (first last) into two columns or whether to leave it as one value)
http://office.microsoft.com/en-us/excel-help/split-text-into-different-cells-HA102809804.aspx
3. Sign in to CC, Contact, Pick List, Add Contact, From File
4. Select which fields to import and map them to CC fields
5. Import and done.
--------------
J. Olkoski
Aldebaran Web Design, Seattle
Jill Olkoski has a BS in Engineering, a BS in Computer Science and an MA in Clinical Psychology. She delights in using her advanced technical and psychological skills to help small business owners develop cost-effective and successful websites.