cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

VBA

resham1985
Microsoft

‎Jul 23 2021 04:44 AM

‎Jul 23 2021 04:44 AM

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 rajesh@123.com vijay@123.com           Case ID Ticket Number   rajesh@123.com vijay@123.com
234556677 2 Sures@123.com Raj@123.com           Status 1 or 2     Sures@123.com Raj@123.com
234556679 1 Vij@123.com Sur@123.com           Email  Email Id     Vij@123.com Sur@123.com
123456789 2 Kav@123.com sun@123.com           Manager ID Manager email ID   Kav@123.com sun@123.com
23342445661 1 Rao@123.com Vin@123.com           Status 1 2 hrs popup   Rao@123.com Vin@123.com
                    Status 2 6 hrs popup      
Labels:
Preview file
11 KB
766 Views
0 Likes
2 Replies
Reply
2 Replies
Jan Karel Pieterse

‎Jul 26 2021 08:50 AM

‎Jul 26 2021 08:50 AM

Re: VBA

What have you tried so far? For sending email from Excel, see: https://rondebruin.nl/win/section1.htm
0 Likes
Reply
resham1985

‎Aug 05 2021 09:44 AM

‎Aug 05 2021 09:44 AM

Re: VBA

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.

0 Likes
Reply