I am attempting a word/excel labels merge. I have done
this many times without problem. Now, when pulling the
excel data into word, word is removing the firt digit of
the zip code if it is a zero. In excel, the zip code
column is formatted as a zip code. I have also tried it
formatted as pretty much every other option (text,
general, custom etc.) If anyone has any suggestions they
would be greatly appreciated.
Suzanne S. Barnhill - 31 Jul 2003 16:00 GMT
Is this Word 2002? If so, you may find you need to connect to Excel using
DDE instead of the default OLEDB, which doesn't preserve the number
formatting applied in Excel. See
http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm
--
Suzanne S. Barnhill
Microsoft MVP (Word)

Signature
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
> I am attempting a word/excel labels merge. I have done
> this many times without problem. Now, when pulling the
[quoted text clipped - 4 lines]
> general, custom etc.) If anyone has any suggestions they
> would be greatly appreciated.