Thanks Perry that did the trick. I took that and edited it so it sent everything out RLI 2 except the 800's and then edited it again to remove the 1 in the NPA's to make it NXX's and then sent all NXX's to RLI 1 and uploaded those. Took less than 10 minutes to do all NPA's and NXX's. Once again thank you SOOOOOO much for the starter file.
i have a script at work that does npa's. and i have posted it here, but search didn't help. if you can do a merge from word, that script is simple after you record adding one npa. if i was at work i would post it for you. might give it a try, go to scripts record (alt]) add one npa, then make a list of npa's in excel. i just data fill 200 to 899, and merge the two.. remove the proc main and endproc before you start, add them back after you merge.. very simple after you've done it a few times
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.