• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

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.
Stacy Brown
Stacy Brown
  • 2
1 Solution
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.


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

Anyone else?
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now