Mail Merge Problem

M

Melissa

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.
 
S

Suzanne S. Barnhill

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)
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
REINSTALLING MS OFFICE PRO PLUS 2019 0
Auto Merge text from multiple sources 0
Mail Merge Switch - Dollars to Words 0
Duplicate Mail Merge Record Every Time 5
Mail Merge Help 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Integrating information from Word to Excel (not mail merge) 1

Top