Email Notifications from Excel

  • Hi,


    For 2021 I am hoping to set up an excel spreadsheet for our Accountancy practice to make current procedures slightly more efficient. Currently a working progress so apologies if several fairly simple questions are asked.


    My first question is... does Excel allow you to send email notifications? For example, if a VAT return was due for 07/08/2021 and the date was say 01/08/2021, could I get an email sent to the relevant person alerting them of this? :/


    With Kind Regards,


    James.

  • Thanks for your Thanks :)


    Should you face any obstacle, feel free to come back to the Forum ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • You need to set up a database sheet with details of clients and tasks and due dates.


    The code would need to be run daily and send any reminders based on the due date.


    It's not a difficult task, depends on your Excel skills.


    Which email application are you using, OutLook is the easiest to use with Excel.