Merge summary

[jforget1]

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

 

[Cindy M -WordMVP-]

Hi Jforget1,

My website, the mail merge FAQ, Special Merges section.
You'll find a discussion there about "one-to-many" and the
possible approaches. There are links to sample files. If the
"many" stuff you want to show can be in table format, take a
close look at the DATABASE field approach.

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.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail