If it is Word 2000 or earlier, check the "Select Method" box in the Open
Data Source dialog, then choose the ODBC option when offered, then click the
option button in the next dialog box and check all the options. Be prepared
to use "format switches" in your Word mergefields to format date and numeric
data.

Peter Jamieson
"Keith9360" wrote in message
news
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?