View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Contro
 
Posts: n/a
Default Mail Merge all things to one page

Hi guys!

Basically, my problem (which I'm sure is a common one), is that I'm
trying to merge, from an access database query, fields to a single
document, but they come out on multiple documents.

I am basically trying to create a kind of examination report card for
students. There is a candidate form for their name, dob etc, and a
subform for their exam subjects and corresonponding grades. I want all
these grades and subjects to appear on each candidate's card, not a new
card for each candidate's subject and grade

Basically, this is what I want using fields name, dob, and subject and
grade (last two in subform)

Bobby Smith dob 19th July 1990
English Grade B
Spanish Grade D

but at the moment I'm getting:

Bobby Smith dob 19th July 1990
English Grade B

Bobby Smith dob 19th July 1990
Spanish Grade D

two documents instead of one.

Now I have had a look for possible solutions to this, and have found a
microsoft site

http://support.microsoft.com/?kbid=105888

which I do believe gives a solution to the problem, but I don't
understand it enough to change it to my context. This was found via
http://homepage.swissonline.ch/cindymeister

so if you could help me out by spelling it out a bit, that would be
great, as this would be such a great help!

Thank you very much in advance!

Contro.