Create a merge document for each entry in word using excel

[anuradhagrewal]

Hi
I have this document with all the students marks for a given term. The same can be accessed here

SAMPLE.xlsx

docs.google.com

What I am trying to figure out that if there is a way in excel that the output of the data (from the sample.xlsx) be written by a macros in a word file (output.docx) in this format given below

output.docx

Session: XXXXXXXX Assessment Admission No. Student’s Name: Father’s Name: Mother’s Name: Date of Birth: Class/Section: House: Unity Attendance: Scholastic Areas Term-1 (100 Mar...

docs.google.com

Also I am looking to have a separate word document created for each entry with the student name ,class and section.
For eg I get a marksheet of lets say Alex then can the word document be named like "Alex-XII-A.docx"

Please please help me out.

Best Wishes

Anuradha

 

[ranman256]

make your word template document
then run :Step by Step Mail Merge Wizard.

 

[anuradhagrewal]

make your word template document
then run :Step by Step Mail Merge Wizard.

This would not solve my problem