more than one data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DSK_7 - 15 Apr 2005 15:13 GMT

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

Reply to this Message

Peter Jamieson - 15 Apr 2005 22:38 GMT

> 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

> Hi,
> Is it possible for mailmerge to use separate data sources (excel sheets)?
[quoted text clipped - 10 lines]
> Thanks,
> DSK_7

Reply to this Message

Rate this thread: