I have an excel sheet which contains Supplier certs issue date and date of expiry of a particular cert. I would like to send an email to user when the date of expiry is met. Can you please help me with this. I have searched quite a few solutions but nothing has helped me. I have very little knowledge or no knowledge of coding in VB. I want to send the email 30 days before the cert expire. i have attached the file.
Hi,
there are plenty of examples....try this one and see if it heps you.
I assumed that your reminder expire date was in column N, change
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks