Changing data source in the middle of a mailmerge main document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathy Webster - 23 Aug 2007 23:24 GMT

How do I change the data source during a merge?
I want the first part of the main document to use one data file, and the
second part of the main document to use a different data source.

TIA,
Kathy

Reply to this Message

Graham Mayor - 24 Aug 2007 07:37 GMT

You don't. It would have to be two merges using the same merge document.
Simply attach the second data source when you have completed the first one
and merge again.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do I change the data source during a merge?
> I want the first part of the main document to use one data file, and
> the second part of the main document to use a different data source.
>
> TIA,
> Kathy

Reply to this Message

Doug Robbins - Word MVP - 24 Aug 2007 10:52 GMT

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> How do I change the data source during a merge?
> I want the first part of the main document to use one data file, and the
> second part of the main document to use a different data source.
>
> TIA,
> Kathy

Reply to this Message

Rate this thread: