I'm trying to find VBA to create a macro for initiating a Word doc mail merge.

from Excel I want it to open Word docs in a specified location, say S:/shared drive/Merge docs/anyname.docx, then access a sheet named Word_Letters in the current workbook to populate the mail merge

The workbook, however will be different every time. I need VBA references to the workbook and location to be dynamic, i.e. "activeworkbook" or "thisworkbook" and "activedirectory" or "currentdirectory". Please pardon my syntax as I don't really know VBA but I'm great at copying it.

I manage a master workbook that others copy and then rename for their own use. I want the VBA to work dynamically so that when they copy the workbook the assigned macro button(s) will use their named workbook and current directory to produce and save the mail-merged result.

If someone can help me get started I would be glad to share the workbook blank from which I'm working.

Thanks so much in advance.