Support 805.461.7300
Our Technology. Your Success.

Fix Private Mail Box (PMB) Addresses

This command is used to correct your Private Mail Box (PMB) addresses prior to validation. Whenever your address begins with PMB, running this command puts your puts your PMB at the back of the address, where it belongs.

Use this command to alleviate any errors that may occur during validation due to addresses beginning with PMB. The examples below will illustrate how the command reorganizes the address.

The Command At Work

Before Command After Command
Before running command After running command

The Command

Copy this command, then paste it into the large text area of the command window:

replace all address with chrtran(strtran(UPPER(address),"PMB","PMB "),[~!@#$%^&*()_-+={}|\'<>,.?/],space(26)), address with STRTRAN(address," "," "), address with IIF(LEFT(UPPER(address),3)="PMB",ALLT(SUBSTR(address,AT(" ",STRTRAN(address," "," "),2)))+" "+LEFT(address,AT(" ",STRTRAN(address," "," &),2)),address), address with STRTRAN(address,"PMB PMB","PMB"), address with iif(right(allt(address),3)="PMB",left(address,len(allt(address))-4),address) FOR "PMB" $ UPPER(address)

After clicking RUN, the PMB and box number will move to the back of the address, with the street number and street name beginning the address. This properly formats the address for validation.

« Back to Commands

AccuZIP’s Professional Services Team has been a great resource for helping me launch Informed Delivery campaigns for my clients. I am a small direct mail marketing agency specializing in helping my clients find and retain new customers with direct mail. Informed Delivery is the best thing the post office has come up with in my 30+ years in the business. However, just like everything else with the post office, they don't make it easy. AccuZIP has made doing these digital campaigns very simple. I have analyzed campaign results and found the price per click through to the client's website less than an Adword campaign. I am looking forward to working with AccuZIP and their entire Professional Services Team with more clients and campaigns.
S.R., Raleigh, NC