Forum Discussion
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.
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.
| Case ID | Status | Email ID | Manager ID | Condition | Email ID | Manager ID | |||||||||
| 123456789 | 1 | mailto:rajesh@123.com | mailto:vijay@123.com | Case ID | Ticket Number | mailto:rajesh@123.com | mailto:vijay@123.com | ||||||||
| 234556677 | 2 | mailto:Sures@123.com | mailto:Raj@123.com | Status | 1 or 2 | mailto:Sures@123.com | mailto:Raj@123.com | ||||||||
| 234556679 | 1 | mailto:Vij@123.com | mailto:Sur@123.com | Email Id | mailto:Vij@123.com | mailto:Sur@123.com | |||||||||
| 123456789 | 2 | mailto:Kav@123.com | mailto:sun@123.com | Manager ID | Manager email ID | mailto:Kav@123.com | mailto:sun@123.com | ||||||||
| 23342445661 | 1 | mailto:Rao@123.com | mailto:Vin@123.com | Status 1 | 2 hrs popup | mailto:Rao@123.com | mailto:Vin@123.com | ||||||||
| Status 2 | 6 hrs popup | ||||||||||||||
2 Replies
- What have you tried so far? For sending email from Excel, see: https://rondebruin.nl/win/section1.htm
- If 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.
