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.