Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Missing information when merging excel sheet in Catalogue document
I'm using Office 2000. I've set up an excel speadsheet with 40 lines of
contacts (names, addresses, etc.). I've also set up a main document in Word 2000 as a catalogue file, and I have a next record (Word field) field after all of the merge fields. Problem: When I merge to a new document, some contacts are missing. How do I get it to include everything. I suspect it has something to do with after I sort the spreadsheet. Before sorting, everything merges fine, but if I sort in the excel sheet or use the query option in Word, I am missing contacts (merge data). Also, once I go forward with it, I can't go back. I've also tried copying and pasting into new documents and spreadsheets. |
#2
|
|||
|
|||
Hi ?B?ZnJlZGdv?=,
I'm using Office 2000. I've set up an excel speadsheet with 40 lines of contacts (names, addresses, etc.). I've also set up a main document in Word 2000 as a catalogue file, and I have a next record (Word field) field after all of the merge fields. If you've set up a catalog merge, then I don't think you should have a NextRecord field in there. That would have the effect of dropping every second record. Problem: When I merge to a new document, some contacts are missing. How do I get it to include everything. I suspect it has something to do with after I sort the spreadsheet. Before sorting, everything merges fine, but if I sort in the excel sheet or use the query option in Word, I am missing contacts (merge data). Also, once I go forward with it, I can't go back. I've also tried copying and pasting into new documents and spreadsheets. 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel date format merging to Word XP version | Mailmerge | |||
Merging excel 2003 spread sheet to word 2000 document | New Users | |||
Can you use reference information in Word like you can with Excel? | Microsoft Word Help | |||
Format Excel data for merging in Word | Mailmerge | |||
I can't open the embedded excel sheet in one of my word document . | Microsoft Word Help |