Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Word 2003 Excel 2003 database
When I try to mail merge an Excel 2003 spreadsheet into a Word 2003 document,
only the first 90 out of 156 records are available. In fact I copied the second half of the Excel file and did a second merge. I got all the records but the data was mixed up in the Word document. I have had success with mail merge using alternate databases. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Word 2003 Excel 2003 database
Hi ?B?R3dlbmRvbHlu?=,
When I try to mail merge an Excel 2003 spreadsheet into a Word 2003 document, only the first 90 out of 156 records are available. In fact I copied the second half of the Excel file and did a second merge. I got all the records but the data was mixed up in the Word document. I have had success with mail merge using alternate databases. When this kind of thing occurs, it's usually either a problem in the Excel data structures OR the Word document structures. If your test with alternate databases (including an Excel workbook) was successful, then the problem is likely in the Excel data structures. You could try copy/paste into a Word table, then copy/paste back into a new Excel workbook. Or export the Excel data to a delimited text file, then import it back into a new Excel workbook. If your test merges were not with the original Word document, then the problem could still be in the Word document. Try copying all but the last paragraph mark into a new Word document. 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 | |||
i can't see the addresses in a Word 2003 mail merge from Excel | Mailmerge | |||
Word 2003 mail merge conditional numeric formatting | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge | |||
Exchange 2003 - Outlook 2003 - Word 2003 mail merge | Mailmerge | |||
How do you set up a label mail merge with Excel as source in 2003. | Mailmerge |