i am looking for solution for, how to show the live status of how many records processed through a progress bar for a excel-word mail merge.
Eg. i am creating a mail merge with word template and excel data to make individual .pdf files and the vba should run from excel and the word template working on back ground as hidden
i need to know how many records processed though a progress bar on excel
is it possible?
all kind of suggestions and advices are highly appreciated