Warm greetings

I am an HR, and I would like to create a Marco that can help me to send e-mail to named mutiple receipents based on my report. As I am entry-level learner of VBA, it would be highly appreciated if you could explain the details. Thank you in advance!

For example:
1. Select 'No.' as 1
2. You can see there are 4 LM's e-mail addresses
3. Send e-mail to those 4 receipents with the content '1 will be left the company soon.'
4. Keep going on doing the same steps as 1-3 for 2, 3... till the end number

No. LM's e-mail
1 a@hotmail.com
1 b@hotmail.com
1 c@hotmail.com
1 d@hotmail.com
2 e@outlook.com
2 f@outlook.com
3 a@hotmail.com
3 b@hotmail.com
3 f@outlook.com
3 d@hotmail.com
3 g@outlook.com
3 e@outlook.com
...