Have a look at some of Twelve/Three’s Custom Software! Our team of highly skilled programmers has a business solution for you. If you use a CRM system or platform such as GoldMine, ACT, QuoteWerks add-ons, or others we can write custom plugins to make them integrate seamlessly. Check out the full list of our software […]
SPF Record Creation for Swiftpage
I recently went through a process of updating our email hosting provider to add SPF records. Sage E-Marketing (AKA Swiftpage) uses email spoofing to make it appear as though emails are coming from your domain. I found no other documentation on this specific scenario, so I’ll write up my efforts for anyone else interested. […]
Installing T3 Auto-Address for ACT!
[box style=”doc”]This user manual and installation guide can be downloaded here. [wpdm_file id=1][/box]
Introduction
T3 Auto-Address provides a quick and accurate address correction plugin that is integrated into ACT. Customer address information is verified against the United States Postal Service’s National and Delivery Point Validation databases. You have the option to accept the verified address information and write it the ACT database.
The following example demonstrates an address before and after:
After the address comes back validated, you will have the option to write the validated address back to the ACT database.
System Requirements
ACT 2010 or greater.
Installing T3 Auto-Address for ACT
- Browse to the folder where you downloaded the Installer.
- Double-click on the file T3Auto-AddressSetup.exe
- The following screen will appear:
- Click Next.
- The following screen will appear:
- The T3 Auto-Address installs the plugin into the ACT plugin directory.
Registering T3 Auto-Address
When you open ACT for the first time after the installation process is complete you will be asked to register the T3 Auto-Address software. This will register the software with Twelve/Three Marketing, Inc. Below is a screen of the registration screen.
After the registration process you will need to configure T3 Auto-Address.
Configuring T3 Auto-Address for ACT
You will receive an email from Twelve/Three Marketing, Inc. that will include your username and license keys. The username and license keys will need to be input into the T3 T3 Auto-Address configuration screen in ACT.
- From within ACT, go to the Tools | T3 T3 Auto-Address Configuration menu option.
- The following screen will display:
- Cut and Paste the License key, Toolkit License Key and Username into the fields on the form from the email that was sent by Twelve/Three Marketing, Inc.
If for some reason you have not received your License keys, please call us at 716-837-5727.
- Options:
- Standardize Streets:
i. This would take Avenue and change it to Ave. Or it would take Road and change it to Rd.
- Use Alias:
i. A name by which a street may be known locally which is different from the official name used by the U.S. Postal Service.
- Mixed Case:
i. Return the address information in Mixed case rather then in Upper case.
- Click on the T3 Auto-Address tab.
T3 Auto-Address can store all of the information that is shown above in the ACT database. You would need to create the ACT fields in your database, if you wanted to have them stored. T3 Auto-Address will still update the address information without you having to create the above fields.
If you decide to save some of the above information in your ACT database, check the fields above and make sure that nobody is in ACT. Then click on the “Create Fields in ACT” button.
At the end of this manual is a description of all of the fields listed above.
T3 Auto-Address Tab in ACT
Below is the T3 Auto-Address tab in ACT. The fields that are in turquoise will be the fields that are written back to ACT when you click on ‘Write corrected fields to ACT!’ If any of the fields in in the configuration where check they would be in turquoise also.
Using T3 Auto-Address
Click on the ‘Check Address’ button on the T3 Auto-Address tab and after a couple of seconds, the the corrected address will be displayed on the screen. All of the fields that were returned by the service will be displayed. But only the fields that are turquoise will be written back to the ACT database.
If you want to keep the changes click on the ‘Write corrected fields to ACT!’ and only the fields that are turquoise will be written back to the ACT database.
T3 Auto-Address Fields
T3 Auto-Address Field | Description |
Error Code | Retrieves the output error code. T3 Auto-Address assigns an error code if the input record could not be found in the USPS National Database. This is a 2-byte code that identifies what was wrong with the input address and why T3 Auto-Address could not match it. If T3 Auto-Address matches the input address successfully, then this field returns a “0” string. |
Error Text | Retrieves the message text associated with the error code that T3 Auto-Address assignes if the input address could not be matched. This is a descriptive sentence or paragraph that describes the reason T3 Auto-Address could not correct the input record. If T3 Auto-Address matches the input address successfully, then this field returns a blank string. |
DPV Code | Delivery Point Validation footnotes / codes. Comprised of two 2-character codes |
DPV Description | Reason for the DPV codes |
Carrier Route Code | Retrieves the output carrier route code. This is a 4-digit code assigned to each address on a mail carrier’s route. |
Locatable Address Conversion Service | A 1-character Locatable Address Conversion Service (LACS) code to identify records that have been converted to the LACS system. The LACS system is being used for many rural route addresses that are being modified to city style addresses so that emergency vehicles can more easily find these locations. |
Public Mailbox address | Public Mailbox address |
County | County in which the address resides |
County Number | Retrieves the output county number. This is the 3-digit USPS code for the county in which the address resides. |
Congressional District | Congressional District of the address |
Bar Code | Bar code for the address |
Record Type | Record Type |
Zip Plus Four | Retrieves the output ZIP+4 Code. The ZIP+4 Code is the 4-digit extension only. |
Line Of Travel | Line of Travel identifier consisting of a 4-digit number, plus a 1-character sequence code (either “A” for Ascending or “D” for Descending). The 4-digit number indicates the order in which delivery will be made within a given ZIP+4. The 1-character sequence code indicates whether delivery will be made in ascending or descending order. Once a LOT code is appended to your data files records, you can use it to presort your mailings so that they qualify for Enhanced Carrier Route rates |
Line Of Travel Direction | The order in which the mail carrier delivers mail within a given carrier route. When you include the Line of Travel information, your mail may be eligible for the USPS Standard Mail Non-Automation Basic Enhanced Carrier Route Presort Rate |
Secondary Unit Designator | The secondary unit designator (SUD) for the output street address. For example, if the output street address is “123 Main St Apt 12,” the SUD is “Apt.” |
House Number | The house number for the output street address. For example, if the output street address is “123 Main St,” the house number is “123.” |
Unit Number | The unit number for the output street address. For example, if the output street address is “123 Main St Apt 12,” the unit number is “12.” |
Pre Directional | The pre-directional for the output street address. For example, if the output street address is “123 E Main St,” the PreDirectional designator is “E.” |
Post Directional | The post-directional for the output street address. For example, if the output street address is “123 Main St N,” the PostDirectional is “N.” |
Street Name | The street name for the output street address. For example, if the output street address is “123 Main St,” the street name is “Main.” |
Street Suffix | The street suffix for the output street address. For example, if the output street address is “123 Main St,” the street suffix is “St.” |
ACT! Compatibility with Windows 8
If you are buying a new computer: We highly recommend you upgrade to Act! v17 or v18 for the best experience. Act! v18 is the newest version released in Dec 2015. It is compatible with Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista, and can be upgraded on Windows XP. Act! v17 works very […]
Integrate Outlook E-Mail with ACT! Opportunities with OppLinx
[box style=”approved”]New software by Twelve/Three allows easy linking of Outlook Emails to ACT! Opportunities[/box] Outlook Emails have always been easily linked to ACT! Contacts and Companies automatically. Previously, there was no way to link emails to ACT! Opportunities quickly and easily. Twelve/Three’s newest ACT! Add-On does just that- quick and simple linking of an […]
Sage ACT! 2013 Roadshow Announced
The Sage ACT! 2013 Roadshow presented by Twelve/Three is back! Out with the old, in with the new! Sage ACT! 2013 is en route for its Fall debut. Come get a first look at the Beta with this year’s ACT Roadshow! Following the success of previous years’ Roadshows, Twelve/Three will once again be hosting a free […]
Tiled Gallery
This is a test for Jetpack’s Tiled Gallery. You can install Jetpack or Slim Jetpack to test it out. This is some text after the Tiled Gallery just to make sure that everything spaces nicely.
Virtual User Group for Tuesday, June 12th – QuoteWerks
QuoteWerks is specialized software used in every industry for creating sales quotes and proposals. Rather than using Microsoft® Word® or Excel® to create your quotes and proposals, you can benefit from a tool that is specialized for the task of creating quotes and proposals.
QuoteWerks fits into your existing environment of software. It works with the software that you store your customer information in like ACT eliminating the need to re-type customer information. QuoteWerks also has its own built-in contact database.
Virtual User Group for Tuesday, June 5th – Dashboards
Learn how to design ACT! dashboards to consolidate the views you use most often in ACT!. Customize the ACT! window to quickly show the data that you find most efficient.