How can I send to the list of e-mail recipient with button provide reminder attachment, such as a series of reminder from expired date?

[Izaa]

Hello, I am beginner with VBA in Excel. I've just started to use VBA just month ago. Do me a favor?

How can I send to the list of e-mail recipients with button provide reminder attachment, such as a series of reminder, so I just need to click one button following the automated reminder set. Then, should it possible to make it automatic updated calculation for time elapsed after the reminder set? For example (referring the current today's date: 9/4/2021)

NO.	SUPPLIER NAME	E-MAIL RECIPIENT	EXPIRED DATE	REMINDER
1	A	x	9/12/2021	not sent yet until the due date
2	B	xx	9/3/2021	1st reminder sent
3	C	xxx	9/2/2021	2nd reminder sent
4	D	xxxx	9/1/2020	3rd reminder sent
5	E	xxxxx	9/12/2020	final reminder sent

So, basically their e-mail will containing reminder content with up to 4 times reminders. Basically, what I planned were such as following date:
Example: date from today (9/4/2021)
-elapsed 1st month will be the 1st reminder set to them (1 email received)
-elapsed 2nd month will be the 2nd reminder set to them (2 email received)
-elapsed 3rd month will be the 3rd reminder set to them (3 email received)
-finally, 4rd month will be the final reminder set to them (limit to 4 times email received)

Is it possible to do this? Help me. I would appreciate for your help. Thank you!

Izaa

 

[Logit]

This resource can get you started : Mail from Excel with Outlook (VBA)

There are a number of existing threads on this and other forums that will assist as well. You can search for : email timed reminder
or a similar phrase.