|
|
#2
06-28-2011, 06:27 PM
|
||||
|
||||
Hi Paul,
A mailmerge can only use one source file - and the data all need to have the same arrangement. That seems to rule out that approach for what you've described. Any other form of automation would also require a consistent data layout. Beyond that, you can copy & paste from Excel to Word, using the 'paste link' option to link the document to the Excel workbook. that way, any changes in the workbook will update the document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Urgent help regarding automation.
|
aligahk06 | Excel | 1 | 01-14-2010 01:55 PM |
| Table of contents automation through VB 6.0 | Developer | Word | 0 | 06-09-2009 06:30 AM |
| What is Application Automation and How can I use it in VBA | KramerJ | Excel | 0 | 03-30-2009 12:59 PM |
| COM Automation Errors | ivanm | Word | 0 | 03-23-2009 07:02 PM |
|
Excel to Word
|
retrospect1984 | Excel | 1 | 02-18-2009 06:41 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode