Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2007

Tip: Looking for answers? Try searching our database.

need help producing individual student reports from spreadsheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
teacher - 29 Sep 2007 15:28 GMT
Hi,

I am a teacher trying to create individual grade reports for my students.  I
believe there is an easy way to extract/produce individual progress reports
from my excel gradebook, but I'm not sure how to do this. Does anyone know
how to do this?

Thanks!
Peter Jamieson - 01 Oct 2007 08:08 GMT
Word isn't really designed to do this, but a starting point for doing this
without VBA is the MS Knowledgebase article at

http://support.microsoft.com/kb/211303

Imaigine that instead of "City" you have  "Subject", instead of "Employee"
you have "Student", and instead of "Sales" you have "Grade".

However, you may of course have other stuff that affects the structure of
the report - e.g. grades for a particular period, or perhaps you need to
produce reports for each class or each year in turn. Things can get pretty
complicated quite quickly!

One problem is that the output of this type of merge is a single document
(it's because you have to use a Catalog/Directory type merge to do it). If
you need for example to e-mail each student with a grade report, youwould
then have to split that output into separate files and remember which one is
intended for each student.

Among other possible approaches are:
a. copy your data into Access and use Access reporting (or link to your
Excel data source). If you have Access, that's probably the best approach if
you need printed output
b. use Excel or Word VBA to "roll your own" merge that produces each report
and e-mails it.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks!
Technoteacher - 13 Oct 2007 01:04 GMT
I am also a teacher, and utilize Excel power to gather data, and mail merge
into a Word document to make individual reports.  I have even made
personalized lesson plans.  Enter your information into columns, Student
names in column A/B.  Set up form in Word using Mail merge Wizard.  Merge
wizard will show columns when you select "Items".  Try it out!  

> Hi,
>
[quoted text clipped - 4 lines]
>
> Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.