Mail merge w/ data source Excel workbook more than one sheet
by imimin - 9/6/06 12:07 PM
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?