This only happens on one file. I received a download of data in an
excel file (same version I run, same op system I run) and saved the
original file and then saved a copy of the file under a new name and
sorted the data, split the data between 3 worksheets based on specific
criteria, applied general formating (col width, row height, color,
etc.).

I use the merge wizard in Word 2002, which I have done hundreds of
times. But this document is giving me intermittent problems. I follow
the below method.

Document Type: Letter
Start Document: Use the current doc
Select recipients: Browse
I select the copy of the original file
Select Table: I choose Sheet1$ from the following options: additional$,
approved$, dvo7lkup$, rejected$)

When the mail merge recipient window opens it is not populated with
Sheet1$ information it has sheet additional1$

I X out and go back to:

Select a different List
I select the same file (copy of the original file)
Now the Select Table has the following options: Sheet1$, Sheet2$,
Sheet3$, and so on.
I select Sheet1$ (I have selected them all in hopes of troubleshooting)
and the mail merge recipient window is blank.

If I close out and start over it is correct. But if I decide that I
need to tweak the data more and cancel the merge and come back later
the same thing happens again.

I tested the original doc and I do not get the errors. I checked to see
if there was code b/c there shouldn't be on a simple text doc. and
there isn't any code. the VBA is the same on the original as it is on
the copy. The original was sent from the same version of windows and op
system.

I cannot figure this out. I know just use the original but what if this
occurs again.

I would appreciate any insight anyone can give me. Thank you so much!