Is it MERGE or ME

[Rohn]

When I merged the data from my excel spreadsheet in to the form letter, the records seem to hang up somehow. All the records are there in the original spreadsheet (xls), they aren't all there on one page in the new file. When checking the merged data, it seems to show 2 or more identical records (and it seems to place the merged data as if it is taking every third record from excel.) The next record button indicated that there are multiple entries of the same records and I was expecting the 44 records to be displayed over two pages, not 6 records per page and 36 pages of records with many being duplicates. I am filtering the data down from 3700 records down to the 44 just so that I can iron out problems before I merge the entire record set.

I even tried moving the data to Access and also using the: File/Clean/Remove Formatting feature within Excel, but neither idea worked.

Anyone have a clue as to what I am doing wrong? I have three other files/databases that I merge information from without any problems? Now this? Until now, I had considered myself fairly proficient at Word, Excel and Access.

Thanks in advance for any ideas!!!!
_____
Rohn

 

[Tig]

I'm getting the same problem when I import information from Access into a
form letter in Word. I don't know what is wrong either. I get the identical
records and when I click to show the next record, I have to click 2 times to
move to the next record. When I merge into a new document, the one that seems
to "hang" is the one that is missing in the new file. If you find out
anything, please let me know.

I've even tried reinstalling/repairing my Microsoft Office with my disks and
that doesn't help. All I get is an error stating that it can't find the ODBC
data source in the registry. Any suggestions?

 

[Cindy M -WordMVP-]

Hi Rohn,

Which version of Word are we dealing with, here?

Do you see the problem only with this one main merge document? Or is it happening now in all documents?

Are you using a Tablet PC, by any chance?

When I merged the data from my excel spreadsheet in to the form letter, the records seem to hang up somehow. All the records are there in the original spreadsheet (xls), they aren't all there on one page in the new file. When checking the merged data, it seems to show 2 or more identical records (and it seems to place the merged data as if it is taking every third record from excel.) The next record button indicated that there are multiple entries of the same records and I was expecting the 44 records to be displayed over two pages, not 6 records per page and 36 pages of records with many being duplicates. I am filtering the data down from 3700 records down to the 44 just so that I can iron out problems before I merge the entire record set.

I even tried moving the data to Access and also using the: File/Clean/Remove Formatting feature within Excel, but neither idea worked.

Anyone have a clue as to what I am doing wrong? I have three other files/databases that I merge information from without any problems? Now this? Until now, I had considered myself fairly proficient at Word, Excel and Access.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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