From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. After
doing that, when you attach the data source to the Mail Merge main document,
you will get a dialog box asking for the method by which the connection
should be made. Try the DDE option.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Tracy at Axis" Tracy at
wrote in message
...
We have an existing Excel spreadsheet with multiple spreadsheets, the data
is
also used as mail merge data with Word. This worked perfectly in Office
2002, as we could choose which worksheet to use. Updated recently to
Office
2003 and cannot get this to work, only get the option to choose Entire
spreadsheet, but not the individual worksheets as before. Please help -
thanks