Editing Importing contacts into Constant Contact
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 1: | Line 1: | ||
| − | + | These instructions will guide you on exporting your contacts out of SME and importing them into Constant Contact | |
| + | == Prepare your import file == | ||
| + | <br>In SME, go to customer module | ||
| + | <br>click '''Search''' > '''Search Active Customers''' | ||
| + | <br>Make sure you have a column for Name, Email and Contact in your search window (Views > Add Remove Fields) | ||
| + | <br>Click '''Export''' > '''Export to Excel'''. Click OK to the path message. | ||
| + | <br>The contents of your search window will open in Excel. | ||
| + | <br>Filter your excel file as needed to get to your target list | ||
| − | Hi high5software.com | + | <br>You will need to split the contact column into a first name and last name columns. |
| + | |||
| + | <br>Copy the contact column and paste it on the right, so it is the column furthest on the right | ||
| + | <br>click the column header for contacts to highlight the column | ||
| + | <br>Click '''Data''' > '''Text to Columns''' (image below) | ||
| + | <br>[[File:Data_TextToColumns.png]] | ||
| + | |||
| + | <br>In the convert Text to Columns Wizard - Step 1 of 3 window, make sure '''Delimited''' is selected ad click '''Next''' | ||
| + | <br>[[File:ConvertStep1of3.png]] | ||
| + | |||
| + | <br>In the Step 2 of 3 window, uncheck '''Tab''' and check '''Space''', so Space is the only one checked and click '''Next''' | ||
| + | <br>[[File:Convertstep2of3.png]] | ||
| + | |||
| + | <br> Click '''Finish''' in the Step 3 of 3 window. | ||
| + | <br>You will see your contact separated into two column like this: | ||
| + | <br>[[File:ContactsSplitIntoTwoColumns.png]] | ||
| + | |||
| + | <br>Rename the column headers “First Name” and “Last Name” | ||
| + | <br>[[File:ColumnHeadersRenamed.png]] | ||
| + | <br>Review the name columns to make sure everything is lined up correctly. Make corrections as necessary. | ||
| + | |||
| + | <br>Save the excel file | ||
| + | |||
| + | high5software.com | ||
| + | |||
| + | Hi high5software.com Administrator!, | ||
Ready to take your website to new heights? I'm Mark, your go-to SEO professional on Fiverr! Check out my service at https://fiverrseopro.com/. | Ready to take your website to new heights? I'm Mark, your go-to SEO professional on Fiverr! Check out my service at https://fiverrseopro.com/. | ||