OK - So this is a shameless plug for Nitro-BOM ...
BUT..... There is a nice example within this video regarding an Excel Macro to automatically transfer Excel Data (Assembly Number, Cost Summary and BOM Tables) to Microsoft Word Document and save off a new version --- e.g. Customer Quotation based on CAD Assembly Data and Cost Summaries.
https://youtu.be/cFhbQzxwhkE
