USPS Address Verification

Savatage · 2018-03-15

For years we hyperlinked to:
https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=0&companyName=AAAAA&address1=BBBBB&address2=CCCCC&city=DDDDD&state=EEEEE&zip=FFFFF

Where you could insert Name, Address1 & 2, Sity, State & Zip

Looks today that USPS has changed their website & now Quick Tools::Look Up a ZIP Code no longer accepts these fields to be filled in already.

Anyone have a work around or other address verification site???

Thanks

Savatage · 2018-03-15

Well it looks like I found my own answer...

http://www.melissadata.com/lookups/AddressVerify.asp?name=AAAAA&Company=&Address=BBBBB&city=CCCCC&state=DDDDD&zip=EEEEE

HYPERLINK('http://www.melissadata.com/lookups/AddressVerify.asp?name='+"Ship-to Name"+'&Company=&Address='+"Ship-to Address"+' '+
"Ship-to Address 2"+'&city='+"Ship-to City"+'&state='+"Ship-to State"+'&zip='+"Ship-to ZIP Code");

Savatage · 2018-03-16

Just to clean this up.. Apparently melissa data doesn't like when you use # in addresses..so

HYPERLINK('http://www.melissadata.com/lookups/personator.asp?NameIn='+DELCHR(Contact,'=','#')+'&CompanyIn='+DELCHR(Name,'=','#')+
'&AddressIn='+DELCHR(Address,'=','#')+' '+DELCHR("Address 2",'=','#')+'&CityIn='+City+'&StateIn='+State+'&ZipIn='+"ZIP Code");

Comments