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
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: