Can I do a mail merge with 2 separate data sources

[LouLou]

I want to do a mail merge with data from 2 separate data sources but am
having difficulties. I've created 2 separate files for my form letter and
then imported a file into the other hoping that this would work. No Luck!
Any suggestions out there?

 

[Peter Jamieson]

The short answer is "no", but it depends on what you mean.

A lot of people want to do something like invoicing, where they have a list
of invoices, then a list of detail lines for each invoice. If that is the
kind of thing you want to do, unfortunately Word is not designed to do that
sort of thing and you would be much better off doing it in something like
Access. However, the following articles show ways to do that sort of thing
in Word:

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

and/or

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

If that isn't the sort of thing you are trying to do, maybe you could
provide more detail, e.g.
a. what is in each data source?
b. what does the output need to look like?
c. (Which version of Word?)

Peter Jamieson

 

[LouLou]

Thanks Peter. You're quite correct it is a complete No No! I looked at
your suggestions but unfortunately they didn't work out for me - we're still
on Office 2000! Anyway, I've resolved it now, I managed to think outside of
the box. I linked my spreadsheets and inserted the information from one into
the other and obviously any time the main spreadsheet is amended the second
spreadsheet is updated due to the link. Doing it this way I was able to
enter a new mergefield and produce all the documentation required.

Many thanks for your help.

LouLou