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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!