I need to do a mail merge, the data source is an Excel Workbook, more
specifically a single sheet in that book. When i attempt to open data
source, i can only open the main document. when i select the work book the
only option i get is to select "Entire Spreadsheet". But the Fields in
"Insert Merge Fields" arent the firlds that I want, further they dont have
any information in them at all. How do I get the fields that I want, from
the sheet that I want from the actual Workbook?