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

Format Zip Codes Correctly for a Mailmerge 3
Word 2007 mail merge repeating address problem 0
Can't mail merge a zip code starting with a zero (02657) 1
Leading 0 in Mail Merge document 4
Leading zero from Zip Code not print on Label Merge 6
zip code problem 1
Mail Merge drops 1st digit ("0") converting from Excel to Word 3
Mail Merge Labels (Word 2007) w/ Excel (2007) 2

Top