If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#2
|
|||
|
|||
Word can only use a single work sheet as a data source for the one
mailmerge, not multiple sheets. To be able to select a particular sheet, from the Tools menu, select Options and then go to the General tab and check the box for the "Confim conversions at open" item. Then when you attach the data source to the main document, you will be given a number of options for the method of connection to be used. One of them will give you the ability to select a particular sheet in the work book. -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Graham" wrote in message ... I need to extract data from up to 50 different worksheets in the same workbook to merge to a standard word document. When I set up the data source, it always defaults to the first sheet in the workbook. How do I get it to look at the current or open sheet that I want to extract the data from ? Many Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000 | L Mehl | General Discussion | 2 | July 27th, 2004 07:20 PM |
Protecting selected Worksheets at Once | Ron de Bruin | Worksheet Functions | 1 | March 18th, 2004 07:56 PM |
Sources and Uses | BldrBldr | Worksheet Functions | 2 | February 11th, 2004 03:22 PM |
LOOKUP to various different worksheets | David | Worksheet Functions | 2 | November 13th, 2003 07:01 PM |
Exporting multiple worksheets to one .CSV | Alan Cocks | Worksheet Functions | 1 | November 13th, 2003 10:56 AM |