Data merge from excel to word

[Jcol95]

Hey,

I am currently in the process of automating audits at work. Currently we are working off an interface in excel and writing the reports out manually in excel. What I am after doing is installing a button that can merge certain cells in to marked places in a word template.
For example:

Audit commenced on <<C5>>. The audit was undertaken by <<B2>>.

Is anyone able to assist with how I should go about this?

I am using office 2016.

 

[RedBeard]

Mail merge in Word should handle this?

 

[Macropod]

You could indeed use mailmerge, which you could automate with VBA or, if you're using VBA anyway, you could forego the mailmerge and simply populate bookmarks in the template directly. The latter is probably simpler to implement if the source row for the data varies.