#1
|
|||
|
|||
Mail Merge Student Transcript - Multiple Years from multiple sheets
How do I merge data - students grades into a school transcript with data from multiple sheets. Data source is sheets for each school year. Merged documents to have each students' grades from, say, Grade 1 - Grade 12.
Thank you. |
#2
|
||||
|
||||
A mailmerge can only interrogate a single data source - in this case, a single worksheet. However, depending on your workbook layout, you may be able to combine that with a series of DATABASE fields that each query a different worksheet. For a demonstration, see: https://www.msofficeforums.com/mail-...-multiple.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
multiple sheets |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge: Using One Excel File with Multiple Sheets | Townshend | Mail Merge | 19 | 06-25-2021 12:39 AM |
Search through multiple sheets with multiple textboxes | andxie | Excel Programming | 0 | 07-09-2018 07:04 PM |
Mail Merge to multiple employees in multiple locations as PDF by location | GFiz | Mail Merge | 1 | 05-13-2017 08:01 PM |
Multiple mail merge | PKAYHORM | Mail Merge | 1 | 09-29-2013 07:45 PM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |