Ray1358
03-09-2016, 11:29 AM
Dear Experts,
Could anyone please help...?
I need to solve this issue urgently.
<Background>
I have 10 guys reporting to me.
Every Monday by noon, they must send email to me.
Problem is that some of them do not send it on time.
I want to send automatic reminder email if he did not make it on time.
<Environment>
Outlook 2010
Exchange Server
<Possible solution>
1. Create a folder for each employee
2. Using Rule, email is automatically stored in the corresponding folder
3. Write a code which will create new email item if the folder.item =0
<Problem with this solution>
-Too many folders
-Code may become long
*************************
My question is, how would VBA experts would approach this problem?
Any suggestion/opinion will be greatly appreciated.
Could anyone please help...?
I need to solve this issue urgently.
<Background>
I have 10 guys reporting to me.
Every Monday by noon, they must send email to me.
Problem is that some of them do not send it on time.
I want to send automatic reminder email if he did not make it on time.
<Environment>
Outlook 2010
Exchange Server
<Possible solution>
1. Create a folder for each employee
2. Using Rule, email is automatically stored in the corresponding folder
3. Write a code which will create new email item if the folder.item =0
<Problem with this solution>
-Too many folders
-Code may become long
*************************
My question is, how would VBA experts would approach this problem?
Any suggestion/opinion will be greatly appreciated.