Mail Merge to group records by a particular field

Topic

New Reply

I am trying to create a mail merge letter which needs to include several records, a repeating detail section, on each letter. It is for teaching contracts and needs to list each class for the teacher. Some teachers have only 1 class but others have anything up to 5. I’m using an excel file as the data source.

The fields are similar to: TeacherID, Name, Subject, Class, HourlyRate, Hours. I’ve looked at the NEXTIF option but can’t figure out how to make it work…

Reply | Quote

Replies

See macropod’s Mailmerge Tutorial: Create Sorted Listings (2000-2007).

Reply | Quote

I looked at the tutorial but it didn’t seem to do what I wanted.

I need to have a basic mail merge with the possibilty of repeating 3 or 4 fields for some documents. Maybe I’m just having a slow brain day

Reply | Quote

In macropod’s examples, the data are grouped by City or by State; the same principle would apply to your mail merge, with TeacherID as field to group by.

Reply | Quote