Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2018, 04:35 AM
aizah2018 aizah2018 is offline Mail Merge Student Transcript - Multiple Years from multiple sheets Mac OS X Mail Merge Student Transcript - Multiple Years from multiple sheets Office 2016 for Mac
Novice
Mail Merge Student Transcript - Multiple Years from multiple sheets
 
Join Date: Nov 2018
Posts: 1
aizah2018 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-11-2018, 01:27 AM
macropod's Avatar
macropod macropod is online now Mail Merge Student Transcript - Multiple Years from multiple sheets Windows 7 64bit Mail Merge Student Transcript - Multiple Years from multiple sheets Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,899
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Tags
multiple sheets

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Student Transcript - Multiple Years from multiple sheets Mail Merge: Using One Excel File with Multiple Sheets Townshend Mail Merge 12 06-07-2019 04:35 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
Mail Merge Student Transcript - Multiple Years from multiple sheets Multiple mail merge PKAYHORM Mail Merge 1 09-29-2013 07:45 PM
Mail Merge Student Transcript - Multiple Years from multiple sheets How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM


All times are GMT -7. The time now is 08:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft