Select Table dialog box after choosing data source

[Paula Jern]

We are using Mail Merge with an Excel data source (Office 2003). We only have
one worksheet in our Excel file. Right after we choose the data source, a
dialog
box comes up with the title 'Select Table' and the box contains the name of
the worksheet (with a dollar sign in front of it. How do we stop this dialog
box from showing up? I tried doing the following as suggested, but it did
not get rid of the dialog box:
From the Tools menu, select Options and then go to the General tab and
uncheck the box for "Confirm conversions at open"
Any other help on this issue would be greatly appreciated!
Thanks!

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?UGF1bGEgSmVybg==?=,

We are using Mail Merge with an Excel data source (Office 2003). We only have
one worksheet in our Excel file. Right after we choose the data source, a
dialog
box comes up with the title 'Select Table' and the box contains the name of
the worksheet (with a dollar sign in front of it. How do we stop this dialog
box from showing up? I tried doing the following as suggested, but it did
not get rid of the dialog box:
From the Tools menu, select Options and then go to the General tab and
uncheck the box for "Confirm conversions at open"

There is no way to suppress having to choose the data sheet/range when
connecting to an Excel data source. It is possible to connect to any range
within a single worksheet, so the connection wizard simply must ask you to
specify the exact source.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail