Problems with MailMerge - help needed.

[Chris Mitchell]

I have a single Excel Workbook containing several Worksheets.



I have a Word document for each Worksheet, and use MailMerge to incorporate
the data from the Spreadsheet into the relativeWord document.



I then created a master Word document to bring the various sections of the
report together by including the various files that are the various Word
documents. However when I do this the master document expects to get all
MailMerge data from the same Worksheet and doesn't merge.



Can I set things up such that each section of the report will get its data
from a different Worksheet within the same Workbook? If so how.? If not is
there another way around this problem?



TIA.

 

[Peter Jamieson]

Can I set things up such that each section of the report will get its data

from a different Worksheet within the same Workbook? If so how.? If not is
there another way around this problem?

No, you have to have to have one mail merge main document to get the data
from each worksheet in the workbook (unless you can combine the data in all
the worksheets into a single worksheet and go that route.

You can create an additional non-mailmerge document with an INCLUDETEXT
field for each of these sections, then select all those INCLUDETEXT fields,
use F9 to refresh their results, and you will have a complete document. Use
ctrl-shift-F9 if you want to replace the INCLUDETEXT fields by their results
in order to keep a copy of th efinal result. Make sure paragraph and other
styles in the different documents do not clash.