If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Zipcode Errors with Mailmerge
Why does mailmerge remove the first zero from the zipcode area of the address
line? It is definitely not the source formatting, but for some reason it always takes it out and I do not know how to fix it! I am pulling my information from an Excel sheet so I do not think it is software compatability issues. Can anyone help??? |
#2
|
|||
|
|||
Zipcode Errors with Mailmerge
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "B.A.D." wrote in message ... Why does mailmerge remove the first zero from the zipcode area of the address line? It is definitely not the source formatting, but for some reason it always takes it out and I do not know how to fix it! I am pulling my information from an Excel sheet so I do not think it is software compatability issues. Can anyone help??? |
#3
|
|||
|
|||
Zipcode Errors with Mailmerge
Hi B.A.D,
The following field code correctly formats 5-digit and 5+4-digit Zip Code data, even where the source data may have incorrect formatting such as a hyphen followed by trailing 0s after plain 5-digit Zip Codes (eg because a db only accepts Zip Codes in the 5+4-digit format) or is formatted as a 5-digit or 9-digit string without hyphens. A data field named ‘ZipCode’ is assumed. {QUOTE {SET Zip {MERGEFIELD ZipCode}} {IF{Zip} 99999 {SET Zip {Zip \# "00000'-'0000"}}} "{=-{=-{Zip}-Zip}/2 \# 00000;;}{=-({Zip}*(-1)-Zip)/2 \# ;-0000;}"} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. -- Cheers macropod [Microsoft MVP - Word] "B.A.D." wrote in message ... Why does mailmerge remove the first zero from the zipcode area of the address line? It is definitely not the source formatting, but for some reason it always takes it out and I do not know how to fix it! I am pulling my information from an Excel sheet so I do not think it is software compatability issues. Can anyone help??? |
Thread Tools | |
Display Modes | |
|
|