First off hello from DuPont WA. I am an Assistant principal at our middle school. Here is my project (and issues):

I created an excel document for each grade level with the fields being:

Student Name, Teacher Name, #Missing Assingments, Period


I have sorted data and even added another field with numbers assigned to each student but I can not figure out how to move on.

ie


1 john doe mrs smith 3 2 (1 being the assigned #)


1 john doe mrs brown 2 4

2 joe doopie mrs smith 5 2
3 Sue double mrs smith 3 4

I would like to have a letter go to john doe with his missing work on one page then joe doopie get his own letter (same info) with his missing work and so on.

Im really a newbie to mail merge so any help would be HUGE!!!

Hi jnstrom,

It really isn't clear what the issue is.

If it's just a simple letter, with one record per recipient, a standard letter merge should do.

If you have multiple records per recipient, you can use Word's Catalogue/Directory Mailmerge facility (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

For a recent, worked example, see the attachment to post #13 at: https://www.msofficeforums.com/mail-...nt-dollar.html

Alternatively, you may want to try the Many to One utility on the MergeTools Add-in that you can download from the following page of Doug Robbins' Windows Live SkyDrive: https://skydrive.live.com/?cid=5aedc...615E886B%21111

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]