This is quite a useful link to do mail merging when you want to run macro for several records, for e.g., to import data using macros. Thanks to David Musgrave who explains step by step in the link below.
https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/
