 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2003merge Word letters w/ Excel Workbook that has more than one sheet
When merging to a document in Word with an Excel workbook that has more than one worksheet, how do you type in the Excel source workbook in order to be able to use all sheets of the workbook as the source and not just the first worksheet of the workbook. Unfortunately Word can only use a single worksheet as the data source for a merge, unless you use either MS Query and ODBC, or WOrd VBA to connect to your sheet, in which case you can use a UNION query to get the data from all the Worksheets. But that is quite difficult to do and may not even be possible if you have lots of sheets. A simpler workaround is probably to copy everything (perhaps using some Excel VBA) into a single worksheet before mergeing. -- Peter Jamieson - Word MVP > When merging to a document in Word with an Excel workbook > that has more than one worksheet, how do you type in the > Excel source workbook in order to be able to use all > sheets of the workbook as the source and not just the > first worksheet of the workbook. Hi Irene, > When merging to a document in Word with an Excel workbook > that has more than one worksheet, how do you type in the > Excel source workbook in order to be able to use all > sheets of the workbook as the source and not just the > first worksheet of the workbook. Do you want to use all the sheets at once, or just be able to select any one, particular sheet? Which version of Word do you have? 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 :-) |
Reply to this Message |
 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.