I have written several macros in VBA / EXCEL but want to access a WORD (template / master) then replace various fields from my VBA EXCEL application database.
Example replace my_address_line1 (in the word document, with the actual address line from my text database accessed from VBA / Excel
Just not sure if I can do what I want to achieve!
When the WORD document is 'edited' then I wish to save and either Print or Email. I don't want to save macros into the final word document id sending by email (I guess that would be poor practice).
There doesn't seem to be an option to save a file in word which is macro enabled or disabled.
Just trying to get some pointers before I head off in the complete wrong direction!