Seattle Web Design
Blog > Export Mailing List from ECommerceTemplates ECT to Constant Contact

Meet the author:
Jill Olkoski

Jill has a MA in Clinical Psychology, a BS in Computer Science, and a BS in Mechanical Engineering.

She currently owns Aldebaran Web Design in Edmonds (near Seattle WA) and enjoys educating her clients on topics related to small business website design.

In Jill's previous life, she spent 17 years in the engineering and quality organizations of a Fortune 100 tech company.

 


Export Mailing List from ECommerceTemplates ECT to Constant Contact

May 30th, 2014

If 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.

Jill
--------------
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.



Comments are closed.



 ©2006 - © Aldebaran Web Design Seattle, A DBA of Aldebaran Services LLC
Search Blog Articles: