Merge from two (or more ?) Excel-data-files

[Gilbert De Ceulaer]

Hi ! Am new to the group.

I know how to merge fields from an Excel-file into a Word-document.
Bus how can I merge fields from two Excel-files into a Word-document ?
Simple question, difficult answer ?
Can somebody help ?
Gilbert

 

[Cindy Meister -WordMVP-]

Hi Gilbert,

I know how to merge fields from an Excel-file into a Word-document.
Bus how can I merge fields from two Excel-files into a Word-document ?
Simple question, difficult answer ?

Depends on how you mean it Are we talking about two Excel files with
the same layout, where you essentially want to run one after the other?
Or do you mean two files where one has multiple (indexed) records for
single records in the other, and you want the merge result document to
show a list of items for each single record?

Both can be done, but as you say "difficult answer".

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail

 

[Gilbert De Ceulaer]

Hi Cindy,
Thanks for the reply.
The adresses for the letters to be sent are in one Excel file, and the
figures for each adress are in the other Excel file. They are both sorted on
the same key.
Gilbert

 

[macropod]

Hi Gilbert,

Given that both Excel files are sorted on the same key,
you should be able to use one Excel file to link to the
data in the other. Then you only need to merge on the one
file.

Cheers
PS: Remove NO.SPAM from the above before replying.

 

[Cindy Meister -WordMVP-]

Hi Gilbert,

The adresses for the letters to be sent are in one Excel file, and the
figures for each adress are in the other Excel file. They are both sorted on
the same key.

Are you familiar with MS Query from your work in Excel? Which version of Word
are we working with (so that I can tell you where to find the MS Query command
during mail merge)?

The basic steps you need to follow are listed in this KB article:

WD97: How to Use Query to Merge Two Excel Files for Data Source [Q180599]
http://support.microsoft.com?scid=kb;EN-US;Q180599


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail