Tutorial:Using SmartMover for Excel

From Melissa Data Wiki
Jump to navigation Jump to search

Getting Started

SmartMover for Excel is a powerful tool that is quick and easy to use. This tutorial will guide you through a simple usage scenario, checking a list of addresses against the NCOALink database. The sample screen shots for this tutorial are on Windows 7 with Microsoft Excel 2007.

Opening Excel

  1. Open Microsoft Excel.
  2. Open a database in Microsoft Excel.
  3. Click on the Add-Ins ribbon.
  4. Select SmartMover from the Add-In drop-down menu.

TUT SmartMover Excel 01-02.jpg

Starting with SmartMover

After selecting SmartMover from the Add-In drop-down menu, the Welcome to SmartMover screen will display.

  1. Click Next.

TUT SmartMover Excel 01-03.jpg

Entering your information

Purchase Info Window

Next is the Purchase Info window.

  1. Enter your License Key that was provided to you by your Customer Representative.
  2. Enter the Number of Records you will process.
  3. Click Next.

TUT SmartMover Excel 01-04.jpg

Contact Information Window

Next is the Contact Information Window.

  1. Enter your contact information.
  2. Click Next.

TUT SmartMover Excel 01-05.jpg

Choosing Your Settings

Service Format Window

Next is the Service Format window.

  1. This is where you will choose which fields are to be used in the operation.
    • If your database has the first row as a heading, you can check "Use 1st row as column heading" and then click Auto Format to have SmartMover detect which fields to use.
    • It is important to note that you must use the First Name and Last Name fields, OR the Full Name field. Never use all three fields at the same time.
  2. Click Next.

TUT SmartMover Excel 01-06.jpg

Add Fields to Database Window

Next is the Add Fields to Database window.

  1. Select which fields you want to be appended to your database.
    • All are selected by default.
  2. Click Next.


The following fields are available to be added to your database: Plus4, Mail Score, Return Code, Move Type, Move Date, Address Error, Delivery Point, CRRT, LACS, PMB, and Urbanization.

TUT SmartMover Excel 01-07.jpg

Update Options Window

Next is the Update Options window.

  1. Select which style of Casing you want.
  2. Select whether or not you want Address Standardization to be applied to your database.
  3. Click Next to start the operation.

TUT SmartMover Excel 01-08.jpg

NCOALink Basic Processing

Once you click Next, the NCOALink Basic Processing will begin. The processing speed will vary depending on your internet connection, number of records to be processed, and the quality of those records. While you wait, the window will constantly update with the status of your database. Once the operation displays 100%, the new data will be appended to your database. Be patient while this data is being written.

Return Codes

This displays the number of return codes. These codes indicate the level of matching between the current records and the NCOALink database.


See LACS above.

Mail Score

See Mail Score above.

TUT SmartMover Excel 01-09.jpg

NCOALink Results

Upon completion of the NCOALink Basic Processing, the NCOALink Results window will appear. This window displays information about your database: How many records were actually processed, how many were updated, and total processing time. A CASS Summary Report and a NCOALink Processing Summary Report will be generated in HTML format and saved to the same directory as your database. This is done automatically.

  1. Click Exit.

TUT SmartMover Excel 01-10.jpg


Upon clicking Exit you will have Excel open with your updated database. This has not yet been saved.

  1. Save your updated database.
If you wish to keep the old database as well, make sure you Save As... to specify a new file name and not overwrite your old database.