Hi ZootRot,
MS Word & Excel 2002 SP2
I want to merge Word fields from multiple sheets in the same Excel workbook.
Used to be able to do this with previous versions of Excel. Can it still be
done, and if so how, and what type of connection is best to be used (DDE,
OLE, ODBC, etc)?
No version of Word was ever able to link up to multiple worksheets for a
single merge. Using MS Query, it's possible to a limited degree; search the
Knowledge Base on microsoft.com for an article on this, if it sounds familiar.
If what you really mean is to be able to choose any single worksheet from a
workbook for a particular merge, yes, that can be done. OLE DB and ODBC should
allow this with no great problems. But I recommend ODBC because there are
other snags with using OLE DB + Excel.
You'll find instructions in the Word 2002 section of my website's Mail Merge
FAQ on how to specify other connection methods. Once you've got ODBC, if you
don't see the worksheet (probably not if you haven't assigned it a range
name), click "Options" and activate "System tables".
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail
