I meant use the field twice - once with and once without the switch to
establish what occurs when the raw data is merged, but I want to know what
happens with 9 digit zips as it was these that you were having problems with
using the codes from my web site.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Widener University wrote:
Graham,
When I changed LrZip to {MERGEFIELD LrZip\# "00000'-'0000"} I get the
following problems with my zip codes:
00001-9063 - the zip code is led by 4 leading zeroes. When you say and
{MERGEFIELD LrZip} should that be a part of the same zip code field?
In other words, when I toggle the field LrZip should it say:
{MERGEFIELD LrZip\# "00000'-'0000"} and {MERGEFIELD LrZip} as the
same field? When I just leave the field as {MERGEFIELD LrZip} I get
the +4 digits fine on the zip code, but that is when the leading
zeroes are lost.
Spring
"Graham Mayor" wrote:
Forget the conditional field for the moment - what happens with your
9 digit numbers when you insert the following fields?
{ MERGEFIELD LrZip \# "00000'-'0000"}
and
{ MERGEFIELD LrZip}
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Widener University wrote:
Graham - I did follow the instructions on your website. What is
happening is that when a nine-digit zip code is already present -
the +4 numbers are replaced with 4 zeroes. Any suggestions?
Spring
"Graham Mayor" wrote:
Have a look at the relevant section at
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
Widener University wrote:
Peter - you are a genius! I haven't delved that much into
programming in Word so I was not aware of that. Now I'm going to
push my luck - some of the zip codes that come in already have the
+4 - using the syntax below, it's actually replacing the imported
+4 zip with 4 zeroes. How could I arrange this to look at the +4,
if it's there
leave it, but if it's not add the zeroes. This all started because
of the leading zeroes in my zip code being stripped!
Spring
"Peter Jamieson" wrote:
The main thing is that all the {} have to be the special field
braces that you can insert using ctrl-F9. The ordinary ones on
the keyboard do not work.
Peter Jamieson
"Spring Velazquez, Widener University" Spring Velazquez, Widener
wrote in message
...
Our academic software has a program that allows us to run
letters using a macro program (WINTEG.WORD) between the
software and Word. One of the problems is that the leading "0"
is lost during the process. Have visited www.gmayor.com for
solutions. Using {MERGEFIELD Zip\# "00000"} doesn't work
when there are 9 digits in the zip code. I have tried to use the
{IF {MERGEFIELD...} to add trailing zeroes to the 5 digit field
suggestion on the
site also. Once I update the field though, all I get is
MERGEFIELD rather than LrZip and the data doesn't merge.
Could this be a syntax issue?
My field is as follows { IF { MERGEFIELD LrZip } "9999" "{
MERGEFIELD LrZip\# "00000'-'0000"}""{MERGEFIELD LrZip\#
"00000"}-0000" }
Any suggestions?