A
Andrea
I use Office XP and keep running into the same problem.
When I export addresses from my database (FileMaker Pro)
into Excel, the first zero in the zip codes never
appears. So I use the format Cells, special, zip code
option. The zero now appears in Excel, however, when I
mail merge this in Word (in order to make labels,
envelopes, form letters, etc.) the first zeros in the zip
codes disappear again-- they do not appear in the merged
Word document! What is going on? The only way I can get
the zeros to remain in the merged Word document is by
manually going through the Excel sheet and adding an
apostrophe before each zip code-- however, if you are
doing 3,000 records, this takes forever! I never had this
problem with Office 2000--Help!
When I export addresses from my database (FileMaker Pro)
into Excel, the first zero in the zip codes never
appears. So I use the format Cells, special, zip code
option. The zero now appears in Excel, however, when I
mail merge this in Word (in order to make labels,
envelopes, form letters, etc.) the first zeros in the zip
codes disappear again-- they do not appear in the merged
Word document! What is going on? The only way I can get
the zeros to remain in the merged Word document is by
manually going through the Excel sheet and adding an
apostrophe before each zip code-- however, if you are
doing 3,000 records, this takes forever! I never had this
problem with Office 2000--Help!