We're preparing for a giant mailing in which we'll be using a
spreadsheet of addresses. Each person has their own record, even if
they're at the same address as their husband, for example. However,
when we do the merge, for addresses with multiple people with identical
last names, they should only get one piece of mail. We want the
address block to say, "The Adams Family" and the salutation line to
say, "Dear Alice, John, and Ephram,"

So right now, our spreadsheet goes like this:

First Name | Last Name | Address | City | State | Zip

Using the example above, Alice, John and Ephram would each have a
separate row, and the address would be repeated three times.

I've already got a macro to combine two-person households into "The
Adams Family". What I'd like to do is turn the three different rows
from the example above into this:

First Name | Last Name | Address | City | State | Zip | Name 1 | Name 2
| Name 3 | Name 4 | etc...

Therefore, each address has one row and records are kept of each person
at that address.

I need to be able to remove people whose names were transferred;
currently, my macro just deletes them.


How can I create a macro for this?

Thanks in advance...