View Single Post
 
Old 01-04-2019, 04:30 AM
everwisher everwisher is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Jan 2019
Posts: 1
everwisher is on a distinguished road
Default 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.
Reply With Quote