raushan316
New Member
- Joined
- Sep 26, 2019
- Messages
- 1
I have to prepare letter for students of different colleges. For each college, there should be one letter with name of all the students & their details in tabular format.
The students data is in excel is as below:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="bgcolor: #FFFF00"]College Name[/TD]
[TD="bgcolor: #FFFF00"]Student Name[/TD]
[TD="bgcolor: #FFFF00"]Fathers Name[/TD]
[TD="bgcolor: #FFFF00"]Address[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD]PQR[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]ASJ[/TD]
[TD]KDAJD[/TD]
[TD]2, XYZ Street[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]SDA[/TD]
[TD]DAD[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]ADA[/TD]
[TD]DADD[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]RAR[/TD]
[TD]EWQD[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]AWRWQR[/TD]
[TD]WRQR[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
</tbody>[/TABLE]
What I want is, separate letter for different colleges i.e. in this case, 2 letters should be printed : one letter having details of all students in ABC College, and another letter having details of PQR College.
The number of students in each college is not fixed, so the table should be dynamic in nature.
The students data is in excel is as below:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD="bgcolor: #FFFF00"]College Name[/TD]
[TD="bgcolor: #FFFF00"]Student Name[/TD]
[TD="bgcolor: #FFFF00"]Fathers Name[/TD]
[TD="bgcolor: #FFFF00"]Address[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]XYZ[/TD]
[TD]PQR[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]ASJ[/TD]
[TD]KDAJD[/TD]
[TD]2, XYZ Street[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]SDA[/TD]
[TD]DAD[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]ADA[/TD]
[TD]DADD[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]RAR[/TD]
[TD]EWQD[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
[TR]
[TD]PQR[/TD]
[TD]AWRWQR[/TD]
[TD]WRQR[/TD]
[TD]1, XYZ Street[/TD]
[/TR]
</tbody>[/TABLE]
What I want is, separate letter for different colleges i.e. in this case, 2 letters should be printed : one letter having details of all students in ABC College, and another letter having details of PQR College.
The number of students in each college is not fixed, so the table should be dynamic in nature.