Difference between revisions of "Importing contacts into Constant Contact"

From High5Wiki
Jump to navigation Jump to search
Line 32: Line 32:
 
<br>Save the excel file
 
<br>Save the excel file
  
== Import into Constant Contact ==
+
high5software.com
Constant Contact changes the interface so these images might not reflect what is currently on their site, but you can navigate through their wizard like this:
 
  
<br>Log into Constant Contact
+
Hi high5software.com Administrator!,
<br>Click '''Contacts'''
 
<br>[[File:CCContacts.png]]
 
  
<br>Click '''Add Contacts''' > '''Add from file'''
+
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/.
<br>Click '''Choose File''' and browse for your Excel file.
 
<br>[[File:CCAddContactsFromFile.png]]
 
  
<br>Click '''Continue'''
+
�� Service Highlights:
 +
✅ Comprehensive SEO Action Plan
 +
✅ Proven Optimization Techniques
 +
✅ Guaranteed Ranking Boost
  
<br>In the next window, you will see a preview of your excel file and the column names. Use the “Fields in Contact Contact” column to map the excel columns to the correct field.
+
�� Why Choose Me?
 +
With a track record of success, I've helped clients like you achieve top-notch rankings and increased visibility.
  
<br>For example, make sure “Name” is mapped to Company, Email is mapped to the correct constant contact email field, and the names are mapped to First name and Last name
+
�� Limited Time Offer: Act Now!
<br>[[File:CCMapColumnsToFields.png]]
+
Take the first step toward SEO success. Click https://fiverrseopro.com/ and let's elevate your website's performance!
  
<br>Once you’ve mapped your excel columns to the Constant Contact fields, click '''Continue'''
+
To your online success,
 
+
Mark
<br>In the next window, click the plus sign next to '''Add to Email List''' and choose which email list you want the contacts to import into, or click '''Create New List'''.
 
<br>[[File:CCAddToEmailList.png]]
 
 
 
<br>Click '''Apply'''
 
<br>Click '''Import'''
 

Revision as of 14:03, 1 March 2024

These instructions will guide you on exporting your contacts out of SME and importing them into Constant Contact

Prepare your import file


In SME, go to customer module
click Search > Search Active Customers
Make sure you have a column for Name, Email and Contact in your search window (Views > Add Remove Fields)
Click Export > Export to Excel. Click OK to the path message.
The contents of your search window will open in Excel.
Filter your excel file as needed to get to your target list


You will need to split the contact column into a first name and last name columns.


Copy the contact column and paste it on the right, so it is the column furthest on the right
click the column header for contacts to highlight the column
Click Data > Text to Columns (image below)
Data TextToColumns.png


In the convert Text to Columns Wizard - Step 1 of 3 window, make sure Delimited is selected ad click Next
ConvertStep1of3.png


In the Step 2 of 3 window, uncheck Tab and check Space, so Space is the only one checked and click Next
Convertstep2of3.png


Click Finish in the Step 3 of 3 window.
You will see your contact separated into two column like this:
ContactsSplitIntoTwoColumns.png


Rename the column headers “First Name” and “Last Name”
ColumnHeadersRenamed.png
Review the name columns to make sure everything is lined up correctly. Make corrections as necessary.


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

�� Service Highlights: ✅ Comprehensive SEO Action Plan ✅ Proven Optimization Techniques ✅ Guaranteed Ranking Boost

�� Why Choose Me? With a track record of success, I've helped clients like you achieve top-notch rankings and increased visibility.

�� Limited Time Offer: Act Now! Take the first step toward SEO success. Click https://fiverrseopro.com/ and let's elevate your website's performance!

To your online success, Mark