Thread: [Solved] merge from excel to word
View Single Post
 
Old 03-07-2020, 05:17 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,370
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