mailmerge question - multiple names at same address

I have an Access table as the source for the mailmerge I want to perform.  In the Access table, there is one record for each individual person. In each record, there is also the person's business address. A simplified version of my table is as follows (fields not applicable to my question are not being shown):

Last Name          First  Name        Business Street                Town            State      ZIP
Jones                  Steven              1313 Mockingbird Lane     Hollywood      CA      99999
Smith                   Mary                 1313 Mockingbird Lane     Hollywood      CA      99999
Brown                 Timothy             200 Main Street                 Brooklyn         NY     00000
White                   Donald              200 Main Street                 Brooklyn         NY      00000

What I want is one letter to go to each business address, not one letter per person. However,
in the body of the document, I want the individuals associated with that address to be listed. Using a blank Word document for example, I'd want letter 1 to be addressed as follows:

1313 Mockingbird Lane
Hollywood, CA  99999

Then, somewhere in the body of the letter, I'd like to have the two people associated with that address to be listed ( Steven Jones and Mary Smith).  Something like:

Steven Jones
Mary Smith

Letter 2 would be similar:

200 Main Street
Brooklyn, NY 00000

Somewhere in body of the letter:

Timothy Brown
Donald White

So, in summary what I'm trying to do is have one letter per business address, not one letter per individual person.  But in the letters, I want the  individual people associated with that address to be listed. Not listed in the address area but somewhere in the body of the letter. Can this be done?Start Free Trial