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 offline 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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr 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 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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 AM.


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