[Tracy at Axis]

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

[Doug Robbins - Word MVP]

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

[Tracy at Axis[_2_]]

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

[Graham Mayor]

I don't think the dialogs changed between 2002 and 2003 - the change
occurred after 2000.
You will get the list of tables if you use OLE DB, ODBC or the converter.
DDE only shows the entire spreadsheet.
Turn off the confirm conversions option and try again.
If you use other converters than DDE you may have to use formatting switches
on your merge fields to convey the correct data
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tracy at Axis wrote:
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

[Tracy at Axis[_2_]]

Well something had changed, but your advice has worked - thank you. I did
need to use formatting switches to tidy the data up.

"Graham Mayor" wrote:

I don't think the dialogs changed between 2002 and 2003 - the change
occurred after 2000.
You will get the list of tables if you use OLE DB, ODBC or the converter.
DDE only shows the entire spreadsheet.
Turn off the confirm conversions option and try again.
If you use other converters than DDE you may have to use formatting switches
on your merge fields to convey the correct data
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Tracy at Axis wrote:
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