I found Graham's website shortly after posting question. I printed his 19
page PDF file and applied his suggestions. Then I tried typing in the
IF-Then-Else solution. It worked for the Zip + 4 entry, but the zipcodes
under 10000 are still coming up as 4 digits. I tried using the Rules on the
Ribbon to enter the If-Then-Else, but that was a failure. So I manually typed
the code. I seem to recall that under Word 2002 it was easier to enter
MERGEFIELD entries. I'm not doing this correctly because I see others have
had their success noted on other posts. I'm merging labels only, a task I
have performed with prior versions of Word.
--
Bob B
"Doug Robbins - Word MVP" wrote:
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"BobB" wrote in message
...
Using Excel 2007 and Word 2007, I created a mail list in Excel formatting
the
5-digit zipcodes as ZIPCODES and the 9-digit zipcodes as ZIPCODE+4. When I
previewed and printed the merged data, I saw the zipcodes with a leading
zero
had the zero truncated (ie 02035 printed as 2035) and the 9-digit zipcode
printed as a 0. I temporarily resolved the problem by changing all
0-prefixed
zipcodes with '0 to make it a text field. I defined the 9-digit field as
TEXT
also. Anyone else encounter this problem? Any suggestions how I can fix
this?
Thanks in advance for any advice given..
--
Bob B