Thanks for the reply, but am already doing this. The data from the 1st
worksheet is all displayed correctly, the problem is that I cannot choose to
use different worksheets each time I either open the word document, or open
new data source. As you suggested I am choosing DDE option, in 2002 the
next dialogue box showed a list of worksheets where we could choose which one
we wanted the data from. In 2003 version only displays 'entire
spreadsheet'. I have tried defining the worksheet in excel but has made no
difference.
Do you have any other suggestions?
"Doug Robbins - Word MVP" wrote:
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