Grouped Mail Merge

[AyJayEL]

I have a data source like this.

Name Base Email Course Date
Fred Home b@C Learn 3/6/07
Fred Home b@C Get etc 4/5/06
Jenny House j@D Learn 3/6/07
Jenny House j@d Yes do 5/4/06
Jenny House j@d People 7/8/06
Peter School d@f Learn 3/6/07
Peter School d @f Get etc 4/5/06

I want to create a mail merge that will put the courses for a person onto one page/letter. So there will be one letter for Fred with two courses listed. Jenny will have 3 courses and Peter two.

Can anyone tell me if this is possible and if so how. I don't know how many courses there may be. It could vary up around 20 per person. My source is an excel spreadsheet. I'm using Office 2003.

Learn something new every day
Using Crystal 8, Oracle Database Paint Shop Pro X1 Nikon D80

 

[AyJayEL]

I've worked out how to group records on a page. It works well. Unfortunately though you cannot send a catalogue through the email mail merge

Anyway, what you do (in case anyone wants to know) in Office 2002 is create a mail merge catalogue. Then use this formula/merge. (Taken from the Knowledgebase)

The key field in this example is { MERGEFIELD City }. When the value of City changes in the data file to a different city, a new page is added to the merged results, and the merge operation continues at the top of the next page. To insert the field braces, press CTRL+F9.
{ If { MERGESEQ } = "1" "{ MERGEFIELD City }" ""}<ENTER>
{ SET Place1 { MERGEFIELD City }}<ENTER>
{ If { Place2 } <> { Place1 }"<ENTER>
----------------------------Page Break--------------------------------
{ MERGEFIELD City }<ENTER>
<ENTER>
{ MERGEFIELD Employee }{ MERGEFIELD Sales }" "{ MERGEFIELD Employee }{ MERGEFIELD Sales }" }{ SET Place2 { MERGEFIELD City }}<ENTER>
NOTE: To insert a page break, either press CTRL+ENTER, or click Break on the Insert menu, select Page Break, and then click OK.


Learn something new every day
Using Crystal 8, Oracle Database Paint Shop Pro X1 Nikon D80