"Group By" or "Pivot Merge"

[Michel]

I am looking to do something that is very similar to a
Group By function in a database, or a pivot table in
Excel.

I have a table that looks something like:

EventID First Last
1 michel girard
1 john doe
2 jane smith
3 tom smith

What I want is on each page, create a print merge that
just lists out all the first and last names for each
unique event ID.

I can do this in Access or Excel. The reason I don't use
those apps because I am really going to do a print merge
to email and automatically email resutls. I can't do
that with Access or Excel.

Thanks
Michel

 

[Doug Robbins - Word MVP]

HI Michel,

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

You might also be interested in xpertdoc from www.xpertdoc.com.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP