Thread: [Solved] Trying to make several lists in Word, from data in Excel.
View Single Post
 
Old 04-20-2014, 03:33 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
I'm not sure this is a job for mailmerge. If the data are always at the same locations in Excel, you may be able to get the desired results by copying those cells and pasting them into Word using Paste Special with the 'paste link' option and the format of your choice. That way, whenever the Excel data are updated, the Word data too will update. This could used in templates and/or static documents. The only caveat is that you'll need to break the links if you create documents where it's important that the data remain static, so as to reflect the state of the data at a particular time.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote