Barcode

A

Atreyu Lohan

I doing a mass mailing address on #10 evelops. I am
linking this to a excel spreadsheet with 3000+ records.

How can i setup so the coresponding zip barcode shows when
the mail merge is completed to printer?
 
G

Graham Mayor

Most of the regular correspondents in this group are not from the US and we
don't have personal experience with barcodes, but fellow MVP Peter Jamieson
has been researching this and recently posted the following which should
point you in the right direction:

"You will probably need to enter the field codes manually into the label, so
use Alt-F9 to toggle between field code and field result views and ctrl-F9
to enter the special field braces "{}". Everything else is plain text.

Ensure that your locale is set to U.S. English in Regional options,
otherwise the barcode field will not work whatever you do. (If you are in
the U.S. this would typically be the default setting).

US POSTNET barcodes are constructed from two pieces of information which you
will need in your data source:
a. a number in a street address
b. a 9-digit ZIP code

The BARCODE field requires that the 9-digit ZIP is in 5-4 format (with the
hyphen).

In your label you typically need a BARCODE field that looks like:

{ BARCODE "{ MERGEFIELD "street address" }¶
{ MERGEFIELD Postcodefield }" \u }

(The ¶ is just a normal paragraph mark that you will see if you press Enter
after { MERGEFIELD "street address" }
and click the ¶ symbol in Word's toolbar).

However, the last 2 digits of the BARCODE may not be generated from a Street
address in all
cases, so you may need to do something more than just { MERGEFIELD "street
address" }. You may find the following articles useful:

WD2000: How to Read Postal Bar Codes
http://support.microsoft.com/default.aspx?scid=kb;en-us;214181

and the article referenced in there:

WD2000: USPS Changes Postal Bar Code Requirements for Multi-Unit Buildings
http://support.microsoft.com/default.aspx?scid=kb;EN-US;220548

NB, The barcode field inserted by the Envelopes/Labels option uses a
slightly different approach which is to bookmark the whole address and use

{ BARCODE bookmarkname \b \u }

I would have also have a look at:

WD97: Word Assigns a Delivery Point Bar Code (DPBC) of 99:
http://support.microsoft.com/default.aspx?scid=kb;en-us;197008


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Y

:: Yourg Admin ::

i followed the instruction just as described bellow and as on the
Microsoft publication to no avail.

All i get is a "Zip Code Not Valid!".

i have double and triple checked the zip codes and name fields and
nothing... still same problem...

Any thing else that i could be missing? Any settings?

Lohan.
 
L

Lohan Roberto

i followed the instruction just as described bellow and as on the
Microsoft publication to no avail.

All i get is a "Zip Code Not Valid!".

i have double and triple checked the zip codes and name fields and
nothing... still same problem...

Any thing else that i could be missing? Any settings?

Lohan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top