[Ruth Ciser]

I have worked with a mailmerge combination of Excel and Word label documents
for many years and have been able to add postal bar codes to my labels with
this particular combination. Whenever I replace that specific Excel
spreadsheet with a different sheet (containing identical information) I get a
"Zip Code Invalid" message on the labels. My data list contains many zip
codes beginning with zero and the only way I can record and import them
properly is to formar them as text in Excel. (Could this be part of the
problem?) I'm trying to "retire" from this particular job, and don't know
how I can pass it on to someone when the bar codes (essential for our bulk
mailings) cannot be included. HELP!

[Graham Mayor]

We don't use bar codes in my part of the world, but it is my understanding
that the bar codes produced by Word are no longer compliant with the US
postal requirements anyway. However for your immediate problem you need a
switch on the field to bring in the correct ZIP detail from Excel - see
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Ruth Ciser wrote:
I have worked with a mailmerge combination of Excel and Word label
documents for many years and have been able to add postal bar codes
to my labels with this particular combination. Whenever I replace
that specific Excel spreadsheet with a different sheet (containing
identical information) I get a "Zip Code Invalid" message on the
labels. My data list contains many zip codes beginning with zero and
the only way I can record and import them properly is to formar them
as text in Excel. (Could this be part of the problem?) I'm trying to
"retire" from this particular job, and don't know how I can pass it
on to someone when the bar codes (essential for our bulk mailings)
cannot be included. HELP!