Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
677 views
in Computer by (62.1k points)
closed by

Write steps to create Student Annual Report using mail merge with spreadsheet?

1 Answer

+1 vote
by (58.7k points)
selected by
 
Best answer

Student Annual Report can be created using MS Word and MS Excel using following steps:

1. Prepare the annual report format in MS word. Mention student’s detail like admission no, roll no, name, father’s name, marks of each subject, overall result and percentage of marks of student.

2. On the other side, prepare a excel worksheet, in which student’s admission no, roll no, name, father’s name, subject-wise marks obtained in subjects Punjabi, English, Maths, Science, Social Studies and grades etc. are-entered.

3. Next calculate the percentage of marks of each student using a formula.

4. Now, click on Mailing Tab, and start mail merge. Then, choose Letter option which we already prepared.

5. Next Click on Select Recipients and select Use Existing List option. Choose excel sheet from Select Table dialog box and click OK.

6. Place the cursor where you want to insert the value of field from excel sheet. Now go to Insert Merge Field option in Write & Insert Fields group. A dropdown menu will be displayed having field names.

7. Select the field names one by one after placing the cursor in proper place in the student annual report. All fields will be displayed.

8. After inserting all the clicking Preview Results next and previous button, you can preview the result of students by option.

9. Now click on Finish & Merge option and select Edit Individual Documents from the menu. A dialog box Merge to New Document will open. Choose option All and click OK to show the report card of all the students in excel worksheet.

10. Now a new Word document will open having report card of all the students. Save this document and we can also take printouts.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...