Ok, before you answer the question, READ ALL OF IT. I don't need or want answers such as "just cut and paste it over".
I am currently a full time student (18 units) and a full time worker (36+ avg hours per week with 3 jobs). One of my jobs is grading computer science homework for some instructors who I took past classes with.
I am needing to create an excel worksheet (which I have already done) as a templete for grades, then export it into a stand alone word document. I need to do it this way because I have to grade at least 75 of these every 2 weeks. I am currently not able to find sufficient information on how to do this.
Any help would be greatly appreciated.
TheHumbleOne2007-02-19T10:24:53Z
Favorite Answer
A Word document for what? To report all grades or to send an individual report to each student.
This sounds like plain and simple Mailmerge. I do this regularly -- here are my notes for a letter. Of course you can create a Word form and place the fields, create labels, a catalog which allows you to create a report of selected fields, ...
MailMerge with Word and Excel - a letter
You need a main document (letter) and a datafile (Excel). The Excel file must have column headings (name, course, grade, ...)
First, compose your letter. Where you want name, address, etc., type some sort of marker like an X.
click Tools cl Mailmerge You should get the Mailmerge Helper window
cl Create cl form letter active window
cl Get Data cl Open Data Source browse to your Excel datafile, indicate in file type that it is an Excel Datafile, click Open cl o.k. to select the whole datafile
You will be told there are no merge fields in your main document click Edit Main Document (you are returned to your letter) select the first line with the x to highlight, click Insert Merge Field select the field(s) name or firstname space lastname select the second line with the x cl Insert Merge Field, cl the address select the third line, cl Insert Merge Field cl the city, state, zip
File, Save As - give your letter a name click the Merge button cl New Document
In this way, they will merge to a document which can be edited and proofread, and printed from there.
This is one of the main advantages of computers and integrated Office suites. Once you have put something on a computer in whatever program it is possible if you want to transfer it to another program, never to have to start from scratch but simply copy and paste or import/export. However, I don't see why you need to put this in Word, all you need do is highlight the data you want to print, up to File, Print, Selection and it will print only what you have selected. You also can go into page set up and put your grid lines in if you have not already put borders, make it all larger to fit page, or decrease if it is large and also centre both horizontally and vertically. Just have a look at the tabs available in the page set up window, page margins, header/footer and sheet.