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

Sheet1 ADMISSION NO,STUDENTS NAME,FATHER'S NAME,MOTHER'S NAME,DATE OF BIRTH,CLASS,SECTION,HOUSE,ATTENDANCE,TERM 1,TERM 2 Subject 1,Subject 2,Subject 3,Subject 4,Subject 5,Subject 6,Subject 7,Subject 8,Subject 1,Subject 2 233,Alex,Joe,Sandra,9/12/2011,XII,A,BLUE,57,47,45,49,56,46,41,42,44,52,58 242

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

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