Not sure which phase of the mail merge process this 'data list' is, but if you start a new mail merge, then when you got to the step 'Use existing list', and choose Browse, you will be able to navigate to your Excel file, select it, and you will get a 'Select Table' dialog box and that is where your see the different sheets listed to choose from. You need to make sure though the file is an excel file not a csv data file
Hope this helps
Which version of Excel are you running
Ok here is how to get to the source file and be able to choose the sheet of your choice
- From the Get List pull-down menu, select Recipients List section, then select Open Data Source...
- Choose a Data file dialog box appears- Now navigate to your excel file and select it- When you click Open, you should see the sheets listed in the dialog box that comes up.
- Select the desired sheet
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
hmm.. that particular file could be corrupted. Try creating a new file with a few addresses on 2 sheets and let me know if the sheets show up when you select this file as your source file