I just set up a test.
I make an Excel spreadsheet, with three worksheets contained in it (worksheets named Alpha, Beta, and Charlie).
When I went to the Mail Merging steps (within Word), and I had to go and select an existing list (my Excel doc) I was then asked to "Select Table" and the three names of the three worksheets contained within that one excel .XLS document displayed as Alpha$, Beta$, and Charlie$.
If you are not seeing that sort of selection, I would suppose you are doing something wrong - or else, perhaps your version of Work and excel are dramatically different than mine. I have Office 2003.
I am trying to create a mail merge that whose data source is an Excel workbook with a number of worksheets. I only need to mail merge against one of those sheets, but when I try to merge, no data comes back on my new document (all fields are missing)! If I run this same merge on an Excel workbook with only one worksheet, the merge works perfectly!
Can some one please tell me how to properly set up the mail merge when the data source is an Excel workbook with more than one sheet?