Thanks -- it worked, sort of. I get five-digit zips instead of four-digit
ones. But it doesn't merge the nine-digit ones. I get five zeros instead. Is
this because I have the field formatted as Zip Code instead of Zip Code +
Four? When I change the format to Zip + Four, all my five-digit zips turn
into five zeroes, a hyphen, then FOUR numbers of the five-digit zip code. My
database is over 5000 entries -- too many to go through and change it all by
hand -- there's got to be a better way!
How can something so seemingly simple be so difficult to fix?!
"Peter Jamieson" wrote:
This
{ IF {MERGEFIELD ZIP } 99999" { MERGEFIELD ZIP \# "00000'-'0000" }" "{
MERGEFIELD ZIP \# "00000" }"}
should be more like this
{ IF {MERGEFIELD ZIP } 99999 "{ MERGEFIELD ZIP \# "00000'-'0000" }" "{
MERGEFIELD ZIP \# "00000" }"}
Everything else looks OK to me (as ong as /all/ the {} are the sort you
enter with ctrl-F9)) although I would probably lay it out either as
{ IF { MERGEFIELD ZIP } 99999 "{ MERGEFIELD ZIP \#"00000'-'0000" }" "{
MERGEFIELD ZIP \# "00000" }" }
or
{ IF { MERGEFIELD ZIP } 99999 "{ MERGEFIELD ZIP \# "00000'-'0000" }" "{
MERGEFIELD ZIP \# "00000" }" }
primarily becasue Word itself usually has space after { and before }
--
Peter Jamieson
http://tips.pjmsn.me.uk
"MrsMac" wrote in message
...
Office 2003
I've been reading a lot on Graham's site about fixing zip codes, but using
switches and field codes is all new to me and I can't figure it out. I
keep
getting the error message "Error! Missing test condition" when I toggle
back.
I'm trying to get an Excel list that has 5-digit zips and 9-digit zips to
print out properly in a label merge. Here's what I have for the last line
of
merge fields:
{ MERGEFIELD CITY }, {MERGEFIELD STATE } { IF {MERGEFIELD ZIP } 99999" {
MERGEFIELD ZIP \# "00000'-'0000" }" "{ MERGEFIELD ZIP \# "00000" }"}
I'm using Ctrl F9 for the brackets, I've entered the above from Graham's
site, but am not sure about spacing, etc.
Thanks for any help -- Mrsmac