View Single Post
 
Old 10-14-2012, 01:12 AM
raiya raiya is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Oct 2012
Posts: 6
raiya is on a distinguished road
Default 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.
Attached Files
File Type: xlsx std2.xlsx (19.0 KB, 12 views)
File Type: docx followUp1.docx (26.8 KB, 15 views)

Last edited by raiya; 10-14-2012 at 10:45 PM.
Reply With Quote