Support 805.461.7300
Sales
Our Technology. Your Success.

Generate a random number of any length

Download and unzip the file linked below directly to your C:\Program Files (x86)\AccuZIP6 5.0 folder.
https://www.accuzip.com/files/forum/genrandom.zip

Import your list, and create a field that you want the number to be stored in using Edit menu>Fields. The field LENGTH determines the highest random number that will be generated. If the field length is 4, then the highest number could be 9999. Character fields are padded with 0, e.g., 0001

Click on Edit>Command, and run this syntax, substituting the word fieldname with the actual field name you created:

=GenRandom("fieldname")


Click Run.

You can then close the command window, and you'll see a random number filling that field, and they will all be 100% unique.
 

« Back to Commands

You are a genius and I have no excuse for not thinking of this before calling. Our customer is good with cutting the tops and bottoms for the booklets to get under 16 ounces. Thank you for getting me out of a jam and thank you even more for offering your help with this project! I decided to switch to AccuZIP after speaking with Steve at the Minuteman Show. I was impressed with his idea of customer service and you have totally proven him right.
M.M., Petaluma, CA