Difference between revisions of "Importing contacts into Constant Contact"

From High5Wiki
Jump to navigation Jump to search
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
These instructions will guide you on exporting your contacts out of SME and importing them into Constant Contact
+
Hi high5software.com Webmaster!
  
== 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
 
  
<br>You will need to split the contact column into a first name and last name columns.
+
Hi high5software.com Owner,
 
 
<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/.

Latest revision as of 13:35, 25 April 2024

Hi high5software.com Webmaster!


Hi high5software.com Owner,

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