01-10-2020, 02:46 PM
|
|
Administrator
|
|
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
|
|
Since you're drawing data from different worksheets, you'll need to use a DATABASE field. An outline of this approach can be found at:
Mail Merge - To a Word Table on a Single Page - Microsoft Community
For some working examples, see:
Mail Merge: Using One Excel File with Multiple Sheets
Merge excel list into Word Receipt
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|