Mail merge

[Esero]

I'm new to vba. I have a word doc with Excel merge field controls which I have Im using pull/merge selected data from Excel manually . I would like to have a button on excel sheet which on click populates or mail merge the word doc with data from Excel sheet based on the selected merge fields in word doc. The Excel sheet is named class4 and word doc is named report4 both are on disk D folder named Analysis . If possible, the number of reports to be produced in mail merge should depend on the number of names which appear Column B ( Student Name) Starting from row 2 .
Thank you in advance

 

[Macropod]

For some code to get you started, see for example: https://www.mrexcel.com/forum/gener...e-excel-2010-vba-post4872807.html#post4872807