anuragit13
New Member
- Joined
- Mar 22, 2018
- Messages
- 17
Hi,
I need to create a macro so that on the basis of the cell values the mail template must be created automatically and it should send mail automatically to the Distribution list.
I have below data is excel:
<tbody>
</tbody>
Below is What I want is in mail:
Subject line: Teacher Info Share: Case Summary
Mail Body:
Dear
Below is the case summary of the recently concluded case on Dissatisfied with Management. The summary includes highlight/focus areas for the teachers.
<tbody>
</tbody>
Case Summary: Bus not came on time
Conclusion of the Case Informed to driver
Action Taken Done
History of pervious cases (If Any): NA
Was Teacher support required: Yes
Did the teacher provide adequate support: No
What was lacking from the teacher: Process Gaps
Elaborate the focus areas for the teacher: Teacher did not follow up properly
Elaborate highlights of the teacher:
Regards,
XYZ
SSM School
I want mail to sent to DL : In above mail format Branch value defines the DL. Suppose LKO has two mail ids i.e xyz@ss.com, abc@ss.com and VNS has two mail id i.e. aaa@ss.com, bbb@ss.com. I have another sheet in tab 2 which has list of email ids for LKO and VNS. What i want is that:
1. This macro should create a mail template first.
2. On the basis of branch values in sheet 2 it should send mails
It would be great if anyone can help in this.
Thanks in Advance,
Anurag
I need to create a macro so that on the basis of the cell values the mail template must be created automatically and it should send mail automatically to the Distribution list.
I have below data is excel:
<tbody> </tbody> |
<tbody>
</tbody>
Below is What I want is in mail:
Subject line: Teacher Info Share: Case Summary
Mail Body:
Dear
Below is the case summary of the recently concluded case on Dissatisfied with Management. The summary includes highlight/focus areas for the teachers.
Case | |
Complaint Type | |
Student Name | Level 8 |
Roll No | |
Level | |
Branch | HBRA |
Issue Date | 16 January 2017 |
Close Date | 6 February 2017 |
Past Issue | No |
<tbody>
</tbody>
Case Summary: Bus not came on time
Conclusion of the Case Informed to driver
Action Taken Done
History of pervious cases (If Any): NA
Was Teacher support required: Yes
Did the teacher provide adequate support: No
What was lacking from the teacher: Process Gaps
Elaborate the focus areas for the teacher: Teacher did not follow up properly
Elaborate highlights of the teacher:
Regards,
XYZ
SSM School
I want mail to sent to DL : In above mail format Branch value defines the DL. Suppose LKO has two mail ids i.e xyz@ss.com, abc@ss.com and VNS has two mail id i.e. aaa@ss.com, bbb@ss.com. I have another sheet in tab 2 which has list of email ids for LKO and VNS. What i want is that:
1. This macro should create a mail template first.
2. On the basis of branch values in sheet 2 it should send mails
It would be great if anyone can help in this.
Thanks in Advance,
Anurag