Mail Merge Word 2003 Excel 2003 database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gwendolyn - 08 Feb 2006 14:01 GMT

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.

Reply to this Message

Cindy M -WordMVP- - 08 Feb 2006 14:59 GMT

Hi =?Utf-8?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 to this Message