Hi Eric,

You can't do that. In a mailmerge, all records must be from the one worksheet, and all fields for a given record must be on the same line. For your purposes, that means you'll need to have a worksheet that has the relevant data on the rows in question (eg via the use of formulae).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]