Mail Merge: The merge provides data from the previous record

I hope someone can help please.

I have created a data source (Excel 2000) and the data is sitting in the right columns; I have also created a word document (Word 2000) for the mail merge.

I have inserted the merge fields into the word document but when I preview the merged document (using the <<ABC>> button), the following happens:

the mergefield from column 2 shows the data from column 1
the mergefield from column 3 shows the data from column 2
the mergefield from column 4 shows the data from column 3

and so on.

I have searched the web for the last few hours to try and resolve this but no-one else seems to have had the same issue.

I have found an article on the MS website called "WD2000: Incorrect Results When You Perform Mail Merge with Excel Data Source" and have made sure that I have SP3 installed.

I have also tried the workaround (in that article) but, when I do that and try to insert a mergefield, it only shows about 60 mergefields and (surprise, surprise) the mergefields I need are in columns 70 onwards !!!

Can anyone help me work out what to do to correct this please ?

Thanks for that.

Yes, I have performed a merge and it does bring the wrong data up but thanks for the suggestion.

Thanks for trying to help but I solved my problem. It appears there can be
no blank column headings in the Excel file.