Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Merging Zip Code Errors
 
Posts: n/a
Default My zip code format is lost when merging from Excel to Word...

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!




 
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
Excel date format merging to Word XP version Linda - Xtremly Peeved Mailmerge 11 April 12th 05 06:50 AM
How do I get UK date format merging into word from Access? Gavvers Mailmerge 3 March 18th 05 12:24 PM
How do you keep the currency format when merging data from Excel? MJW Mailmerge 2 February 22nd 05 06:33 PM
Zip code merging when 5 AND 9 digits Spring Velazquez, Widener University Mailmerge 13 January 21st 05 01:54 AM
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 07:27 AM.

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"