Combining merge records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Resources - 23 Jan 2008 15:51 GMT

Excel spreadsheet contains data as follows:
StuRef    Forename    Surname    Grade    Subject
S53113    Rhian    Oxenham    B/C    Business Studies AS - 2006
S53140    Danielle    Owen    E    ICT AS - 2006
S53140    Danielle    Owen    U    Business Studies AS - 2006
S54505    Charlotte    Bladen    A    Law AS - 2006
S54721    Kylie    Jones    D/C    Sociology AS - 2006
S54721    Kylie    Jones    D    Psychology AS - 2006
S65465    Stephanie    Morris    C    Performance Studies AS - 2006
S65465    Stephanie    Morris    C    English Language AS - 2006
S65470    Sean    Welsh    C/D    Film Studies AS - 2006
S65470    Sean    Welsh    D/E    Media Studies AS - 2006
S65472    Kathryn    Stevens    A/B    German AS - 2006
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

Reply to this Message

Doug Robbins - Word MVP - 23 Jan 2008 19:53 GMT

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

Signature

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

> Excel spreadsheet contains data as follows:
> StuRef Forename Surname Grade Subject
[quoted text clipped - 36 lines]
>
> Yours sincerely

Reply to this Message