|
|
|
|
#1
11-09-2018, 04:35 AM
|
|||
|
|||
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
11-11-2018, 01:27 AM
|
||||
|
||||
|
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 |
|
|
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 |
Mac OS X 
Office 2016 for Mac
Hybrid Mode