[ms office - 2016] Word Excel automation

[tri_94]

Hi there

 

Looking for a way to mail-merge on new entry. So have a spreadsheet which when certain field is filled in it will then mail merge to generate a letter using a word template

 

I’ve used google forms to do this and it works perfectly but need an word excel method. Happy to look at vb or macros

 

Thanks