SIMS .net mailmerge to parents separately

[ellejaybee]

Sorry if this has been covered elsewhere but I am tearing my hair out over what is probably a very simple problem.

A number of students require correspondence sending to both their parents at separate addresses. Both parents details are entered on SIMS and the 'correspondence' box checked.

However, when I run a report to mailmerge letters, it only picks up the student's home address. I can't seem to figure out how to ask for the second parent's details to be entered onto a duplicate letter.

I'm guessing it's something to do with defining contacts but whatever I try doesn't seem to work.

Any help would be greatly appreciated.

[ChrisH]

On one of my reports I have

for contacts of each datacollectionsheet where Priority is 1

This is for a datasheet though and not a normal report ie data only colledted for that one pupil. Anyway see if this field exists on the normal report and maybe try a run of priority 1 and 2.