Send e-mail to named mutiple receipents

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 [email protected]
1 [email protected]
1 [email protected]
1 [email protected]
2 [email protected]
2 [email protected]
3 [email protected]
3 [email protected]
3 [email protected]
3 [email protected]
3 [email protected]
3 [email protected]
...

Thank you for your reply.

Let me explain my question more detais, my key point is to know how to select the named recepients from my report as example. Could you please kindly advise me the VBA code?

.

Please Login or Register  to view this content.

Hello Grace Huang, Welcome to the forum.
Please go through the link given by Oeldere and it should help.

Best Regards/VKS

Thank you!

May i know if there is any way that i can send the e-mail to muitiple receipents instead of one receiver? i mean that i need to send the separation notification of No.1 to 4 LMs' e-mail accounts by one e-mail.

.
Download the attachment and run it.