Automatic leave tracker update send in mail

[Sathish G]

Hi friends,


Am not that much good in VBA so kindly help me.

I need macro for below given employee leave tracker.

Like any if one of the below employee run the macro from system then its has to take as leave and the same time automated mail have to generate like below given examples.

If possible who is taking leave on which data that can be update on current columns.

Leave content is like ( Am on leave today with date/month/year)

Sl.NO

Emp Name

Emp ID

Team

Group

28-Aug

29-Aug

30-Aug

31-Aug

01-Sep

02-Sep

03-Sep

04-Sep

1

XXXXX1

12345

A

AAA

2

YYYY1

54321

B

BBB

3

XXXXX2

67890

C

CCC

4

YYYY2

23451

D

DDD

5

XXXXX3

76543

E

EEE

6

YYYY3

98765

F

FFF

<colgroup><col width="64" style="width:48pt"> <col width="146" style="width:110pt"> <col width="73" style="width:55pt"> <col width="64" style="width:48pt"> <col width="46" style="width:35pt"> <col width="64" style="width:48pt" span="2"> <col width="144" style="width:108pt"> <col width="133" style="width:100pt"> <col width="64" style="width:48pt" span="4"> </colgroup><tbody>
</tbody>

example mail id: senders & receivers

from mail id	xxxxxsend@.com
To mail id	xxxxxreceive@.com, xxxxxreceive2@.com

<colgroup><col width="144" style="width:108pt"> <col width="133" style="width:100pt"> </colgroup><tbody>
</tbody>

Manager xxxxxmanger@.com


Thanks is advance.

I know its big work but someone please support.