Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking Excel and Word
I am a teacher and have a Student Report template in word. Also all my
students info in mail merging. I would like to enter my students grades into an Excel spreadsheet; link it to word and use the mailmerging feature to print all these reports at once. I have not been able to figure out how to get the grades of each student to link to that particular students report card. Is there a way of perhaps making a "name" field in Excel and one in Word so the right grades would go the right students report? I hope someone will understand what I am trying to do. Thanx |
#2
|
|||
|
|||
In Excel, you need headings for the fields for you student data (which
presumably you have already) then in Word, create a merge document (ToolsMail MergeCreate) Select your data source (the Excel workbook) the edit your Word document and add the fields where necessary using the Mail-Merge toolbar "Ria" wrote: I am a teacher and have a Student Report template in word. Also all my students info in mail merging. I would like to enter my students grades into an Excel spreadsheet; link it to word and use the mailmerging feature to print all these reports at once. I have not been able to figure out how to get the grades of each student to link to that particular students report card. Is there a way of perhaps making a "name" field in Excel and one in Word so the right grades would go the right students report? I hope someone will understand what I am trying to do. Thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
Inserting Photos into Excel and linking to Word. | Excel Discussion (Misc queries) | |||
Linking excel with word / publisher | Excel Worksheet Functions |