I have a standardized memo in Word that needs frequent updating with figures and text contained in an Excel workbook (data source). Is there any way to link to Excel from fields in the Word doc so that the Excel data will be automatically be inserted into the various places (data target fields) in the Word doc? This would be similar to linking data from one Excel workbook to another, which is done simply by linking from an Excel target cell to a cell in the source workbook.
I thought about MailMerge in Word, but I don't think that will work in this case, although I may be wrong about that.
I know this can be done with VBA automation in Excel that re-creates the Word document each time, but I would like to avoid using VBA.
Thank for any help.