Merging a Word doc to a particular sheet in Excel

[Mark]

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.

 

[Guest]

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.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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.

--
Please 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

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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.

--
Please 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