Re: Switches/field codes to fix zip code in merge

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" <MrsMac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B40B5C74-1E32-4DE0-9F43-03F1CC219D16@xxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Switches/field codes to fix zip code in merge
    ... MERGEFIELD ZIP \# "00000"}"} ... switches and field codes is all new to me and I can't figure it out. ... getting the error message "Error! ... I'm trying to get an Excel list that has 5-digit zips and 9-digit zips to ...
    (microsoft.public.word.mailmerge.fields)
  • Archive::Zip and File::Find errors
    ... I am using the code below to unzip a whole series of files but am ... getting an error message "can't open fred.zip: ... find sub { ... for (@zips) { ...
    (comp.lang.perl.misc)
Loading