Dear Expert,
I need the VBA macro to run important job on my desk. I will give the details in writing and i need support in providng in macro have it succesfull.
.
First Job of the macro should be:
In my excel i have the sheet name called
DataSet
EmailAddress
TimeSet
Data Set carries the details with EMP NO and other details for various dates. This sheet may carry the data approx 300 rows.
Moreover, I will be asking to provide Less Hours (or) More hours on the column (I) based on the time set available in Timeset sheet by calculating with Column E.
(Refer sample on Column I)
Email Address carries the related email address of each employee number in particular sheet
Time set : This is the time set where this sheet gets updated one time to update the time or change the time when required.
Second Job of the macro to be:
On the run of macro on DataSet sheet, each staff data to consolidate with date ascending order and outlook email to be sent by copy pasting the respective staff data in the body as table. Related email address to be picked from EmailAddress sheet in connection with emp no:
subject of the email to be as : Emp no: xxxx - Capacity email for more and less hours.
Body: Dear Emp Name: Please review the sheet and resend data as you provided with More and less hours.
Thanks
I need the VBA macro to run important job on my desk. I will give the details in writing and i need support in providng in macro have it succesfull.
.
First Job of the macro should be:
In my excel i have the sheet name called
DataSet
EmailAddress
TimeSet
Data Set carries the details with EMP NO and other details for various dates. This sheet may carry the data approx 300 rows.
Moreover, I will be asking to provide Less Hours (or) More hours on the column (I) based on the time set available in Timeset sheet by calculating with Column E.
(Refer sample on Column I)
Email Address carries the related email address of each employee number in particular sheet
Time set : This is the time set where this sheet gets updated one time to update the time or change the time when required.
Second Job of the macro to be:
On the run of macro on DataSet sheet, each staff data to consolidate with date ascending order and outlook email to be sent by copy pasting the respective staff data in the body as table. Related email address to be picked from EmailAddress sheet in connection with emp no:
subject of the email to be as : Emp no: xxxx - Capacity email for more and less hours.
Body: Dear Emp Name: Please review the sheet and resend data as you provided with More and less hours.
Thanks