I have a document in Word, and a spreadsheet in Excel with the names,
addresses, etc. I need to mail merge, and I have done this plenty of times,
and my other letters with mail merge to Excel are working fine - so I don't
understand how or why I'm having this difficulty.

When I choose the data source, it gives an error message of "no visible
table." (When I do this with other letters/excel sheets, a table pops right
up onto the screen). Next, it will say "Record 1 contains too few data
fields" and there are only 2 lines on the spreadsheet it is trying to access.
There is only a letter M_ and M_1 on the info its trying to access. The
actual spreadsheet it should be accessing has 60 rows with loads of info.

I've tried to define a table in Excel, but when its time to identify a
range, I don't seem to be doing that right, so I'm stuck.

I would appreciate any help someone could give me.