Exporting Excel data into a MS word document?

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.

Export Excel To Word

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.