Open Outlook Email Template and Send to Multiple Recipients

[Mackey00]

Good Morning All,

I am trying to create a macro that will open a template email, allow me to insert the individuals' names in the body, and send each email independently (not one large BCC bulk email). I have only found a macro that will send one email with all of the emails grouped together.

1. Create an Action Button that I can put in a range of rows to be emailed (eg. rows 1-20 or 21-30)
2. In Outlook 2016 Open one Template email and send to one individual (column A)
3. Place individuals' first (column B) and last (column C) names on the top of the body
4. Send and repeat to the next email address (column A)

Thank you in advance. This is a very difficult one for me to complete.

	A	B	C
1	Email	First Name	Last Name
2	aaa@aaaaa.com	A	A
3	bbb@bbbbb.com	B	B
4	ccc@ccccc.com	C	C

<tbody>
</tbody>