Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2020, 06:05 AM
collirde collirde is offline Mail merge from excel Windows 10 Mail merge from excel Office 2010
Novice
Mail merge from excel
 
Join Date: Nov 2020
Posts: 2
collirde is on a distinguished road
Default Mail merge from excel

I have a sheet with the following data in it (length could vary depending on the day), but the columns should remain the same.




pic1


I want to be able to merge the data into a word document, where the data is merged and a new document is produced for each "Sub's Name". this list will then tell the substitute teacher which class they will be substituting for during each period of the day.

pic2



If anyone can help me figure out how to do this so each substitute will have a separate print out with all the general info on it I would be very appreciative. If it could be handled completely in Excel that would be the best possible situation for the person doing this, I could create a button to run a macro to do this and it would create the files for printing.
Attached Images
File Type: png pic1.PNG (24.3 KB, 7 views)
File Type: png pic2.png (93.3 KB, 7 views)
Reply With Quote
  #2  
Old 11-16-2020, 06:47 AM
Charles Kenyon Charles Kenyon is offline Mail merge from excel Windows 10 Mail merge from excel Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 7,088
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

The basic mechanics of a mail merge using data in Excel are explained here:
Mail merge using an Excel spreadsheet - Word
Reply With Quote
  #3  
Old 11-16-2020, 07:47 AM
collirde collirde is offline Mail merge from excel Windows 10 Mail merge from excel Office 2010
Novice
Mail merge from excel
 
Join Date: Nov 2020
Posts: 2
collirde is on a distinguished road
Default

I apologize for the pics not showing up to begin with, does the addition of the pics help explain my request? Thanks for taking the time to look.
Reply With Quote
  #4  
Old 11-16-2020, 01:14 PM
macropod's Avatar
macropod macropod is offline Mail merge from excel Windows 10 Mail merge from excel Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,702
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

One option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at:
Many to one email merge using tables - Microsoft Community
Conversely, if you're using a relational database or, Excel workbook with a separate table with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. 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:
https://www.msofficeforums.com/mail-...-multiple.html
https://www.msofficeforums.com/mail-...tml#post151706
Merge excel list into Word Receipt
(the second of these uses a macro to apply some additional formatting).

The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: https://www.msofficeforums.com/mail-...html#post67097
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
Mail merge from excel Using Mail Merge with Excel DeaninGa Mail Merge 1 08-20-2015 09:41 PM
Mail merge from excel Can't merge mail from Excel Mahmed1 Mail Merge 23 04-06-2014 07:23 AM
Excel Mail merge Joren Word 0 07-09-2013 07:38 AM
Mail merge from excel Mail Merge from Excel Kieroncsmith Mail Merge 2 02-16-2012 10:35 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:59 PM.


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