View Single Post
  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Cate Cate is offline
external usenet poster
 
Posts: 3
Default My zip code format is lost when merging from Excel to Word...

I have read the entire steam, carefully read your linked page, and also
checked & double checked my typing. I continue to get an error message that
the mergefield zip \# (the backslash doesn't show, though) is not found in
the header row of my database. Everything stops at that point.
--
Cate


"Graham Mayor" wrote:

The use of zip codes formatting switches is explained in detail in my web
page http://www.gmayor.com/formatting_word_fields.htm

Essentially Word is expected to provide the formatting and will strip
leading zeros from numbers. You can use a number switch or mask to restore
that zero. At the place you want the zip code press CTRL+F9. This will give
you a pair of field brackets {}

Between the brackets type the required field data, presumably {Mergefield
Zip} then add the switch i.e.
{Mergefield Zip \# "00000"}. With the cursor in the field. Press F9 to
update. This should toggle the field display, but if it doesn't ALT+F9 will.

If you need one of the more complicated formatting options, see the web
page for the content.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Merging Zip Code Errors wrote:
I am having the same problem as Suzanne. I FOLLOWED THE POSTED
DIRECTIONS! How about a detailed example?

"Graham Mayor" wrote:

Did you update the field after adding the switch?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Judy F. wrote:
yes I have viewed both website suggestions and followed both advice,
but it is not showing the "0"

"Suzanne S. Barnhill" wrote:

Did you look at the recommended Web page?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

"Judy F." wrote in message
...
I am also having the same problem.
I have changed the format to specialzip code when I merge, I do
not get the initial "0" in my zip code.
I change the format to text, and when I merge I only get the "0"
without the remaining digits in the zip code.
I entered the questioning zip codes with a ' prior to the 0 and
when I merge only the "0" without the remaining digits in the zip
code show up.

Help?


"Suzanne S. Barnhill" wrote:

If you're using Word 2002 or 2003, see
http://homepage.swissonline.ch/cindy...002/MM2002.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

"MarianneME" wrote in
message
...
I am merging addresses from Excel to Work and I lose zip code
formatting during the merge so that for all zip codes that begin
with a zreo, the zero is dropped. I have never had this problem
before, how can I fix this? Thanks!