none
Email notification for due date on excel RRS feed

  • Question

  • Hi All

    I'm fairly new to using VBA, Macros and Modules.

    I'm looking to create a document in excel where I receive an email notifications a document has passed it's due date for review. The review due date would be 365 days after the 'Last reviewed Date'. I'm struggling to build the macro to allow me to do this. the document will have the following headers for a list.

    Department       Document Name    Version No.        Last Review Date          Document owners email

    Can anyone help me out?

    thanks,

    Steven

    Friday, September 4, 2015 12:39 PM

All replies

  • Hi Steven,

    >> I'm looking to create a document in excel where I receive an email notifications a document has passed it's due date for review.

    I am not sure what you mean with “email notification”. Based on your description, it seems that you want to create a table in a sheet, and add rows to the table. If so, I think you could ListObjects.Add to create a table, and then use ListRows.Add to add a new row, then you could set the value of the cell.

    # ListObjects.Add Method (Excel)
    https://msdn.microsoft.com/EN-US/library/office/ff823155.aspx
    # ListRows.Add Method (Excel)
    https://msdn.microsoft.com/EN-US/library/office/ff196248.aspx

    For a general suggestion, I think you could manually create a sheet with recording, then check the generated code in vba, and then modify it as your own requirement.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, September 7, 2015 5:20 AM