Mailmerge can only use a single data source. That said, you could use a mailmerge in conjunction with a DATABASE field to consolidate data from different worksheets. See: https://www.msofficeforums.com/mail-...populated.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|