Controlling MS Outlook via Excel & VBA

Hello forum

I'd like to control MS Outlook via Excel & VBA.

I've been asked to help an animal welfare association with a way to automate emails to their members.

When the membership of each member is about to run out they want an automated emailnotification to be sent to the specific member (each member may have different dates for their membership expiration date)

The list of members can be controlled via Excel and when members have paid it can be 'checked' in the excelsheet

Is this possible?