merging spreadsheet with reports

  • Thread starter Thread starter Sherry McAllister
  • Start date Start date
S

Sherry McAllister

I'm a teacher who uses an Excel spreadsheet to average
grades. I'd like to merge each students row of grades and
average into a Progress Report in Word. Do I need an
object link and a mail merge or what?
 
You could do a main merge in Word. Set up your table in Excel with a
heading in each column, and rows of student data below, with no blank rows.

In Word, set up your report, then use the Mail Merge wizard to connect
to Excel. Add the fields to the report (e.g. Name, Score1, etc.), and
merge the document with the list.
 
Back
Top