VBA To Send Work Anniversary Email based on work anniversary due date coloumn

  • Dear Experts,


    I humbly request a help from you all related to the following condition --:


    1.) we need to check the COLOUMN WorkAnniversaryDueDate with Today() and if the Work Anniversary is today then an email is to be sent out via Outlook.


    and once first email has been sent then the check has to be repeated for all the values in the Coloumn


    i have attached the sample excel file as well


    Kindly help as i have no idea how to code a VBA or macro


    Thanks and Regards,

    Neeraj SehgalNew Microsoft Excel Worksheet (6).xlsx

  • Try this. I haven't got OutLook set up on this computer so I cannot test.

  • See next code and file attached.

    Adjust sheet Email Template to your needs


  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

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