Hi Dani B. If you were able to get the subtotals, what you could do next is
collapse the table so that only the names and subtotals are showing. Then
press F5, click on special and select visible cells only. Copy and paste
into a new worksheet and you will have just each name once with the total
deposit. Use this sheet for your mailmerge into word. Before you do,
though, hide all unused columns and rows because they will be selected too
when you copy and you will wind up with a massive file.
--
Sincerely, Michael Colvin


"Dani B via OfficeKB.com" wrote:


The thing is, I'll still have the name showing up 2 or 3 times, since it is
repeated in the name column every time there is another deposit added. I got
the subtotals thing to work from the post above, but I need to find a way
still for the subtotals to go into a whole new column rather than being below
the other numbers, and I also need to find a way for the names that are the
same to only show up in the mail merge once. Thanks for the great
suggestions so far!

Michael wrote:
Hi Dani. Could you put the name and deposit amounts in separate columns on
the same row and then have a total column? If so, you could do your mail
merge using the name and the total column.
I'm doing a mail merge from Excel to Word, and It worked out fine. I have 3
feilds: Name, Unit, and Deposit. The problem is, I have about 2 to 4
[quoted text clipped - 8 lines]
for the $10? Sorry this is so sloppy, but if someone could help me out with
this I would GREATLY appreciate it! Thanks so much.


--
Message posted via http://www.officekb.com