I have an idea for a productivity aid which involves embedding Word (2010) Documents into Excel (2010), then behind a macro button the macro chooses the relevant Word Template and proceeds to populate it with data.
Basically I want to drive Word’s “mail merge” from Excel so that the correct Word templates are retained in a single Excel workbook for distribution.
Is this possible?
Can someone point me to (or provide) a sample macro that will grab an embedded document, then start a “mail merge” using that document as the format template.
Conceptual only Excel workbook attached. Assuming what I’m after is possible I’m not after a fully developed macro, just a stub to show how I would get started.
ps: I’ve not used VBA for a long while, but it’ll come back to me I’m assuming :)