Reply
 
Thread Tools Display Modes
  #1   Report Post  
Spring Velazquez, Widener University
 
Posts: n/a
Default Zip code merging when 5 AND 9 digits

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?
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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?



  #3   Report Post  
Spring Velazquez, Widener University
 
Posts: n/a
Default

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?




  #4   Report Post  
Graham Mayor
 
Posts: n/a
Default

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?



  #5   Report Post  
Spring Velazquez, Widener University
 
Posts: n/a
Default

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?






  #6   Report Post  
Graham Mayor
 
Posts: n/a
Default

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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get the "0" to print in the zip code when mail merging f. Ragmop Microsoft Word Help 4 January 11th 05 08:51 PM
Errors in Postal bar code Tom Hadley Mailmerge 0 January 10th 05 10:13 PM
How do I use the PRINT field code to ... Dave Microsoft Word Help 3 December 13th 04 03:06 PM
Envelope Bar Code dwhithome Page Layout 1 December 8th 04 03:33 PM
Mail Merge Zip Code will not format correctly ba Mailmerge 1 December 8th 04 02:15 AM


All times are GMT +1. The time now is 08:19 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"