Two Sources of Source Data

[MaxArk]

Is it possible to use two separate sources of data in one mail merge
document?

I have a mailmerge document that use core data from an Excel worksheet,
but also displays statistical information from a second worksheet in the
same Excel workbook.

If I had to depend on just one worksheet, I would have to replicate the
statistical data on all rows of data in the core database. Seems kinda
daunting.

Jenn

 

[Doug Robbins - Word MVP]

Mail merge can only use a single flat file as the data source. Therefore,
you are going to need to combine the two Excel spreadsheets to achieve what
you are after.

An alternative would be to use a "roll-your-own" equivalent to mail merge
where you create the mail merge main document as a template with docvariable
fields and you write VBA code to iterate through the two Excel data sources
creating a new documnet for each record and setting the values of the
variables in each document to the values from the records in the data
sources.

However that is probably going to be even more daunting that just combining
the two Excel data sources and using mail merge.

--
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, originally posted via msnews.microsoft.com