Hello VBA Coders,
Need your help to automate excel based email triggers. I have an Excel Worksheet that has certain Action Items listed against certain people and target date in different columns and status of those actions.
I want a VBA code that checks if Target date has expired on date of triggering Macro, if yes then it checks the status and selects only "open" actions. It then creates separate excel sheets of all open items based on name of person responsible (this excel will have complete rows pasted with headers). It will then trigger an automated email to the email id of person listed in the worksheet with attachment of Open items for that person and send the email.
Can someone please help me with this? I hope I have been elaborate in providing all required data
Let me thank you in advance
Need your help to automate excel based email triggers. I have an Excel Worksheet that has certain Action Items listed against certain people and target date in different columns and status of those actions.
I want a VBA code that checks if Target date has expired on date of triggering Macro, if yes then it checks the status and selects only "open" actions. It then creates separate excel sheets of all open items based on name of person responsible (this excel will have complete rows pasted with headers). It will then trigger an automated email to the email id of person listed in the worksheet with attachment of Open items for that person and send the email.
Can someone please help me with this? I hope I have been elaborate in providing all required data
Let me thank you in advance