I need an Excel expert

I basically need someone to help me figure out how to automate email reminders and emails triggered by prescribed dates. The tricky thing is I cannot use the Internet as I am using my organisation's intranet though the Outlook platform is linked to my work laptop.