Combining merge records

R

Resources

Excel spreadsheet contains data as follows:
StuRef Forename Surname Grade Subject

Want to create one letter to each student incorporating any subject and
grade that appears against a student with the same StuRef. What follows is
my attempt so far but something is wrong as I'm getting a separate letter for
students for each subject that they are taking. Can anyone help please?


Dear Parent/Guardian

{MERGEFIELD Forename} {MERGEFIELD Surname} {MERGEFIELD "StuRef"} {if
{MERGESEQ} = "1" "{MERGEFIELD StuRef" ""} {SET Place1 {MERGEFIELD StuRef}}
{if {Place2} <> {Place1

{MERGEFIELD "Subject"} MERGEFIELD "Grade"}

{MERGEFIELD StuRef}}

Page break........

}
Staff have recently............ etc. etc.

{MERGEFIELD "Subject"} {MERGEFIELD "Grade"}

Consultation evenings ………etc. etc.

Yours sincerely
 
Last edited by a moderator:
D

Doug Robbins - Word MVP

Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or possibly the information in the following article will be the way in
which you would want to do it:

http://cornell.veplan.net/article.aspx?&a=3815


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
Last edited by a moderator:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top