You can export a full report of all messages in every status by using the Export Report links on the Reports page.

You can choose to export a full report.

Or you can export data from any of the tabs on the report.

You can also export data directly from the activity screen based on filters you choose.