Thread: Mail merge table from Excel to Word
View Single Post
 
Old 03-05-2014, 05:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
The simplest way to do this is to copy & paste the Excel table into Word where you want it to appear. No mailmerge required. If you paste the data using the Paste Special>Paste Link option and the data source uses a named range, the document will update to reflect any changes to that named range.

Adding body content before & after the merged records, but not between them, requires some complex field coding.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote