That's not going to happen without a lot of effort. A mailmerge can only work with a single data source - in this case a single worksheet. Besides which, it's not apparent what the purpose is behind having different worksheet names in column C when both sheets appear to be in the same workbook.
What is the problem with a having different mailmerge main document for each data source?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|