#1
|
|||
|
|||
Mail Merge Data with Multiple Excel Sheets
Hello seniors! I want to use mail merge data in word from Multiple Excel Sheets But there is no option to choose 2nd or 3rd sheet data. Can Anyone help me about this issue to resolve it that my data which have 8 sheets and I want to convert it with my requirements formate through mail merge fields. |
#2
|
||||
|
||||
Mailmerges only work with a single data source - in this case a single worksheet. Depending on your workbook structure and output requirements, however, a combination of meregefields and DATABASE fields may suffice. See, for example:
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).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge, multiple excel sheets |
Thread Tools | |
Display Modes | |
|
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 |
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file | sureshbvs | Word VBA | 1 | 03-12-2021 05:42 AM |
Mail Merge Student Transcript - Multiple Years from multiple sheets | aizah2018 | Mail Merge | 1 | 11-11-2018 01:27 AM |
Excel 2013 Pulling data from 1 table to multiple sheets | Justcallmeeesa | Excel | 2 | 04-14-2016 09:15 AM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |