HI
I am new to this section and is my first query.
I have workbook with 16 worksheets. I have noted discrepancies observed for each of the supervision of his team in each of the worksheet with email address of the supervision in A1 and the email of the Manager in A2.
I have also input the Message in A4.
Request a vba to send the noted discrepancy range of each sheet pasted in the email body and send it to the respective supervisor and Copy to the Manager for their actions.
Example:
A B C D E F
1 abc@gmail.com
2 xyz@gmail.com
3
4 Please note the descripency
5
6 Empid Emp Name Role1 Role2 Desc Action to be taken
7
8
9
10
11
12
13
14
15
Please help me
Gary
I am new to this section and is my first query.
I have workbook with 16 worksheets. I have noted discrepancies observed for each of the supervision of his team in each of the worksheet with email address of the supervision in A1 and the email of the Manager in A2.
I have also input the Message in A4.
Request a vba to send the noted discrepancy range of each sheet pasted in the email body and send it to the respective supervisor and Copy to the Manager for their actions.
Example:
A B C D E F
1 abc@gmail.com
2 xyz@gmail.com
3
4 Please note the descripency
5
6 Empid Emp Name Role1 Role2 Desc Action to be taken
7
8
9
10
11
12
13
14
15
Please help me
Gary