more than one data source

[DSK_7]

Hi,
Is it possible for mailmerge to use separate data sources (excel sheets)?

More specifically, I have one Word document and I have 3 data tables
existing in different sheets but still within one Excel file.

Currently there is one huge excel file and we are about to get to the column
limit of excel. Also since several people are responsible for different
pieces of information, it would be beneficial to break out the giant
spreadsheet into the 3 main components that each one is responsible for.

Thanks,
DSK_7

 

[Peter Jamieson]

Is it possible for mailmerge to use separate data sources (excel sheets)?

There can only be one data source.

But how to approach this depends on what you are trying to do. Are the 3
data tables different types of data? Or do they all contain the same type of
data, and all you want to do is treat them as one long table for the
purposes of the merge?

On a general point, if I were beginning to reach the limits of Excel, I'd be
thinking about changing the way I stored my data altogether.

Peter Jamieson