![]() |
|
#3
|
||||
|
||||
|
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] |
| Tags |
| list, mailmerge |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Using Excel data to automatically make Word documents
|
Vincent | Mail Merge | 9 | 01-04-2021 03:05 PM |
Convert lists of text in Word to excel
|
Grosspsych | Excel | 5 | 02-06-2012 08:03 PM |
Drop-down lists in Excel
|
Maureen | Excel | 1 | 11-10-2011 08:11 AM |
| Is it possible to make Word link to the last record in Excel | stephen_pen | Word | 0 | 09-22-2011 11:00 PM |
XML List of lists in Excel or Calc
|
manofspider | Excel | 1 | 08-05-2011 09:03 AM |