From the Admin Menu, select Contact List Import & Maintenance. Only users who have been given security access to this feature can import mailing lists.

Mailing List Import Overview

Advisors Assistant allows you to import a list, such as a mailing list or another database of names, directly into the Advisors Assistant Database. You can import basic name and address information into Advisors Assistant, plus you have access to the Name FlexFields. Other information such as notes and products can not be imported through this process - if you have a list of this type you should call our Sales Department at (800) 799-4267 to discuss a Data Conversion.

Lists of the following type can be imported:

Comma Delimited or CSV files

Tab Delimited

A list of all of the fields you can import into Advisors Assistant from a Comma or Tab Delimited file is at the bottom of this topic.

Once you have imported a list of names, you can also remove the entire list in the future. So if you rent a mailing list for one or two mailings, you can remove that list after your rental period expires. You can keep the names you contacted in your database by changing their Name Type from the Type you assigned during the List Import process.


How to Import a Mailing List

1.From the Admin Menu, click Contact List Import & Maintenance.

2.The Mailing List Screen will open. If you have imported a mailing list in the past, the name of the list will appear on the screen. Click the Import List Button to import a new list.

3.The Import Mailing List Wizard will start. Just follow through each step to import your list. Help is available for each step of the Mailing List Wizard.

How to Remove a Mailing List

1.From the Admin Menu, click Maintain Mailing Lists.

2.The Mailing List Screen will open. The description of lists you have imported in the past will show. Highlight the list you wish to remove and click the Remove List Button to remove all of the names you had imported with that list. Advisors Assistant will remove the names based on the Name Type, Producer, and List Description you had entered during the Import Process. To keep some names in your database, make sure you change the Name Type for the names you wish to remain in your database.

3.The confirmation of deletion screen will open, and you'll need to type "yes" into the box to remove the names.

What Makes A Name Eligible To Be Removed

When you remove a list, not every name that got imported will be removed.  Advisors Assistant makes that decision based on the following:

1.If the producer's name has changed since it was imported, the contact name will not be removed.

2.If the Name Type has been changed, the contact name will not be removed.

3.If an additional Name Type has been added, the contact name will not be removed.

4.If the contact name has a policy or account associated with it, the name will not be removed.



Many other programs have the ability to export data into a standard comma or tab delimited file. Once you get your data into that format it can be imported into Advisors Assistant.


Advisors Assistant also has the ability to import from Outlook. If you have notes in the other program and can get your data into Outlook, you can import the contacts and their notes using the Advisors Assistant Outlook Import.


Below is a list of the fields you can import into Advisors Assistant:

Name Details (Individuals)

First Name

Middle Name / Initial

Last Name


Full Name



Marital Status


Name Status


Tax ID

Medicare Number

Drivers License

Driver's Jurisdiction

Drivers License Issue Date

Drivers License Expiration Date,

Non Citizen ID Number

Residency Status

Non Citizen ID Issued Date

Non Citizen ID Expiration Date

Passport Number

Citizen Nation

Passport Issued Date

Passport Expiration Date


Earned Income

Total Income

Net Worth

Addressee Prefix(Mr Mrs Dr)

Addressee Suffix (MD, DDS, PhD)

Name Details (Organizations)

Organization Name

Name Status


Fiscal Year End


Tax ID





Name FlexFields

FlexFields 1 through 30

Address (You can import multiple addresses, for example a Home and Business address)



Business Name


Street 1

Street 2

Street 3



Zip (+4)



Carrier Route

Delivery Point

Phone (You can import multiple phone numbers, for example a Home and Business phone)

Area Code

Phone Number

Full Phone

Country Code



Email (You can import up to 3 separate Email Addresses)

Email Address



Business Name


Web Site

Website Address


The import function does try to detect duplicates and does not overwrite a contact record that is already in the database.  It uses fields that are in both the existing record and the incoming record, such as Last Name, First Initial, Date of Birth, Tax ID.

If everything matches BUT the Primary Producer is different, the name will be added to the database under the new producer.  This is because one producer may be restricted from seeing the other producer's data, so it should look like two different names.

See Also