Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2004

Tip: Looking for answers? Try searching our database.

Select Table dialog box after choosing data source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paula Jern - 03 Dec 2004 22:13 GMT
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- - 04 Dec 2004 16:28 GMT
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
[quoted text clipped - 5 lines]
> 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 :-)

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.