Mail Merge Problem

[Sandra via OfficeKB.com]

I have a Word 2000 document and I’m trying to merge data from an Excel 2000
spreadsheet. When I click on the merge field that I want to use, ie:
Address1, Address2, Address3, etc., the results show the field before the one
I’ve chosen, eg: Address1 inserts dates of birth, Address 2 is that
belonging to Address 1, Address3 is that belonging to Address2, etc.

Can anyone tell me why this is happening and how to overcome it? I’ve tried
copying the data to another work book but this has not rectified the problem.

Thanks in anticipation.

 

[Peter Jamieson]

Does a Workbook with some fresh test data typed from scratch work OK?

Does your Workbook have any hidden columns?

Peter Jamieson