Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the "0" to print in the zip code when mail merging f. | Microsoft Word Help | |||
Errors in Postal bar code | Mailmerge | |||
How do I use the PRINT field code to ... | Microsoft Word Help | |||
Envelope Bar Code | Page Layout | |||
Mail Merge Zip Code will not format correctly | Mailmerge |