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)
[TABLE="width: 1054"]
<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>[TR]
[TD="class: xl16, width: 64"]Sl.NO[/TD]
[TD="class: xl16, width: 146"]Emp Name[/TD]
[TD="class: xl16, width: 73"]Emp ID[/TD]
[TD="class: xl16, width: 64"]Team[/TD]
[TD="class: xl16, width: 46"]Group[/TD]
[TD="class: xl17, width: 64"]28-Aug[/TD]
[TD="class: xl17, width: 64"]29-Aug[/TD]
[TD="class: xl17, width: 144"]30-Aug[/TD]
[TD="class: xl17, width: 133"]31-Aug[/TD]
[TD="class: xl17, width: 64"]01-Sep[/TD]
[TD="class: xl17, width: 64"]02-Sep[/TD]
[TD="class: xl17, width: 64"]03-Sep[/TD]
[TD="class: xl17, width: 64"][/TD]
[TD="class: xl17, width: 64"][/TD]
[TD="class: xl17, width: 64"]04-Sep[/TD]
[/TR]
[TR]
[TD="class: xl17"]1[/TD]
[TD="class: xl19"]XXXXX1[/TD]
[TD="class: xl19"]12345[/TD]
[TD="class: xl19"]A[/TD]
[TD="class: xl19"]AAA[/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[/TR]
[TR]
[TD="class: xl17"]2[/TD]
[TD="class: xl19"]YYYY1[/TD]
[TD="class: xl19"]54321[/TD]
[TD="class: xl19"]B[/TD]
[TD="class: xl19"]BBB[/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[/TR]
[TR]
[TD="class: xl17"]3[/TD]
[TD="class: xl19"]XXXXX2[/TD]
[TD="class: xl19"]67890[/TD]
[TD="class: xl19"]C[/TD]
[TD="class: xl19"]CCC[/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[/TR]
[TR]
[TD="class: xl17"]4[/TD]
[TD="class: xl19"]YYYY2[/TD]
[TD="class: xl19"]23451[/TD]
[TD="class: xl19"]D[/TD]
[TD="class: xl19"]DDD[/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[/TR]
[TR]
[TD="class: xl17"]5[/TD]
[TD="class: xl19"]XXXXX3[/TD]
[TD="class: xl19"]76543[/TD]
[TD="class: xl19"]E[/TD]
[TD="class: xl19"]EEE[/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[/TR]
[TR]
[TD="class: xl17"]6[/TD]
[TD="class: xl19"]YYYY3[/TD]
[TD="class: xl19"]98765[/TD]
[TD="class: xl19"]F[/TD]
[TD="class: xl22"]FFF[/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[TD="class: xl21"][/TD]
[/TR]
</tbody>[/TABLE]

example mail id: senders & receivers

[TABLE="width: 277"]
<colgroup><col width="144" style="width:108pt"> <col width="133" style="width:100pt"> </colgroup><tbody>[TR]
[TD="width: 144"] from mail id [/TD]
[TD="class: xl72, width: 133"]xxxxxsend@.com[/TD]
[/TR]
[TR]
[TD]To mail id[/TD]
[TD="class: xl72"]xxxxxreceive@.com, xxxxxreceive2@.com[/TD]
[/TR]
</tbody>[/TABLE]
Manager xxxxxmanger@.com


Thanks is advance.

I know its big work but someone please support.