Re: Problems with MailMerge - help needed.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 14:35:43 +0100

> Can I set things up such that each section of the report will get its data
> from a different Work*** 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 work*** 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. 

-- 
Peter Jamieson
"Chris Mitchell" <chris.a.mitchell@MAPSONbtinternet.com> wrote in message
news:cffks8$ctq$1@hercules.btinternet.com...
> I have a single Excel Workbook containing several Worksheets.
>
>
>
> I have a Word document for each Work***, and use MailMerge to
incorporate
> the data from the Spread*** 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 Work*** and doesn't merge.
>
>
>
> Can I set things up such that each section of the report will get its data
> from a different Work*** within the same Workbook?  If so how.?  If not
is
> there another way around this problem?
>
>
>
> TIA.
>
>
Quantcast