#1
|
|||
|
|||
How to avoid duplicate table headers while mail merge records?
Hi, there!
I'm having troubles when I tried to mail merge | directory some records from an Excel spreadsheet into a formatted table in Word. I did get a continuous table after merging but the dilemma was that the first row where the table headers are got duplicated for each record merged in. If I'm not making myself clear, here's an example: Header 1 Header 2 Header 3 <<Record 1-1>> <<Record 1-2>> <<Record 1-3>> Header 1 Header 2 Header 3 <<Record 2-1>> <<Record 2-2>> <<Record 2-3>> These repeated headers have cut the table into illegible piece, which should be avoided apparently. Is there a way of doing this? Btw, I definitely don't want to do the formatting work in Excel because actions like cell merge/split can easily make things even worse. |
#2
|
||||
|
||||
You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...-tutorial.html The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Cross-posted at: https://answers.microsoft.com/en-us/...8-1222500f08f2
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
dilemma, mailmerge directory, many to one |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge records out of order | ARS | Mail Merge | 3 | 10-18-2017 02:13 PM |
Many records to One Mail Merge Document | CONFUSEDOPSMANAGER | Mail Merge | 1 | 05-08-2017 02:56 PM |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
Mail merge--skipping records | 623bookends | Mail Merge | 2 | 01-12-2014 06:02 AM |
Mail Merge - Many Records for Each Addressee | awalker1970 | Mail Merge | 1 | 12-31-2010 11:52 AM |