We have to know how to make a single click to run macro to send all the mailings. Please refer to the video attachment.
Check this video. With single button how we can send multiple emails individually to respective users.
The problem is we don't have the excel file or source. Please see the video and help us to find the result.
The video lenght is about 2 min only.
https://drive.google.com/file/d/1MFjND3YnOmlkgYTyQEsQ7l5vsxRNxPnA/view?usp=sharing