It's really easier to do with a report in Access.

Word does not really have the ability to do a multiple items per condition
merge:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Lydia" wrote in message
...
I am trying to do a mail merge using the results of an Access query.
My input looks like this (abbreviated):
1 smith title1
1 smith title2
1 smith title3
2 jones title4
I expect 2 letters, one to Smith with the 3 titles listed. The second to
Jones with one title listed. What I'm getting is 4 letters.

Is this possible?
--
Lydia