 |
 | 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 / March 2004Merging a Word doc to a particular sheet in Excel
I have an Excel workbook containing three separate sheets. Each sheet is formatted identically, but contains different data for that particular year. I don't have any problem merging to the workbook if there's only one sheet, or if I want to merge to Sheet 1, but it won't let me specify a different sheet. So how would I be able to merge my Word document to, say, the second sheet of three? Thanks. This is by design. Only the first worksheet can be used. You have to have 3 seperate workbooks or you have to move the worksheets to the first tab as needed. >-----Original Message----- >I have an Excel workbook containing three separate sheets. Each sheet is [quoted text clipped - 10 lines] > >. That is not correct. If the OLE DB Database Files method of connection is used, a dialog will appear containing a list of all of the sheets in the file, enabling you to select the required sheet.  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps > This is by design. Only the first worksheet can be used. > You have to have 3 seperate workbooks or you have to move [quoted text clipped - 18 lines] >> >>. Hi Mark, Under Tools>Options>General, check the Confirm conversions at Open box and when you select the datasource, use the OLE DB Database Files option. It you do that a dialog should appear from which you can select the sheet that you wish to use as the datasource. SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP >I have an Excel workbook containing three separate sheets. Each sheet is > formatted identically, but contains different data for that particular [quoted text clipped - 9 lines] > > Thanks. |
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.