Catalog merge for directory

[hansella2z]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am trying to make a directory that starts a new grade on a new page. The "GR" grade field exists in my data source (excel file). I don't need the GR field to print but I would like to filter each grade to start a new page or section. I was trying to use a section break (new page) but that's obviously not correct because you can't have a different filter in each section. Please help.

The fields are listed like this.

«Student»
«Parent_or_Guardian»
«Phone»
«Home_address»
«Email_Address»

 

[Peter Jamieson]

If you're doing what I think you're doing, a set of fields like

{ IF { MERGESEQ } = 1 "{ SET GRlocal "{ MERGEFIELD GR }" }"
}{ IF "{ MERGEFIELD GR }" <> "{ REF GRLocal }"
"
<put a new page character here>" "" }
«Student»
«Parent_or_Guardian»
«Phone»
«Home_address»
«Email_Address»{ SET GRLocal "{ MERGEFIELD GR }" }

should do it, but you may have to adjust the line breaks a bit.

 

[HankF]

Peter, I believe I am trying to do something similar to hansella2z. I am attempting to build a catalog of names broken out by the country from which they originate and have the names grouped by country on separate pages. In addition I would like to add about 10 lines of text to each page (same text on each). Finally I'd like to be able to cut and paste the information from each page of text into e-mail. Do you think your response would work for me as well? Please excuse my ignorance but I don't understand how to to work with the "if statement" in your answer.
Cheers

 

[Peter Jamieson]

I suggest you have a look at macropod's tutorial at

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

I think. However, to do this kind of thing you have to do a "catalog" merge
(in order to prevent Word from putting page/section breaks in when it
processes every record), so you would then have to split the output up in
order to email it, and that's where the problems start on the Mac version of
Office. If you're using Word 2004 or are handy with AppleScript, you might
be able to adapt one of the macros at the bottom of Graham Mayor's page at

http://www.gmayor.com/individual_merge_letters.htm

Or if there are not all that many sections, you could consider do that by
hand, and emailing each resulting document probably would not be too onerous
either. There are other possible approaches but all the ones I can think of
that use Word would need even more programming than that.