How do I group information to combine multiple rows into one for mail merge

While I've found some information on this, nothing has worked for me so far, so I'm hoping that an expert here can help me.  We have an Excel spreadsheet that contain 700+ rows of Attorney names and their active client/matters.  We would like to use Word's mail merge, to send one email message per attorney that displays all of the attorney's Active matters.

Please see the attached for a sample of the layout of the data.

I know that we could use Access, but we'd really like to use Word if possible.  

Thanks in advance.
Test-Data.xls
LVL 14
Stacy BrownSenior Applications AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian WithunCommented:
I was trying to do something with MSQuery to run an aggregate query function like COUNT() / GROUP BY.

I haven't figured it out yet but I'm out of time for now.  Even if the idea works, that would only get you to "Dear <client>, You have <count> Matters to deal with"

Rather than, "Dear <client>, You have <Matter1>, <Matter2>, and <Matter3>."

I don't have any awesome ideas for how to do that last part.. itemizing the records.

Brian

0
Stacy BrownSenior Applications AdministratorAuthor Commented:
Thanks for trying Brian.  I do need a listing of all the matters, though.

Anyone else?
0
Stacy BrownSenior Applications AdministratorAuthor Commented:
We ended up using a module in Access to recompile the Excel spreadsheet and then the merge went along just fine.  Thanks to all who tried.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.