Need to 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

 

[Fluff]

Duplicate to: Need to create a merge document for each entry in word using excel

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread