Hi All!
This is my first post and hoping to get some help in developing a macro that will automatically send an email to the relevant email address (column J) when the Review date (column H) is within 7 days.
The body of the email should be;
Subject: Document due for review
"To Name (Column I),
Document (Column B & Column D) is now due for review.
Kind Regards"
Also, the script should put an indicator that the email has been sent, i.e. sent date.
I'd really appreciate any help.
TIA!
This site tells you everything you could possibly want to know about Excel/Outlook automation using VBA. You'll need a loop to process each row and check the date. If it is due, build the body of the email.
Sorry, missed the link: https://www.rondebruin.nl/
Last edited by TMS; 08-11-2020 at 03:32 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@Snow, I took the liberty of rewriting the code in your sample so that when opened, any row within 7 days will have an email generated. Let us know if you have questions.
In the workbook module:
In a module I populated the following code:
Please Login or Register to view this content.
I left the code that was in the file untouched.Please Login or Register to view this content.
Last edited by maniacb; 08-11-2020 at 01:41 PM. Reason: Corrections to response
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks