On Mon February 20 2006 17:27, + [EMAIL PROTECTED] wrote: > I really love the product and have no complaint.., but is there a way you > could program it to print Postnet (62 bar) codes.These come in real handy > for anyone generating letter mail from the system. I am not a programmer so > I'm not able to do this but it is a suggestion to the rest of the eager > young minds. The post office has books that explain generation of these > codes in detail. This is not to say it would LOOK UP a Zip Code. The > writer would simply input the proper 9 digit bar code and the system would > change it to an 11 digit (62 bars) bar code. Please put this suggestion > out to your people. Thank you
Hi Betty, Please read all of the following before downloading anything : As you are not subscribed you may not have seen that: On Tue February 21 2006 07:17, Ross Johnson wrote: > > > > > > Hi Betty, > > > > > > I'm currently looking at adding barcodes to a database project using > > > OOo (forms, label printing etc). I understand that all I need are > > > appropriate barcode fonts, and these can easily be installed so that > > > OOo can use them. I'm about to test it, so I haven't confirmed anything > > > yet. > > > > > > There are lots of free barcode font sets on the web of various quality. > > > There are also commercial font sets. E.g.: Take a look at this tutorial > > > on installing barcode fonts for OpenOffice/StarOffice: > > > > > > http://www.idautomation.com/openoffice/ > > > > > > A quick Google search turns up the following "PostNet barcode font" > > > sites: > > > > > > Commercial fonts: > > > http://idautomation.com/fonts/postnet/ > > > many others sites as well > > > > > > Free fonts: > > > http://www.popularshareware.com/POSTNET-Barcode-Fonts-download-3102.htm > > >l > > > > I was duped with this last link by the shareware notion of 'free', which > > must be interpreted as 'free download' of a demo or crippled version of > > a commercial product for which you must pay to use. > > > > However, to make up for it, I've tracked down a real 'free' Postnet > > barcode font. The following web page lists many sources of bar code > > fonts: > > > > http://www.adams1.com/pub/russadam/fonts.html > > > > and in the Postnet group there is at least one set: > > > > "A Postnet TTF" - author unknown. > > > > which is unconditionally free. > > > > This is a TrueType font and I ahve successfully installed it for use in > > my copy of OOo on Linux. The chances are that you are on Windows, so you > > should be able to install it following the instructions for installing > > fonts that come with Windows. I assume that once you've done that and > > shutdown all OOo windows and restarted them, the font will appear in the > > font list. > > > > You will need to turn off the font preview mode that OOo turns on by > > default in order to see the font name listed - otherwise this font set > > will appear as a blank entry in the list. > > > > In OOo2: > > Go to: Tools > Options > OpenOffice.org > View > > Under 'Font Lists', uncheck 'Show preview of fonts'. > > > > In OOo1: > > Go to: Tools > Options > General > View > > Under 'Font Lists', uncheck 'Show preview of fonts'. > > > > Now, you can type some numbers, select them, then change the font and > > Voila! Postnet barcode (almost - but not yet). You can't put this on > > your envelope as it is. The barcode on the envelope needs some > > additional information embedded in it. > > > > The first piece of additional information is a check digit, which is > > calculated from the postal code as follows (anyone, please feel free to > > correct this - although I know there is other info you can add, this is > > the simplest valid form): > > > > Postal code: '12345' (say) > > > > Sum the digits: 1+2+3+4+5 = 15 > > > > Calculate the number that you need to add to this number to make the > > last digit of the sum a zero (0). > > That is, 15 + ? = ?0 > > The answer in this case is: 5 > > I.e. 15 + 5 = 20 > > > > Add this number to the postal code as the last digit. > > Postnet sequence is now: 123455 > > > > Finally, wrap the digit sequence in square brackets. Your final text for > > the Postnet barcode is now: [123455] > > > > When you format this text using the Postnet barcode font, you will have > > your Postnet barcode. E.g. Type [123455] into Writer, select the whole > > [123455] text and change the font to the Postnet barcode font that you > > just installed. > > > > Your only problem now is where to calculate this sequence, and how to > > put it on your envelope. Perhaps others can help out with that if you > > need it, but if you use a database or spreadsheet to store your address > > list, then that is one place you could do it. I.e. have a Postnet > > sequence column with the addressee's pre-computed Postnet code stored > > there, or compute it on-the-fly, perhaps as part of a database query. > > This way, no OOo macros are required. > > One last thing. You mentioned using 9 digit Postnet codes. This will be > the 5 digit zip plus 4 digit suffix. I don't know what the suffix is > (I'm in Australia), but the rule is the same. Add all 9 digits, find the > check digit (sum + check = ?0), append that digit to make 10 digits. > Wrap in square brackets. I.e. [1234567895] > > There is apparently another two digit code that can be added if you > want, and the same rule applies for the 11 digit version to make a 12 > digit code wrapped in []. > > All three forms are valid. Please reply to users@openoffice.org only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]