From the Tools menu in Word, select Options and then go to the General tab
and check the box alongside the "Confirm conversions at open" item. After
doing that, when you attach the data source to the mailmerge main document,
you will be given a number of options for the method of connection to use.
One of them (probably the DDE option) should give you the ability to access
the required sheet.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"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?