Exporting Excel data into a MS word document?

Question

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.

Answer 1

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.

Answer 2

Export Excel To Word

Answer 3

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.