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.
|