San Diego’s got 2020 vision. Get your pass to the Clio Cloud Conference, October 15-16, 2020, at Year End prices!

How to Generate a Report of Matters with Mailing Addresses


  • Generate Matter Report with Client's Street Address
  • Combine Matter Report with Contact Information 


  • Clio Manage

Additional Information:



  1. Generate a Matters Export
  2. Generate a Contacts Export
  3. Open both exports in Excel
  4. In the Matters Export, use VLOOKUP to cross reference the mailing addresses from the Contacts Export
  5. Filter the Matter Export as needed, e.g. for Open matters only


Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality