"TDRK" wrote:

Using a Microsoft Office database,...


When you say "a MS Office database" do you mean "MS Access"?


...I would like to create a mail merge letter
addressed to the advisor field, and include all student names, in the name
field, who are assigned to the advisor. I would like one letter/advisor.
How do I pull one letter for each advisor and insert the mergefields to
include all students associated with that advisor?
I am using Microsoft Office 2003 and windows XP.

This question may be better suited for the the "Mailmerge and Fax" newsgroup
of Office-Word, rather than the "General Questions".

One way to approch this might be to just use Access (if you are using Access
and know how to use it) and not even bother with Word. Your form letter
could be set up as report that can be printed out.

Keep in mind that I'm not an expert nor MVP, I'm a student somewhat
knowlegable in the MS Office programs. Anyone else with some better ideas,
please feel free to chime in.

I hope this helps some,

Conan Kelly