Insight Software Solutions Home Page ZIP Express, The ZIP Code and Area Code Authority
Insight Software Solutions | Other Automation Tools | Products | BUY NOW
 

 

  Home

  Buy Now

  Download

  Support

  Features

  Links

Search
ZIP Code
Database

  Search by:

  ZIP Code

  City

  County

  Area Code




This tutorial will create a macro that will locate a ZIP Code in your application or field when pressing a hot key. The corresponding ZIP Code data will be copied to the Windows clipboard. The data may then be pasted to another application or a different location in the current application.


Assign Hot Key
  1. Click on Options | Keyboard Shortcuts to open the Hotkey Setup window.
  2. Highlight Ctrl+Shift+G by clicking on it from the list.
  3. Click on the Modify button to begin defining what the hot key will do.

Modify Hot Key
  1. Enter "Calling Program to Clipboard" in the Nickname Field. (This will help us remember what the hot key does.)
  2. In the ZIP Code Source section, select the From Calling Program option.
  3. In the ZIP Code Output section, select the Into Clipboard option.
  4. Click on the down arrow to the right of the Output Format edit box to see a list of available formats.
  5. Select the [CITY], [STATE] [ZIP] format. (It should now be displayed in the Output Format edit field.)
  6. Click the OK button to return to the Hotkey Setup window.
  7. Click OK again to save the Hotkey definitions and return to the main ZIP Express window.

Testing the Hot Key
  1. Open notepad. (To open notepad, click on the Start Button, then Run. In the Run window type in notepad and press OK.)
  2. Type your five digit ZIP Code into notepad.
  3. Press the hot key we assigned - Ctrl+Shift+G.
  4. Tab down to a blank position in the notepad window.
  5. Press Ctrl + V to paste the information that was copied to the clipboard.
  6. If we entered ZIP Code 15237, the results will display as "Pittsburgh, PA 15237", without the quotes.