TntConnect
Helping you build powerful connections for a lifetime of ministry...

Cleanup MailingState values


It is our pleasure to provide this software free of charge to help you in your ministry.  We're so thankful for our partners who make this possible!

About TntWare


posted by guitarmanvt
17 Sep 2009

Downloads: 46
File size: 296kB
Views: 27,738
Cleanup MailingState values

Sometimes, the MailingState field contains values like "Florida" or "Georgia", rather than "FL" and "GA" (which the USPS prefers).  Use this simple utility to clean up your MailingState field with one button click.  You have full control over what values get changed, so you are not limited to the 2-character United States codes.

Comments

Ken Mullins wrote re: Cleanup MailingState values
on 18 Sep 2009 3:14 AM

Are there directions?

guitarmanvt wrote re: Cleanup MailingState values
on 18 Sep 2009 8:51 PM

Very simple instructions are included when you start the add-on in Microsoft Access.

To get there, do this:

1. Download the add-on.

2. Link to it in TNTMPD. (Tools > Microsoft Access > Link Access database...)

3. Find the database file and open it in MS Access.

Hang on a sec, while I post an updated version of the add-on.

guitarmanvt wrote re: Cleanup MailingState values
on 18 Sep 2009 9:04 PM

The updated version properly handles ALL State-related fields.  Please use that "Cleanup States" add-on:

www.tntware.com/.../6395.aspx

© 2018 TntWare | Privacy | Terms of Use