Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-07-2020, 05:17 AM
macropod's Avatar
macropod macropod is offline merge from excel to word Windows 7 64bit merge from excel to word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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

Well, in that case, it wouldn't be a mailmerge…

Beyond that, you can use:
• OLE to link your Word document to an Excel worksheet, such that when the data in Excel changes, Word is updated;
• a DATABASE field in Word to construct a table from data that conform to whatever rules you specify; or
• VBA to copy & paste a range from Excel into Word as a table.
No code is required for either of the first two methods.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
merge from excel to word Merge fields from Excel into word document Tonykiwi Word 5 10-11-2015 12:54 PM
merge from excel to word Merge From Excel With Table in Word - Next Record If Excel Column Same? misscrf Mail Merge 2 10-15-2014 11:51 PM
merge from excel to word Merge data from excel into word jonpackbosoxfan Excel 34 09-18-2013 08:38 AM
merge from excel to word Word Merge from Excel not in same order! Coreysan Mail Merge 3 12-11-2011 04:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft