View Single Post
  #7   Report Post  
Spring Velazquez, Widener University
 
Posts: n/a
Default

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?