I have a tough problem that I cannot figure out if there
is a possible solution. I need to do a merge with cost
figure in a spreadsheet which give a "wrap-up" of a bunch
of offices. I have a spreadsheet which has an an office
such as office identity 123 and I have a annual cost
calculated. I also have in this sheet are sub-offices
under the parent office above, such as office 123-1 and
123-2. I need to do a merge that goes down a list offices
and "pulls" all the offices which are part of the same
group, in this case 123 offices. I have added a column in
my data sheet which has extracted out the office identity
by using the Left function and have created a subtotal to
get a overall cost for all of the like offices but I
cannot figure out how I can bring this data into the merge
of a letter which explains all costs.

I would appreciate any help.
Joe