#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
The basic mechanics of a mail merge using data in Excel are explained here:
Mail merge using an Excel spreadsheet - Word |
#3
|
|||
|
|||
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.
|
#4
|
||||
|
||||
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] |
|
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 |
Using Mail Merge with Excel | DeaninGa | Mail Merge | 1 | 08-20-2015 09:41 PM |
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 | Kieroncsmith | Mail Merge | 2 | 02-16-2012 10:35 PM |