Forum Discussion

TRussell116's avatar
TRussell116
Copper Contributor
Jun 22, 2022

Excel VBA Code: send email and include date from spreadsheet

Hello,

I am trying to create a VBA code for an excel spreadsheet that will send an email and include data from specific cells to alert our team when a new employee has a confirmed start date. For context, our HR department has a spreadsheet that they will enter confirmed start dates when ready so that our IT team can begin setting up their logins, equipment, etc. I want to create an email alert to our team that will let us know when they have a confirmed start date. Below are screenshots of the worksheet and the code I have so far.

 

1. I want to have an email come in that includes the employees name as well as the start date that was entered.

 

2. Here is the code I have so far, but need help with the code to capture the employee name in column A and the start date in column AA.

 

Any help is appreciated! 

 

 

 

No RepliesBe the first to reply

Resources