Blank Fields do not merge properly

[Joel]

I have created a form letter in Word 2002 using a merge
with an excel document.
Results of my merges are not correct.
When I merge the data, blank fields from the excel sheet
display the data from the previous record in the merge
results.
PLEASE help.
I have found solutions for 97 and 2000 but they don't work
for 2002.

 

[Cindy M -WordMVP-]

Hi Joel,

This problem crops up occasionally, and appears to be due to
the new default connection method, OLE DB. In the Word 2002
section of my website's Mail Merge FAQ you'll find
instructions on how you can set up Word to merge the way Word
97 and 2000 did; try that.

I have created a form letter in Word 2002 using a merge
with an excel document.
Results of my merges are not correct.
When I merge the data, blank fields from the excel sheet
display the data from the previous record in the merge
results.
PLEASE help.
I have found solutions for 97 and 2000 but they don't work
for 2002.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail