How to Use Mail Merge with conditions to show some features
Hi,
I have an excel sheet that contains records of students names, classes & their chosen subjects out of the subjects taught in the school. So, some subjects are taken by all the students and other differ for each student.
I need to output a report for each student that contains:
1- Student's name & class
2- Subjects chosen by this particular student. No other subjects
3- In addition, I need to show in the report a table for each subject. The tables will be filled with marks manually.
I used the mail merge in Ms Word to output a report for each student containing only part 1. I need a help to complete the report with the other two parts.
Last edited by raiya; 10-14-2012 at 10:45 PM.
|