Trying to generate Zip4 postal codes from an address list.

ChadWhaley

I am trying to generate Zip4 postal codes from an address list.  I have the address which is currently in this format  

   Address                 City                State               ZIP
111 Camp Rd       Pensacola          FLORIDA        325040000

I have tried using the ZIP+4 address locator when geocoding but I only get xy coordinates and no ZIP+4 are generated.
Is there a certain process to this or do I need business analyst.

I currently just have home single use license.

JoeBorgione

I am trying to generate Zip4 postal codes from an address list.  I have the address which is currently in this format  

   Address                 City                State               ZIP
111 Camp Rd       Pensacola          FLORIDA        325040000

I have tried using the ZIP+4 address locator when geocoding but I only get xy coordinates and no ZIP+4 are generated.
Is there a certain process to this or do I need business analyst.

I currently just have home single use license.

Looks like you have the zip+4 data in your zip field: you should be able to extract the last four digits/characters with vba:
You can add a couple of fields called ZIP1 and ZIP2, where ZIP1 is the first 5 characters and and ZIP2 is your zip+4.

In the field calculator calc ZIP1 = left([zip],5)

In the field calculator calc ZIP2 = right([zip],4)

Is that what you want to do?