+ Reply to Thread
Results 1 to 4 of 4

I have a data set of addresses of usa and I need to verify it from usps site

  1. #1
    Registered User
    Join Date
    11-02-2019
    Location
    ranchi
    MS-Off Ver
    2013
    Posts
    2

    Question I have a data set of addresses of usa and I need to verify it from usps site

    I have a list of around 19,000 addresses of state of Maine of US, USPS tool allows to check address and find Zip+4 codes on their site. It will take weeks to do it manually. can anyone help me with this. I am a newbie. I have attached the format which I have in the excel file, i would appreciate if someone can help in finding way to validate the address and return the zip+4 code in the adjacent row.

    The webtool which allows to validate data is

    I have attached a small sample.

    Regards
    Attached Files Attached Files
    Last edited by aviatre; 11-02-2019 at 06:19 PM. Reason: addition of information

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: I have a data set of addresses of usa and I need to verify it from usps site

    Hi welcome to the forum.
    It's nice to know that you mention USPS tool that allows to check the addresses.
    No trace of this in your file.
    A little more information, link to the tool etc etc might help you get an answer.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    11-02-2019
    Location
    ranchi
    MS-Off Ver
    2013
    Posts
    2

    Re: I have a data set of addresses of usa and I need to verify it from usps site

    Thank you for your reply, I am new here so can't post links thus have provided the link in the excel file itself.

    Regards
    Attached Files Attached Files
    Last edited by aviatre; 11-02-2019 at 03:55 AM. Reason: more information

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: I have a data set of addresses of usa and I need to verify it from usps site

    I don't advise usernames and passwords or isn't it a private account?
    And... it doesn't recognize the combination. sorry

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pull USPS address to excel
    By Sakthivel85 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-06-2020, 06:32 PM
  2. Excel to update addresses in reference to site ID
    By n3wb in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-24-2018, 12:22 PM
  3. [SOLVED] Pull USPS address to excel with Internet Explorer - input on page's state drop-down
    By cows in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2015, 01:01 PM
  4. Data verify problem
    By G-fer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2008, 11:07 PM
  5. [SOLVED] How to verify addresses and zip codes are correct? In bulk...
    By motol in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2006, 02:00 AM
  6. Verify Data List
    By davidbrowne17 in forum Excel General
    Replies: 1
    Last Post: 03-11-2005, 11:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1