Dear All
Thanking you all for taking the time to read my post and helping in any way.
I need to copy rows from a spreadsheet where the date is equal to today.
For example:
Date Started Employee Name Probation End Date Success/Fail Email Notification 25/03/2018 Sue 23/06/2018 Success date email sent 26/03/2018 Lisa 24/06/2018 Success date email sent 25/04/2018 Tina 24/07/2018 Success date email sent 30/05/2018 Lenny 28/08/2018 Success date email sent
In column 3 I have added the formula =A2+90 - (90 is to work out date 3 months from Start of Employment date).
Then I need to add a command button with coding that will look at the date in column 3 and compare it with todays date.
If date in column 3 is equal to today - then that row(s) to be copied and pasted into a blank outlook 2013 email.
I am able to add body of email and recipient details but have no idea how to create a macro to work out which rows to paste.
I thank you all once again for reading this post and any help/advice you can provide me with.
Your faithfully
Sue
Bookmarks