This article may be out of date!
Visit the New Knowledge Center

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