Forum Discussion
resham1985
Jul 23, 2021Brass Contributor
VBA
I need VBA code and my requirement is
When employee enters the case ID, status and email ID then auto popup "reminder to do the followup" and email should be sent to the employee and the manager.
...
JKPieterse
Jul 26, 2021Silver Contributor
What have you tried so far? For sending email from Excel, see: https://rondebruin.nl/win/section1.htm
- resham1985Aug 05, 2021Brass ContributorIf you dont mind, can you please send me the VBA code for my requirement.
My requirement:
When employee enters the case ID, status and email ID then auto popup "reminder to do the followup" and email should be sent to the employee and the manager.
If the status is 1- popup message every 2 hours and Status 2- Popup every 6 hours
at the same time, email should be sent to email ID and Manager ID.
Please see the attached excel sheet in earlier message.